There many popular reports or select statements to rech and understand what happen in the db. I usually use the built in function of PL/SQL developer application.
I collected what kind of privileges you have to ask to use it. because very often you dont have DBA rights. Just ask SELECT for these:
Main window: v_$session
Cursors tab: v_$open_cursor
SQL Text tab: v_$sqltext_with_newlines
Statistics tab: v_$sesstat,
v_$statname
Locks tab: v_$lock
good to have also:
I collected what kind of privileges you have to ask to use it. because very often you dont have DBA rights. Just ask SELECT for these:
Main window: v_$session
Cursors tab: v_$open_cursor
SQL Text tab: v_$sqltext_with_newlines
Statistics tab: v_$sesstat,
v_$statname
Locks tab: v_$lock
good to have also:
v$sql
v$transaction
v$mystat
v$sgainfo
No comments:
Post a Comment