Count Of Active Sessions
COUNT OF ACTIVE SESSIONS SELECT Count(s.status) ACTIVE_SESSIONSFROM gv$session s,$process pWHERE … Read more
Apps DBA
Sessions Which Are In Inactive Status From More Than 1 HOUR
Sessions Which Are In Inactive Status From More Than 1 … Read more
SQL Queries to Check Active or Inactive Sessions
SQL Queries to Check Active or Inactive Sessions Total Count … Read more
Query To Find Database Redolog Temp And Control File Size
Query To Find Database Redolog Temp And Control File Size … Read more
Query To Find Database Size
Query To Find Database Size QUERY TO FIND DATABASE SIZESELECT … Read more
Query To Find Long Running SQL Statements
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
Query To Find Undo Tablespace Usage SELECT s.username,s.sid,rn.name,rs.rssize / 1024 … Read more
Query To Check For Table Locks
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
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 IO Consumption
Query To Check Users, Sessions, CPU, and I/O Consumption SELECT … Read more