Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • For Perl DBI installation and testing program PHP/MYSQL/Wordpress
  • Configure ssh authentications for RAC Oracle
  • Sending email with file attachment. Linux/Unix
  • Oracle 10g for solaris 10 Oracle
  • Free conference number from http://www.freeconference.com Oracle
  • db_status.sql Oracle
  • Resolving RMAN Hung Jobs Oracle
  • move_arch_files.ksh Linux/Unix
  • Check Oracle installed products using one command Oracle
  • Changing the Global Database Name Oracle
  • Adding a new disk and mount it automatically. on VMWARE LINUX Linux/Unix
  • How to find where datafile is created dbf_info.sql Oracle
  • pvmehta.com SQL scripts
    Find which sessions is accessing object that prevent your session to have exclusive locks in Oracle Oracle
  • move_arch_files.ksh Linux/Unix
  • crtgr.sql /* For creating trigger from data dictionary */ 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

  • 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
  • RMAN : Consistent Backup, Restore and Recovery using RMAN Oracle
  • Kernel Parameters for Solaris Linux/Unix
  • DBMS_PROFILER for tuning PLSQL programs. Oracle
  • CTAS with LONG Column for 7.x and 8 and 8i Oracle
  • Disbaling DBA_SCHEDULER_JOBS Oracle
  • Good Link from metalink 1 Oracle
  • Load SPM baseline from AWR Oracle
  • Display the top 5 salaries for each department using single SQL Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme