PL/SQL (MOSC)

MOSC Banner

11GR2: PL/SQL lock timer as top event

edited Aug 4, 2017 1:09PM in PL/SQL (MOSC) 4 commentsAnswered

Hi All,

I need your help in top timed events from spreport.    Here is a snapshot of  top 5 timed events

Top 5 Timed Events                                                    Avg %Total

~~~~~~~~~~~~~~~~~~                                                   wait   Call

Event                                            Waits    Time (s)   (ms)   Time

----------------------------------------- ------------ ----------- ------ ------

PL/SQL lock timer                                2,326      20,390   8766   55.3

CPU time                                                    10,393          28.2

db file sequential read                     11,233,712       2,505      0    6.8

direct path read                            21,237,205       1,023      0    2.8

db file scattered read                      12,716,541         643      0    1.7

          -------------------------------------------------------------

How do I check , which pl sql is the cause of PL/SQL lock timer.    This is consistent in all the spreports.      We do not have license for AWR (diagnostic) and hence am using spreport for troubleshooting.    Any inputs on how to reduce this wait event would be helpful

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