Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Some OS level threshold for performance. Linux/Unix
  • Oracle Support Metalink ID 161818.1 Oracle
  • normal maintenance for exp-imp and renaming table Oracle
  • How do I get Oracle to automatically start when my server boots up? Oracle
  • EXTPROC Oracle
  • restarting network in linux Linux/Unix
  • When to rebuld B-tree index Oracle
  • Find long Running Transaction Linux/Unix
  • Process Map for CPU and Memory for OS processes Linux/Unix
  • TOP-N Sql to find Nth max or Top N rows Oracle
  • To find all disk io ( EMC as well as local) Linux/Unix
  • Find_planinfo.sql Oracle
  • arch_configUOCIOTTO.ora Oracle
  • oracle 11g RAC on vmware Oracle
  • create trigger syntax 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

  • Oracle Support Metalink ID 161818.1 Oracle
  • ORA-8031 issue and solution if it is occuring due to truncate. Oracle
  • AWR license Oracle
  • ORA-3136 Oracle
  • Nice notes on wait events Oracle
  • Load testing on Oracle 19C RAC with HammerDB Oracle

Leave a Reply Cancel reply

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

Categories

  • AWS (2)
  • Azure (1)
  • Linux/Unix (149)
  • Oracle (392)
  • PHP/MYSQL/Wordpress (10)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (341)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • load SPM baseline from cursor cache05-Jun-2025
  • Drop all SPM baselines for SQL handle05-Jun-2025
  • Load SPM baseline from AWR05-Jun-2025
  • Drop specific SQL plan baseline – spm05-Jun-2025
  • findinfo.sql (SQL for getting CPU and Active session info)27-May-2025
  • SQL Tracker by SID sqltrackerbysid.sql22-Apr-2025
  • How to connect to Oracle Database with Wallet with Python.21-Mar-2025
  • JSON/XML Types in Oracle18-Mar-2025
  • CPU Core related projections12-Mar-2025
  • Exadata Basics10-Dec-2024

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • telnet listening Linux/Unix
  • Session_info.ksh Linux/Unix
  • fkwoindex.sql /* Find FK without Index */ Oracle
  • currwaitobj.sql SQl_ID and SQL statement you can get from currwaitobj.sql Oracle
  • Getting started with notebook Python/PySpark
  • chk_space_SID.ksh Linux/Unix
  • My Minimum Tuning Programs Oracle
  • to see when crontab is changed. Linux/Unix

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme