GSS error R12

[satish]

Hi erman,

Gather Schema Statistics erroring out in erp r12.2.5, can u pls guide us to fix it.

Application Object Library: Version 12.2
Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.
FNDGSCST: Gather Schema Statistics
Current system time is 05-MAR-2025 03:00:05
**Starts**05-MAR-2025 03:00:05
**Ends**05-MAR-2025 03:05:17
ORA-0000: normal, successful completion
Start of log messages from FND_FILE
+--
+-
--+
In GATHER_SCHEMA_STATS, schema_name= ALL percent= 10 degree = 8 internal_flag= NOBACKUP
stats on table WMS_WCS_AQ_QUEUE_TBL is locked
Error #1: ERROR: While GATHER_TABLE_STATS:
object_name=XXTTD.XXTTD_RMS_GL_STG_TBL***ORA-12801: error signaled in parallel query server P006, instance erpproddb2.ttd.com:prodcdb2 (2)*** +--
Error #1: ERROR: While GATHER_TABLE_STATS:
End of log messages from FND_FILE
+--
Successfully resubmitted concurrent program FNDGSCST with request ID 65211924 to start at 06-MAR-2025 03:00:00 (ROUTINE AFPSRS)
No completion options were requested.
Output file size:
e
Deleting empty output file.



object_name=XXTTD.XXTTD_RMS_GL_STG_TBL*** is custom table but what to  check is the query.
Thank you,
GD