 | |
#1
 
| |||
| |||
|
SYS.dba_ddl_locks -
12-10-2007
, 06:17 AM
#2
| |||
| |||
|
|
On Oracle 9.2.0.5, windows 2000 server, select * from SYS.dba_ddl_locks after a time being resulted with an error ORA-04030: out of process memory when trying to allocate 2628 bytes (callheap,temporary memory) later ORA-04030: out of process memory when trying to allocate 480 bytes (Typecheck heap,frodef : qcpitnm) We tried to track why compilation of the package resluted with an error ORA-04021: timeout occurred while waiting to lock object any suggestions... |
a bug or memory leak addressed by a later patch.
David Fitzjarrell
#3
| |||
| |||
|
|
On Dec 10, 6:17 am, "Tomo" <tkoko... (AT) varteks (DOT) com> wrote: On Oracle 9.2.0.5, windows 2000 server, select * from SYS.dba_ddl_locks after a time being resulted with an error ORA-04030: out of process memory when trying to allocate 2628 bytes (callheap,temporary memory) later ORA-04030: out of process memory when trying to allocate 480 bytes (Typecheck heap,frodef : qcpitnm) We tried to track why compilation of the package resluted with an error ORA-04021: timeout occurred while waiting to lock object any suggestions... Patch up to 9.2.0.8 (the terminal release of 9.2.0); it appears to be a bug or memory leak addressed by a later patch. David Fitzjarrell |
only one is recent: bug 4161164 E-Business Intelligence so I think
opening a Service Request might be necessary if the problem is
reproducible and all spare OS memory has not be exhausted.
HTH -- Mark D Powell --
#4
| |||
| |||
|
|
On Dec 11, 4:22 pm, "fitzjarr... (AT) cox (DOT) net" <fitzjarr... (AT) cox (DOT) net> wrote: On Dec 10, 6:17 am, "Tomo" <tkoko... (AT) varteks (DOT) com> wrote: On Oracle 9.2.0.5, windows 2000 server, select * from SYS.dba_ddl_locks after a time being resulted with an error ORA-04030: out of process memory when trying to allocate 2628 bytes (callheap,temporary memory) later ORA-04030: out of process memory when trying to allocate 480 bytes (Typecheck heap,frodef : qcpitnm) We tried to track why compilation of the package resluted with an error ORA-04021: timeout occurred while waiting to lock object any suggestions... Patch up to 9.2.0.8 (the terminal release of 9.2.0); it appears to be a bug or memory leak addressed by a later patch. David Fitzjarrell Searching on metalink on dba_ddl_locks only found 4 bug reports and only one is recent: bug 4161164 E-Business Intelligence so I think opening a Service Request might be necessary if the problem is reproducible and all spare OS memory has not be exhausted. HTH -- Mark D Powell -- |
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.