| external table how to check if currently open [message #686212] |
Fri, 01 July 2022 14:32  |
wtolentino
Messages: 420
Registered: March 2005
|
Senior Member |
|
|
we are unable to compile/drop a package that is hanging or throwing this error:
ORA-04021: timeout occurred while waiting to lock object
currently at the time the package is compiled there are no objects/tables locks nor any other users connected to the database and/or blocking sessions. we purposely had instructed users not to connect/login to the database so to diagnose the issue.
then we run a trace and trace file shows that there is an external table that is open
Chains most likely to have caused the hang:
[a] Chain 1 Signature: 'external table open'<='library cache pin'
Chain 1 Signature Hash: 0x18ad84a0
[b] Chain 2 Signature: 'REPL Capture/Apply: RAC AQ qmn coordinator'
Chain 2 Signature Hash: 0x38f1e28b
[c] Chain 3 Signature: 'external table open'
Chain 3 Signature Hash: 0xac7f5618
how do we check what are the external tables that are in-use or currently open? please advise.
thanks so much in advanced.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
