Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • OPENING A STANDBY DATABASE IN READ-ONLY MODE Oracle
  • How to Use DBMS_STATS to Move Statistics to a Different Database Oracle
  • DBMS_PROFILER for tuning PLSQL programs. Oracle
  • sql_doing_fts.sql Oracle
  • Directory wise folder wise space usage Linux/Unix
  • Running some SQL on multiple databases connecting using monitoring userid and password Linux/Unix
  • Good RAC & Standby Notes Oracle
  • xargs use Linux/Unix
  • switchlogfile.sh Linux/Unix
  • Oracle Data Direct to TAPE Oracle
  • DBMS_UTILITY.ANALYZE_SCHEMA Oracle
  • My Test Case On 21-OCT-2005 Oracle
  • Small sample shell program Linux/Unix
  • replacing ^M character when passing files from Windows to Unix Linux/Unix
  • ORA-3136 Oracle

Wait.sql

Posted on 04-Apr-202322-Apr-2025 By Admin No Comments on Wait.sql
/********************************************
Author: Paresh Mehta
Script Name : waitt.sql
waits order by sql start time
********************************************/
set feedback 1
set pages 2000
set lines 190
column event format a45
column machin format a12
column modul format a10
column prg format a10
column osuser1 format a10
column username format a10
column sesinfo format a15
column blockedby format a15
alter session set nls_date_format='DDMONRR:HH24:MI:SS';

select /*+ first_rows(100) */ a.sid || ',' || a.serial# || ',@' || a.inst_id sesinfo,
a.username, substr(a.osuser,1,10) osuser1, a.sql_id, sql_exec_start,
substr(substr(a.machine,instr(machine, '')+1),1,12) machin, substr(program,1,10) prg, substr(module, 1,10) modul, a.event,
blocking_session || '@' || blocking_instance blockedBy
from gv$session a
where status = 'ACTIVE'
and wait_class != 'Idle'
order by blocking_session desc, sql_exec_start desc
/

Oracle, SQL scripts Tags:data, database, databases, DBA, OCI, oracle, performance, tuning

Post navigation

Previous Post: CPU speed on Linux
Next Post: Find_planinfo.sql

Related Posts

  • Adding or Dropping Online Redo Log Files When Physical Standby in place Oracle
  • get_vmstat_solaris Oracle
  • create user with unlimited quota Oracle
  • Good notes on Oracle Events Oracle
  • Temporary Tablespsace Temp tablespace behaviour Oracle
  • SCRIPT TO LIST RECURSIVE DEPENDENCY BETWEEN OBJECTS UTLDTREE.sql Oracle

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Categories

  • AMC10 (0)
  • Ansible (0)
  • AWS (2)
  • Azure (1)
  • Django (0)
  • GIT (1)
  • Linux/Unix (150)
  • MYSQL (5)
  • Oracle (403)
  • PHP/MYSQL/Wordpress (10)
  • POSTGRESQL (1)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (18)
  • rman-dataguard (26)
  • shell (151)
  • SQL scripts (349)
  • SQL Server (6)
  • Uncategorized (9)
  • Videos (0)

Recent Posts

  • Tutornet.US — Source of excellent learning14-Oct-2026
  • OCI Infrastructure Patching14-Oct-2026
  • Free API credits for AI models14-Oct-2026
  • AMC1020-Sep-2026
  • Key Management in Oracle: The Core Issue: Missing Master Key12-May-2026
  • SAT Mathematics 10 questions and answer at the end.30-Apr-2026
  • top 10 AI news today30-Apr-2026
  • runon_allpdbs_show_conname.sh23-Apr-2026
  • runon_allcdbs_find_pdbs.sh23-Apr-2026
  • Running PDB on single node in RAC09-Apr-2026

Archives

  • 2026
  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • RMAN : Consistent Backup, Restore and Recovery using RMAN Oracle
  • Adding a new disk and mount it automatically. on VMWARE LINUX Linux/Unix
  • copying/removing directory with all its subdirectory Linux/Unix
  • Oracle vs MYSQL Architecture differences (For DBAs) MYSQL
  • USE_NL and INDEX hints example Oracle
  • find_pk.sql /* Find Primary Key */ Oracle
  • TOP-N Sql to find Nth max or Top N rows Oracle
  • CTAS with LONG Column for 7.x and 8 and 8i Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme