Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Finding locked objects Oracle
  • move_arch_files.ksh Linux/Unix
  • purge_trc.sh Linux/Unix
  • oracle_env_10g_CADEV Linux/Unix
  • switchover for primary database Oracle
  • Error Handling in Proc Oracle
  • Oracle 11g Training on 29JAN1010 Oracle
  • block_ident.sql Oracle
  • Renaming Global Name GLOBAL_NAME Oracle
  • ext#.sql Oracle
  • Space padding in korn shell Linux/Unix
  • metalink all dynamic view reference notes. Oracle
  • Linux CPU info. Linux/Unix
  • Difference between SYNC and AFFIRM Oracle
  • Wait.sql Oracle

Tag: OCI

Wait.sql

Posted on 04-Apr-202322-Apr-2025 By Admin No Comments on Wait.sql

/********************************************Author: Paresh MehtaScript Name : waitt.sqlwaits order by sql start time********************************************/set feedback 1set pages 2000set lines 190column event format a45column machin format a12column modul format a10column prg format a10column osuser1 format a10column username format a10column sesinfo format a15column blockedby format a15alter session set nls_date_format=’DDMONRR:HH24:MI:SS’;select /*+ first_rows(100) */ a.sid || ‘,’ || a.serial# || ‘,@’ ||…

Read More “Wait.sql” »

Oracle, SQL scripts

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
  • Absolute file number and relative file number Oracle
  • Committing distributed transaction using commit force Oracle
  • dbinv.sql Oracle
  • How to choose Driver table in SQL statement Oracle
  • Oracle Release Explaination Oracle
  • Shuffle an array PHP/MYSQL/Wordpress
  • Metalink Note: Note:250655.1 : ADDM Basics USING THE AUTOMATIC DATABASE DIAGNOSTIC MONITOR Oracle
  • Explain Plan Output 2 Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme