Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Error Handling in Proc Oracle
  • Finding last recovered file on DR and remove all chanracters before any “/” Linux/Unix
  • Distributed Transaction Troubleshooting. Oracle
  • Settting up get_vmstat.sh for colletinf CPU Usage. Oracle
  • Oracle Internal Good Websites 1 Oracle
  • Renaming the column name Oracle
  • exp syntax in oracle 10g Oracle
  • 10g RAC: Troubleshooting CRS Root.sh Problems Oracle
  • create PLAN_TABLE command. Oracle
  • remove archfiles only when it is applied to DR rm_archfiles.sh Linux/Unix
  • In Addition to previous note, following grants needed on PERFSTAT user. Oracle
  • Renaming Oracle Instance Name Oracle
  • RAC 11g with vmware Oracle
  • good linux notes Linux/Unix
  • Restoring a user’s original password 1051962.101 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 (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
  • switchover for primary database Oracle
  • In Addition to previous note, following grants needed on PERFSTAT user. Oracle
  • Removing Blank lines from file using grep Linux/Unix
  • purge_trc.sh Linux/Unix
  • All About oracle password and security from metalink Oracle
  • Histogram information Oracle
  • Mutating Table Error while using database trigger Oracle
  • database trigger failing Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme