Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • OPENING A STANDBY DATABASE IN READ-ONLY MODE Oracle
  • grep multuple patterns Linux/Unix
  • Remove duplicate rows from table Oracle
  • TRUNCATE table and disabling referential constraints. Oracle
  • Histogram information Oracle
  • How To Transfer Passwords Between Databases (ref note: 199582.1) Oracle
  • find_log_switch.sql Find log switches in graphical manner Oracle
  • Reading config file from other folder inside class Python/PySpark
  • Locktree.sql Oracle
  • Changing default shell Linux/Unix
  • Temporary tablespace explaination Oracle
  • Unix command for system configuration Linux/Unix
  • find_open_cur.sql Find open cursorts per session Oracle
  • replacing ^M character when passing files from Windows to Unix Linux/Unix
  • VIvek Encryption Package and Its Usage 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 (388)
  • PHP/MYSQL/Wordpress (10)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (337)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • 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
  • Reading config file from other folder inside class24-Sep-2024
  • Python class import from different folders22-Sep-2024
  • Transfer SQL Profiles from One database to other database.05-Sep-2024
  • Load testing on Oracle 19C RAC with HammerDB18-Jan-2024

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • Building Our Own Namespaces with “Create Context” Oracle
  • How To Resolve Stranded DBA_2PC_PENDING Entries ID 401302.1 (Very Good prooven) Oracle
  • Jai Shree Ram Oracle
  • online_ts_bkup.sql Oracle
  • Read CSV File using Python Python/PySpark
  • Transfer SQL Profiles from One database to other database. Oracle
  • good note for shared pool tunnig Oracle
  • default permission on ~/.ssh/authorized_keys2 or authorized_keys Linux/Unix

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme