Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • To see only files and/or folders using LS command Linux/Unix
  • Guide to Linux System Command Mastery Linux/Unix
  • How to sort list of files on basis of their sizes. Linux/Unix
  • Wait time tuning research Oracle
  • move_arch_files.ksh Linux/Unix
  • Deleting first line and lastline of a file using sed Linux/Unix
  • sid_wise_sql.sql Further explaination Oracle
  • Shuffle an array PHP/MYSQL/Wordpress
  • Implementing Listener Security Oracle
  • How does one SELECT a value from a table into a Unix variable? From SQL to Shell Linux/Unix
  • Find All internal Parameters Oracle
  • Find_table_size.sql Oracle
  • Is It Recommended To Apply Patch Bundles When PSU Is Available? -ID 743554.1 Oracle
  • Logic to chech # of parameters command line parameters Linux/Unix
  • CTAS with LONG Column for 7.x and 8 and 8i Oracle

Tag: DBA

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
  • Goog notes on X$ tables Oracle
  • How To Transfer Passwords Between Databases (ref note: 199582.1) Oracle
  • how to find VIP from ifconfig Linux/Unix
  • oracle fast start failover best practice Oracle
  • How to know Number of CPUs on Sun Box Linux/Unix
  • Renaming Oracle Instance Name Oracle
  • How to specify 2 arch location to avoid any kind of DB hanging. Oracle
  • Remove duplicate rows from table Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme