Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • The most important Tuning Notes Oracle
  • replacing ^M character when passing files from Windows to Unix Linux/Unix
  • ORA-00064: object is too large to allocate on this O/S during startup Oracle
  • ext#.sql Oracle
  • run this before doing any dbchange pvm_pre_change.sql Oracle
  • How to find Unix server conguraiton including Server Model number and underlying disk sub-system ( On Solaris) Linux/Unix
  • Building Our Own Namespaces with “Create Context” Oracle
  • Session_info.ksh Linux/Unix
  • Jai Shree Ram Oracle
  • create database syntax Oracle
  • import-export with multiple files Oracle
  • Default User Profile Oracle
  • to see when crontab is changed. Linux/Unix
  • SQL_PROFILE – I explaination Oracle
  • How to know current SID 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

  • 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
  • How to see which patches are applied. Oracle
  • useful dg links Oracle
  • perf_today.sql Oracle
  • move_arch_files.ksh /* Good One */ Linux/Unix
  • To seee semaphores and shared memory segments in Solaris Linux/Unix
  • Default User Profile Oracle
  • Useful Solaris Commands on 28-SEP-2005 Linux/Unix
  • Removing Ctrl-M from end of line using vi Linux/Unix

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme