Cant shutdown database
Hi!
I racompile object in my production database: EXEC DBMS_UTILITY.compile_schema(schema => 'MySchema'); . i have 4 view to compile.
In Oracle EM console i have wait 9/10 so want know why.
1. I do it:
SELECT * FROM v$session_event
WHERE WAIT_CLASS='Concurrency'
ORDER BY TOTAL_WAITS DESC;
4 cursor: pin S 1 0 199081 199081,14 0 1990811438 352301881 3875070507 4 Concurrency
169 cursor: pin S 1 0 176225 176225,49 0 1762254945 352301881 3875070507 4 Concurrency
50 cursor: pin S 1 0 35454 35453,73 0 354537273 352301881 3875070507 4 Concurrency
128 os thread startup 1595 0 2841 1,78 136 28413673 86156091 3875070507 4 Concurrency
290 os thread startup 197 0 344 1,75 16 3444475 86156091 3875070507 4 Concurrency
131 os thread startup 71 0 118 1,67 2 1184916 86156091 3875070507 4 Concurrency
250 latch: shared pool 59 0 59 1 8 591665 2696347763 3875070507 4 Concurrency
46 latch: shared pool 31 0 52 1,68 19 520188 2696347763 3875070507 4 Concurrency
294 latch: shared pool 34 0 34 1 6 340664 2696347763 3875070507 4 Concurrency
44 latch: shared pool 32 0 29 0,91 7 290355 2696347763 3875070507 4 Concurrency
128 latch: shared pool 14 0 24 1,72 14 240264 2696347763 3875070507 4 Concurrency
84 latch: shared pool 13 0 13 1 4 129761 2696347763 3875070507 4 Concurrency
295 library cache lock 1 0 9 9,41 9 94134 916468430 3875070507 4 Concurrency
0