Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Paste command syntax Linux/Unix
  • block_ident.sql Oracle
  • Changing default shell Linux/Unix
  • JSON/XML Types in Oracle Oracle
  • mutex in Oracle 10.2.0.2 or Oracle 10g Oracle
  • currwaitobj.sql SQl_ID and SQL statement you can get from currwaitobj.sql Oracle
  • Search and replace pattern Linux/Unix
  • Reading config file from other folder inside class Python/PySpark
  • Guide to Linux System Command Mastery Linux/Unix
  • ORA-00064: object is too large to allocate on this O/S during startup Oracle
  • Histogram information Oracle
  • Good Link from metalink 1 Oracle
  • Jai Shree Ram Oracle
  • Locktree.sql Oracle
  • metalink all dynamic view reference notes. Oracle

sesswait.sql

Posted on 02-Aug-2005 By Admin No Comments on sesswait.sql

set pages 300

set lines 151

column event format a30

column p1_detail format a25

column p2_detail format a15

column p3_detail format a5

column sid format a15

column wait_time format 999999

column seconds_in_wait format 999999999

column state format a30 word_wrapped

select

A.SID ||’,’ || A.seq# sid ,

A.EVENT,

A.P1TEXT || ‘=’ || A.P1 p1_detail,

A.P2TEXT || ‘=’ || A.P2 p2_detail,

A.P3TEXT || ‘=’ || A.P3 p3_detail,

A.WAIT_TIME,

A.SECONDS_IN_WAIT,

A.STATE

from v$session_wait A

order by event

;

Oracle, SQL scripts

Post navigation

Previous Post: Wait time tuning research
Next Post: ext#.sql

Related Posts

  • Identical Dblink Issue… Oracle
  • ext#.sql Oracle
  • currwait.sql Oracle
  • UTL_FILE test program Oracle
  • DBMS_UTILITY.ANALYZE_SCHEMA Oracle
  • normal maintenance for exp-imp and renaming table 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
  • Changing default shell Linux/Unix
  • Good RAC & Standby Notes Oracle
  • sess1.sql Oracle
  • Finding Oracle Patches with opatch Oracle
  • SQL Tracker by SID sqltrackerbysid.sql Oracle
  • proc.sql Oracle
  • oracle Dba site Oracle
  • get_aix_vmstat.ksh Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme