Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • DBMS_UTILITY.ANALYZE_SCHEMA Oracle
  • Privilege to describe the table. Oracle
  • CPU Core related projections AWS
  • Updated LCK.SQL file. Oracle
  • Rman Notes -1 Oracle
  • Check SQL Server edition SQL Server
  • Search and replace editor command in vi Linux/Unix
  • Adding or Dropping Online Redo Log Files When Physical Standby in place Oracle
  • For Search and replace unix command. Linux/Unix
  • PLSQL Table Syntax 1 Oracle
  • Find long Running Transaction Linux/Unix
  • Processes Parameter decision Oracle
  • TRUNCATE table and disabling referential constraints. Oracle
  • Wait Based Tuning Step by step with SQL statement Oracle
  • 10g oem configuration Oracle

_B_TREE_BITMAP_PLANS issue during 8.1.7 to 9.2.0.8 upgrade

Posted on 30-Aug-2007 By Admin No Comments on _B_TREE_BITMAP_PLANS issue during 8.1.7 to 9.2.0.8 upgrade

Subject: Upgrading from 8.1.X to 9.X – Btree Bitmap Plan Issues – Diagnosing and Resolving Doc ID: Note:259126.1 Type: TROUBLESHOOTING Last Revision Date: 13-MAR-2006 Status: PUBLISHED PURPOSE The Oracle Cost Based Optimizer is continually been enhanced. These enhancements were designed to improve performance but in some cases can cause a minority of queries to perform…

Read More “_B_TREE_BITMAP_PLANS issue during 8.1.7 to 9.2.0.8 upgrade” »

Oracle, SQL scripts

Multiple listeners

Posted on 23-Aug-2007 By Admin No Comments on Multiple listeners

TNS-00512 starting second listener in same node Hi all, I have a 8.1.7.4 listener running OK with a 9.2.0.1 listener in the same Solaris box, I get TNS-00512 starting second listener from 9.2.0.1 ORACLE_HOME. I have changed the ports number, but the problem still persist !!! Here are the listener.ora file: Listener.ora (8.1.7.4) LISTENER =…

Read More “Multiple listeners” »

Oracle, SQL scripts

Good RAC & Standby Notes

Posted on 13-Jul-2007 By Admin No Comments on Good RAC & Standby Notes

RAC Notes Note:241114.1 Step-By-Step Installation of RAC on Linux – Single Node (Oracle9i 9.2.0 with OCFS) Linux OCFS – Best Practices Step-by-Step Installation of RAC on Linux @ Setting up Real Application Cluster (RAC) environment on Linux – Single node Setting up Oracle Parallel Server environment on Linux – Single node @ 9iRAC: OS Port-Specific…

Read More “Good RAC & Standby Notes” »

Oracle, SQL scripts

Finding locked objects

Posted on 11-Jun-2007 By Admin No Comments on Finding locked objects

select object_id from dba_objects where object_name = ‘MYTABLE’; select sid, id1, id2 from v$lock where id1= &objid or id2 = &objid;

Oracle, SQL scripts

Changing Instance Name ( No DB_NAME)

Posted on 11-Jun-2007 By Admin No Comments on Changing Instance Name ( No DB_NAME)

Note Instance name : represented by $ORACLE_SID database name : represented by DB_NAME init.ora parameter. You can change instance name to any name with following requirements: Here we are chaning instance name from AWRTEST1 to PARESH. Exising setup: ORACLE_SID=AWRTEST1 Step1: $ export ORACLE_SID=PARESH; Step2: Create password file for new instance PARESH. $ cd $ORACLE_HOME/dbs $…

Read More “Changing Instance Name ( No DB_NAME)” »

Oracle, SQL scripts

Find nth max and min.

Posted on 02-May-2007 By Admin No Comments on Find nth max and min.

First, the query for Max: SELECT * FROM TAB1 a WHERE &N = (SELECT count(DISTINCT(b.col1)) FROM TAB1 b WHERE a.col1=b.col1) If N=1 will return first max or first min. N=2 will return second max or min.

Oracle, SQL scripts

DBMS_Shared_pool pinning triggers

Posted on 02-May-2007 By Admin No Comments on DBMS_Shared_pool pinning triggers

How to pin a stored procedure/functions ? 1.You can pin procedures and triggers with the dbms_shared_pool procedure. Either procedures or packages can be pinned with the ‘P’ flag, which is the default value (so you can leave it out). Triggers are pinned with ‘R’ and anonymous plsql blocks need any letter other than [p,P,r,R] as…

Read More “DBMS_Shared_pool pinning triggers” »

Oracle, SQL scripts

TOP-N Sql to find Nth max or Top N rows

Posted on 01-May-2007 By Admin No Comments on TOP-N Sql to find Nth max or Top N rows

PURPOSE This note explains the TOP-N Query, a new feature (as of 8.1.5) that allows users to query on ROWNUM and order results with ORDER BY. This functionality is similar to the offerings of other database software such as the “Top Values’ property option in Microsoft Access. Top-N Query to Solve ORDER BY…ROWNUM Inaccuracy: ==================================================…

Read More “TOP-N Sql to find Nth max or Top N rows” »

Oracle, SQL scripts

Session_info.ksh

Posted on 24-Apr-2007 By Admin No Comments on Session_info.ksh

/********* session_info.ksh ****************/ #!/bin/ksh . /home/oracle/oraprocs/WEBP18F.env USR_ID=vivek USR_PASS=viv1ek database=WEBP18F a=`ps -ef|grep “session_info.ksh”|grep -v grep|wc -l` if [ $a -gt 4 ] then echo “Exiting because of more than 1 process is running `date`”>>/db3/oradata/log/session_info.log exit fi echo “—–Begin —– Date `date`——————————–” >> /db3/oradata/log/session_info.log $ORACLE_HOME/bin/sqlplus -s /db3/oradata/log/session_info.log $USR_ID/$USR_PASS@$database set serverout on set feedback off SET PAGES 0…

Read More “Session_info.ksh” »

Linux/Unix, shell

Facts about SCN and Rollback Segment

Posted on 21-Apr-2007 By Admin No Comments on Facts about SCN and Rollback Segment

1. When should you create more rollback segments? The number of rollback segments needed to prevent contention between processes can be determined with the help of the monitor rollback display and with the use of the v$waitstat table. The rollback monitor column “header waits/sec” gives an indication of the current rollback segment contention. Waits are…

Read More “Facts about SCN and Rollback Segment” »

Oracle, SQL scripts

Posts pagination

Previous 1 … 28 29 30 … 57 Next

Categories

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

Recent Posts

  • Complete Git Tutorial for Beginners25-Dec-2025
  • Postgres DB user and OS user.25-Dec-2025
  • Trace a SQL session from another session using ORADEBUG30-Sep-2025
  • 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

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • eplan.sql Oracle
  • Monitor Long Running Job Oracle
  • sid_wise_sql.sql Oracle
  • get_vmstat_linux Oracle
  • send email from unix mailx with attachment. Linux/Unix
  • Oracle Standby Database Library Index from Metalink Oracle
  • find_cons.sql Oracle
  • SQL Tracker by SID sqltrackerbysid.sql Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme