Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • UTL_FILE test program Oracle
  • get_vmstat.ksh for Solaris Oracle
  • checking redhat linux version Linux/Unix
  • note id 373303.1 Linux/Unix
  • Sequence Resetting Oracle
  • Locally Managed Tablespace and Dictionary managed tablespace (LMT-DMT) Oracle
  • Jai Shree Ram Oracle
  • Oracle Metalink useful notes Oracle
  • load SPM baseline from cursor cache Oracle
  • Renaming Oracle Instance Name Oracle
  • 272332.1 CRS 10g Diagnostic Collection Guide Oracle
  • 10g oem configuration Oracle
  • Jai Shree Ram Oracle
  • Nice Article about semaphores and init.ora Processes parameter relations Linux/Unix
  • rm_backup_arch_file.ksh Linux/Unix

Category: Oracle

Find_planinfo.sql

Posted on 08-Apr-202322-Apr-2025 By Admin No Comments on Find_planinfo.sql

/********************************************Author: Paresh MehtaScript Name : find_planinfo.sql********************************************/set lines 200set pages 500set echo offcol execs for 999,999,999col avg_etime for 999,999.999col avg_lio for 999,999,999.9col begin_interval_time for a30col node for 99999col plan_hash_value format 99999999999999col sql_profile format a30col intrvl format a29col component format a20alter session set nls_date_format=’DD-MON-RRRR:HH24:MI:SS’;–break on plan_hash_value,sql_profile on startup_time skip 1accept v_sql_id prompt ‘Enter SQL_ID ->’select s.instance_number, to_char(begin_interval_time,’DD-MON:HH24:MI’)…

Read More “Find_planinfo.sql” »

Oracle, SQL scripts

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

get_aix_vmstat.ksh

Posted on 18-Nov-2010 By Admin No Comments on get_aix_vmstat.ksh

#!/bin/ksh -x # First, we must set the environment . . . . ORACLE_SID=fdprod export ORACLE_SID ORACLE_HOME=/orastdbybin/fdprod/product/10.2 export ORACLE_HOME PATH=$ORACLE_HOME/bin:$PATH export PATH SERVER_NAME=`hostname` typeset -u SERVER_NAME export SERVER_NAME # sample every two minutes (120 seconds) . . . . SAMPLE_TIME=30 while true do vmstat ${SAMPLE_TIME} 2 > /tmp/msg$$ cat /tmp/msg$$|sed 1,7d | awk ‘{ printf(“%s…

Read More “get_aix_vmstat.ksh” »

Oracle, SQL scripts

Processes Parameter decision

Posted on 17-Nov-2010 By Admin No Comments on Processes Parameter decision

According to the query output from V$RESOURCE_LIMIT, the PROCESSES parameter limit is not yet reached. RESOURCE_NAME processes CURRENT_UTILIZATION 102 MAX_UTILIZATION 559 INITIAL_ALLOCATION 2000 LIMIT_VALUE 2000 The maximum value it ever reached was 559, while the limit is set to 2000.

Oracle, SQL scripts

How To Resolve Stranded DBA_2PC_PENDING Entries ID 401302.1 (Very Good prooven)

Posted on 11-Nov-2010 By Admin No Comments on How To Resolve Stranded DBA_2PC_PENDING Entries ID 401302.1 (Very Good prooven)

Ref ID: How To Resolve Stranded DBA_2PC_PENDING Entries [ID 401302.1] Issue: We had network outage and there were some distributed transactions with dblinks hangs. Causing issue when trying to update some rows of the base table. Problem Discription: ==================== As a result of a failed commit of a distributed transaction, some entries canbe left in…

Read More “How To Resolve Stranded DBA_2PC_PENDING Entries ID 401302.1 (Very Good prooven)” »

Oracle, SQL scripts

Oracle Recommended Patches — Oracle Database ID 756671.1

Posted on 20-Oct-2010 By Admin No Comments on Oracle Recommended Patches — Oracle Database ID 756671.1

Oracle Recommended Patches — Oracle Database Target Configurations Patch Availability Current Recommended Patches 11.2.0.2 Current Recommended Patches 11.2.0.1 Current Recommended Patches 11.1.0.7 Current Recommended Patches 11.1.0.6 Current Recommended Patches 10.2.0.5 Current Recommended Patches 10.2.0.4 Current Recommended Patches 10.2.0.3 Current Recommended Patches Conflict Resolution On Request Known Issues References Beginning with release 10.2.0.3, Oracle releases Recommended…

Read More “Oracle Recommended Patches — Oracle Database ID 756671.1” »

Oracle, SQL scripts

Is It Recommended To Apply Patch Bundles When PSU Is Available? -ID 743554.1

Posted on 20-Oct-2010 By Admin No Comments on Is It Recommended To Apply Patch Bundles When PSU Is Available? -ID 743554.1

Applies to: Oracle Server – Enterprise Edition – Version: 10.2.0.4 to 11.2.0.1 – Release: 10.2 to 11.2 Information in this document applies to any platform. Oracle Server Enterprise Edition – Version: 10.2.0.4 to 11.2.0.1 Goal 1.Do you still need to apply Patch Bundles for a certain patchset level when Patch Set Update (PSU) for that…

Read More “Is It Recommended To Apply Patch Bundles When PSU Is Available? -ID 743554.1” »

Oracle, SQL scripts

Consolidated Reference List Of Notes For Migration / Upgrade Service Requests -ID 762540.1

Posted on 20-Oct-2010 By Admin No Comments on Consolidated Reference List Of Notes For Migration / Upgrade Service Requests -ID 762540.1

Applies to: Oracle Server – Enterprise Edition – Version: 8.1.7.4 to 11.2.0.2 – Release: 8.1.7 to 11.2 Oracle Server – Standard Edition – Version: 8.1.7.4 to 11.2.0.2 [Release: 8.1.7 to 11.2] Information in this document applies to any platform. Oracle Server Enterprise Edition – Version: 8.1.7.4 to 11.2.0.2 Purpose The purpose of this document is…

Read More “Consolidated Reference List Of Notes For Migration / Upgrade Service Requests -ID 762540.1” »

Oracle, SQL scripts

Best approach for Oracle database patching sequence to latest/required patchset along with CPU/PSU/any-other-one-off patch ID 865255.1

Posted on 20-Oct-2010 By Admin No Comments on Best approach for Oracle database patching sequence to latest/required patchset along with CPU/PSU/any-other-one-off patch ID 865255.1

Applies to: Oracle Server – Enterprise Edition – Version: 10.2.0.1 to 11.1.0.7 Information in this document applies to any platform. Goal This article helps to plan oracle database patching sequence to the latest/required patchset version with in the same release (ex: 10.2.0.1 to 10.2.0.4) along with CPU/PSU/One-off-patch installations. Solution Basically there are two entities in…

Read More “Best approach for Oracle database patching sequence to latest/required patchset along with CPU/PSU/any-other-one-off patch ID 865255.1” »

Oracle, SQL scripts

Oracle Support Metalink ID 161818.1

Posted on 20-Oct-2010 By Admin No Comments on Oracle Support Metalink ID 161818.1

Oracle Database (RDBMS) Releases Support Status Summary [ID 161818.1] Oracle Database (RDBMS) Releases Support Status Summary Information here was last updated on 14-Sep-2010 This note shows the current main Oracle Database releases along with information about the support status of each release and its Patch Sets. To see the main support alerts and Patch Set…

Read More “Oracle Support Metalink ID 161818.1” »

Oracle, SQL scripts

Posts pagination

Previous 1 2 3 4 … 40 Next

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
  • _B_TREE_BITMAP_PLANS issue during 8.1.7 to 9.2.0.8 upgrade Oracle
  • oracle Dba site Oracle
  • find the files that are 1 day old. Linux/Unix
  • move_arch_files.ksh Linux/Unix
  • How to check current redo log progress redo_progress.sql Oracle
  • Find execution plan from dba_hist_sql_plan for a specific SQL_ID and PLAN_HASH_VALUE fplan.sql Oracle
  • Transfer SQL Profiles from One database to other database. Oracle
  • Renaming Oracle Instance Name Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme