Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • metalink all dynamic view reference notes. Oracle
  • Creating never expiring DB user accounts in Oracle Oracle
  • UNderstand and eliminate Latch contention. Oracle
  • Optimizer_Index init.ora parameter explaination. Oracle
  • cache buffer chain latch Oracle
  • import-export with multiple files Oracle
  • Deleting first line and lastline of a file using sed Linux/Unix
  • Unix split command to split files Linux/Unix
  • When to rebuld B-tree index Oracle
  • Mutating Table Error while using database trigger Oracle
  • To check whether standby is recovering properly or not?? Oracle
  • How to know Number of CPUs on Sun Box Linux/Unix
  • Follwoing korn shell is used to move files from source folder to destination folder and gzip it in destination folder. mv_iotto.ksh Linux/Unix
  • How to set Processes Parameter Oracle
  • Paste command syntax Linux/Unix

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

  • Ansible (0)
  • AWS (2)
  • Azure (1)
  • Linux/Unix (149)
  • MYSQL (5)
  • Oracle (392)
  • PHP/MYSQL/Wordpress (10)
  • POSTGRESQL (0)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (341)
  • SQL Server (6)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • SQL Server Vs Oracle Architecture difference25-Jul-2025
  • SQL Server: How to see historical transactions25-Jul-2025
  • SQL Server: How to see current transactions or requests25-Jul-2025
  • T-SQL Vs PL/SQL Syntax25-Jul-2025
  • Check SQL Server edition25-Jul-2025
  • Checking SQL Server Version25-Jul-2025
  • Oracle vs MYSQL Architecture differences (For DBAs)24-Jul-2025
  • V$INSTANCE of Oracle in MYSQL24-Jul-2025
  • Day to day MYSQL DBA operations (Compared with Oracle DBA)24-Jul-2025
  • MYSQL and Oracle Comparison for Oracle DBA24-Jul-2025

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • SYSOPER Mystery Oracle
  • Difference between SYNC and AFFIRM Oracle
  • How To Transfer Passwords Between Databases (ref note: 199582.1) Oracle
  • move_arch_files.ksh Linux/Unix
  • Find All internal Parameters Oracle
  • cold backup scripts to copy locally Linux/Unix
  • Vivek’s egrep commands to trace problem. (on linux x86-64) Linux/Unix
  • remove archfiles only when it is applied to DR rm_archfiles.sh Linux/Unix

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme