Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • How to calculate PROCESSES parameter Oracle
  • DBMS_SQL for alter session. Oracle
  • Removing Ctrl-M from end of line using vi Linux/Unix
  • Wait.sql Oracle
  • Set Role explaination. Oracle
  • Insert cause enqueue locks Oracle
  • Composite Index creation tip from Vivek Oracle
  • segment_wise_space.sql segspace.sql Segment wise space usage (allocated and used) Oracle
  • How to know current SID Oracle
  • Facts about SCN and Rollback Segment Oracle
  • Finding Oracle Patches with opatch Oracle
  • find_idle_cpu.sql Oracle
  • Passing from Unix to PLSQL using bind variables Linux/Unix
  • Find Command Linux/Unix
  • Check_recovery.sh program to run sqlplus and return its values remotely. Linux/Unix

Year: 2006

Passing from Unix to PLSQL using bind variables

Posted on 29-Aug-2006 By Admin No Comments on Passing from Unix to PLSQL using bind variables

. $ENV_FILE echo “Started test.ksh `date +%D-%T`” V1=1; V3=One; $ORACLE_HOME/bin/sqlplus pvm/pvm

Linux/Unix, shell

Passing from Unix to PLSQL using bind variables

Posted on 29-Aug-2006 By Admin No Comments on Passing from Unix to PLSQL using bind variables

#!/usr/bin/ksh ########## Configuration ############# ENV_FILE=$1

Linux/Unix, shell

get_vmstat.ksh for Solaris

Posted on 17-Aug-2006 By Admin No Comments on get_vmstat.ksh for Solaris

#!/bin/ksh -x # First, we must set the environment . . . . ORACLE_SID=WEBP18F export ORACLE_SID ORACLE_HOME=`cat /var/opt/oracle/oratab|grep ^$ORACLE_SID:|cut -f2 -d’:’` export ORACLE_HOME PATH=$ORACLE_HOME/bin:$PATH export PATH SERVER_NAME=`uname -a|awk ‘{print $2}’` typeset -u SERVER_NAME export SERVER_NAME # sample every five minutes (300 seconds) . . . . SAMPLE_TIME=30 while true do vmstat ${SAMPLE_TIME} 2 > /tmp/msg$$…

Read More “get_vmstat.ksh for Solaris” »

Oracle, SQL scripts

Search and replace editor command in vi

Posted on 28-Jul-2006 By Admin No Comments on Search and replace editor command in vi

To search and replace between line1 and line2 use following: (*) This is vi editor command: following command will serach and replace whole file. (this is default with %s). :line1,$ s/old_string/new_string/g following command will search and replace only in specific lines: :line1,line2 s/old_string/new_string/g for example, :3,5 s/CIF/UOC/g above command will replace CIF with UOC in…

Read More “Search and replace editor command in vi” »

Linux/Unix, shell

Find average Row Length and other table size calculation. metalink notes

Posted on 24-Jul-2006 By Admin No Comments on Find average Row Length and other table size calculation. metalink notes

Subject: Extent and Block Space Calculation and Usage in V7-V9 Database Doc ID :10640.1

Oracle, SQL scripts

How to choose Driver table in SQL statement

Posted on 20-Jul-2006 By Admin No Comments on How to choose Driver table in SQL statement

Driver table: Take the driver table which returns the less number of rows for predicate with literal valae. For example, Consider the statement below: SELECT SUM(BIP.VALUE) value FROM BSKT_ITEM_CALC_PRICING BIP,BSKT_PRICING_ELEMENT BP WHERE BIP.BASKET_ITEM_ID IN (:”SYS_B_0″) AND BIP.PRICING_ELEMENT_ID = BP.PRICING_ELEMENT_ID AND BP.PRICING_TYPE_CODE = :1; Here SQL> select BASKET_ITEM_ID, count(1) from BSKT_ITEM_CALC_PRICING group by BASKET_ITEM_ID; BASKET_ITEM_ID COUNT(1)…

Read More “How to choose Driver table in SQL statement” »

Oracle, SQL scripts

SQL_PLAN.sql for checking real execution plan

Posted on 20-Jul-2006 By Admin No Comments on SQL_PLAN.sql for checking real execution plan

set lines 132 set pages 1400 SELECT LPAD(‘ ‘,2*(LEVEL-1))||operation||’ ‘||options ||’ ‘||object_name ||’ ‘|| DECODE(id, 0, ‘Cost = ‘||position) “Query Plan” FROM v$sql_plan START WITH id = 0 and sql_id=’4ftvbpzhwkfd8′ and child_number=0 CONNECT BY PRIOR id = parent_id and sql_id=’4ftvbpzhwkfd8′ and child_number=0;

Oracle, SQL scripts

Good Doc 28-JUN-2006

Posted on 28-Jun-2006 By Admin No Comments on Good Doc 28-JUN-2006

Good Doc About UNDO Management: http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:6894817116500 Cache Buffer Chain Latch: http://www.orafaq.com/maillist/oracle-l/2003/02/27/2671.raw

Oracle, SQL scripts

How to stop OCSSD Daemon

Posted on 28-Jun-2006 By Admin No Comments on How to stop OCSSD Daemon

/etc/init.d/init.cssd stop to stop cssd process.

Oracle, SQL scripts

Follwoing korn shell is used to move files from source folder to destination folder and gzip it in destination folder. mv_iotto.ksh

Posted on 20-Jun-2006 By Admin No Comments on Follwoing korn shell is used to move files from source folder to destination folder and gzip it in destination folder. mv_iotto.ksh

#!/usr/bin/ksh a=`ps -ef|grep “mv_iotto.ksh”|grep -v grep|wc -l` if [ $a -gt 2 ] then echo “Exiting because of more than 1 Moving archive log script is running ” exit fi for fname in `ls -rlt /tmpdb2/oradata/UOCIOTTO_ARCH/*.arc | awk ‘{print $9}’ | sed ‘$d’ | sed ‘$d’` do print “”; print “File Name : $fname “;…

Read More “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, shell

Posts pagination

Previous 1 … 3 4 5 … 11 Next

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
  • How to remove blank lines using vi editor command Linux/Unix
  • Oracle GoldenGate lag monitoring shell script Linux/Unix
  • Which environment is used by currently running process ( Very good) Linux/Unix
  • Generate SSH without password authentication. Linux/Unix
  • Multiple listeners Oracle
  • Logic to chech # of parameters command line parameters Linux/Unix
  • JSON/XML Types in Oracle Oracle
  • Oracle 10g Installation/Applying Patches Tips Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme