ORA-06512: at "SYS.DBMS_STATS
Hello,
recently, we receive an email with the message "Failed to connect to database instance: ORA-12518: TNS:listener could not hand off client connection (DBD ERROR: OCIServerAttach)", I've review the reports on the folder "E:\oracle\product\10.2.0\admin\ENCYNEW\bdump" and at 22.06 every day there is a trace file with the following:
*** 2010-08-09 22:05:44.914
*** ACTION NAME:(GATHER_STATS_JOB) 2010-08-09 22:05:44.868
*** MODULE NAME:(DBMS_SCHEDULER) 2010-08-09 22:05:44.868
*** SERVICE NAME:(SYS$USERS) 2010-08-09 22:05:44.868
*** SESSION ID:(108.43917) 2010-08-09 22:05:44.868
ORA-12801: error signaled in parallel query server P001
ORA-04030: out of process memory when trying to allocate 64528 bytes (sort subheap,sort key)
*** 2010-08-09 22:05:44.930
GATHER_STATS_JOB: GATHER_TABLE_STATS('"ENCY"','"DOBJ"','""', ...)
ORA-12801: error signaled in parallel query server P001
ORA-04030: out of process memory when trying to allocate 64528 bytes (sort subheap,sort key)
*** 2010-08-09 22:05:44.961
ORA-12012: error on auto execute of job 8911
ORA-04030: out of process memory when trying to allocate ORA-04030: out of process memory when trying to allocate 123404 bytes (QERHJ hash-joi,kllcqas:kllsltba)
ORA-12801: error signaled in parallel query server P001
ORA-04030: out of process memory when trying to allocate 64528 bytes (sort subheap,sort key)
ORA-06512: at "SYS.DBMS_STATS", line 19483
bytes (,)
at 22.00 is when the statistics job is running:
General
Nombre GATHER_STATS_JOB
Identificador de Log 183851
Propietario SYS
Nombre de Usuario
Operación RUN
Estado FAILED
Fecha de Log 09-ago-2010 22:05:45 +02:00
Detalle de Ejecución
Fecha de Inicio de Solicitud
Fecha de Inicio Real 09-ago-2010 22:00:02 +02:00
Número de Error 4030
Duración de Ejecución (minutos) 5.71
CPU Usada (segundos) 48.58
Identificador de Instancia 1
Identificador de Sesión 108,43917
Identificador de Proceso 1844
Detalles ORA-04030: out of process memory when trying to allocate ORA-04030: out of process memory when trying to allocate 123404 bytes (QERHJ hash-joi,kllcqas:kllsltba) ORA-12801: error signaled in parallel query server P001 ORA-04030: out of process memory when trying to allocate 64528 bytes (sort subheap,sort key) ORA-06512: at "SYS.DBMS_STATS", line 19483 bytes (,)
The last one was running succesfull was the 3rd of August. How can I solve the error?
Regards,
Beatriz.