SP hangs while recompiling. Is it Oracle BUG or just a FEATURE ?
Date: 1998/01/07
Message-ID: <01bd1ba2$1722a400$79a06080_at_sdidur-1>#1/1
(Main Pakage SP) - call -> (8 support package SP) - process -> (1 table per SP)
When we call any main package SP from ProC program and in the same time
invalidate
any of refered packages with DROP/CREATE table, all Oracle connections,
that use this package hangs. CPU usage drops to 0.1 %.
When we kill ProC programs all other calls complete successfully.
When we do the same, but call main package SP from SQL Plus - no problems.
When we invalidate package in the same way, but call any SP later - Oracle successfully recompile package and execute this SP.
So my assumption, that Oracle can't recompile package when any of its SP is in use.
Does anybody have any similar expirience ? Is it a Oracle BUG or just a FEATURE ?
We use Oracle 7.3.2 on HP UNIX machine.
-- Sergei Didur Systems AnalystReceived on Wed Jan 07 1998 - 00:00:00 CET