tutorailwale

Query To Find Database Size QUERY TO FIND DATABASE SIZESELECT … Read more

Query To Find Long Running SQL Statements SELECT s.rows_processed,s.loads,s.executions,s.buffer_gets,s.disk_reads,t.sql_text,s.MODULE,s.actionFROM v$sql/area/ … Read more

Query To Find Undo Tablespace Usage SELECT s.username,s.sid,rn.name,rs.rssize / 1024 … Read more

Query To Check For Table Locks SELECT a.sid,a.serial#,a.username,c.os_user_name,a.terminal,b.object_id,Substr(b.object_name, 1, 40) … Read more

Query To Find Active Sessions In Database SELECT ‘ACTIVE SESSION’,sid,serial#,machine,osuser,username,statusFROM … Read more

Query To Check Users, Sessions, CPU, and I/O Consumption SELECT … Read more

Query To Check Open Cursor By User SELECT SUM(a.value) total_cur,Avg(a.value) … Read more

Query To Check Top 10 Database Load Queries SELECT *FROM … Read more

Query To Check List Of Locks In The Database SELECT … Read more

Query To Check Blocking Sessions Per User SELECT s1.username|| ‘@’|| … Read more