Database Administration (MOSC)

MOSC Banner

Cant shutdown database

edited Sep 7, 2013 3:19AM in Database Administration (MOSC) 13 commentsAnswered
 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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center