DBMS_CAPTURE_ADM.BUILD(); is hanging
Hello,
The call to DBMS_CAPTURE_ADM.BUILD normally succeeds and it takes less than a second.
Sometimes, when I run DBMS_CAPTURE_ADM.BUILD under the same login with the same privileges on the same oracle server, it hanging and not returning anything. The session stays active with running this procedure.
There is no other sessions of mine opened at this time. There is nothing from my activity that terminated abnormally before starting this supplied procedure.
The situation happening unexpectedly and goes away in few hours by itself (from what I see as developer). It happened twice already for the last week.