Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Example of How To Resize the Online Redo Logfiles Note:1035935.6 Oracle
  • DBMS_JOB all example Oracle
  • Wait Based Tuning Step by step with SQL statement Oracle
  • To see how much time or progress of long transaction Oracle
  • Building Our Own Namespaces with “Create Context” Oracle
  • scripts to take listener.log backup Linux/Unix
  • TABLE SIZING WITH DB_BLOCK ARCHITECTURE Reference : Metalink note : 10640.1 Oracle
  • find_du.ksh to find # of files, their sizes in current folder and its subdolder Linux/Unix
  • catting.sh Linux/Unix
  • Passing from Unix to PLSQL using bind variables Linux/Unix
  • DBMS_PROFILER for tuning PLSQL programs. Oracle
  • send email from unix mailx with attachment. Linux/Unix
  • kill all processes from specific user in solaris. Linux/Unix
  • sid_wise_cursor.sql find open cursor basis on username or SID Oracle
  • setting prompt display with .profile Linux/Unix

Category: shell

rm_backup_arch_file.ksh

Posted on 02-Aug-2005 By Admin No Comments on rm_backup_arch_file.ksh

a=`ps -ef|grep $SCRIPT_NAME|grep -v grep|wc -l` if [ $a -gt 2 ] then echo “Exiting because of more than 1 Moving archive log script is running ” >>$LOGFILE exit fi cd $DESTFOLDER b=0 buffersize=85 currentdskspce=`df -k $DESTFOLDER|tail -1 |awk {‘print $5’}| sed ‘s/%//g’` echo “This $DESTFOLDER files removal script was executed on `date`” >>$LOGFILE while…

Read More “rm_backup_arch_file.ksh” »

Linux/Unix, shell

purge_trc.sh

Posted on 02-Aug-2005 By Admin No Comments on purge_trc.sh

#!/bin/sh . /oracle/oraprocs/oracle_env_10g_UAS ORACLE_HOME=/oracle/app/oracle/product/10.1;export ORACLE_HOME ORACLE_SID=UAS;export ORACLE_SID find $UDUMP/*.trc -mtime +15 -exec rm {} ; find $BDUMP/*.trc -mtime +15 -exec rm {} ; find $CDUMP/*.trc -mtime +15 -exec rm {} ;

Linux/Unix, shell

cif crons

Posted on 01-Aug-2005 By Admin No Comments on cif crons

01 * * * * /export/home/oracle/scripts/move_arch_files_uoc.ksh > /export/home/oracle/scripts/log/move_arch_files_uoc.log 2> /export/home/oracle/scrip ts/log/move_arch_files_uoc.err 10 * * * * /export/home/oracle/scripts/move_arch_files_cif.ksh > /export/home/oracle/scripts/log/move_arch_files_cif.log 2> /export/home/oracle/scrip ts/log/move_arch_files_cif.err 05,20,35,50 * * * * /export/home/oracle/scripts/switchlogfile_UOC.sh > /export/home/oracle/scripts/log/switchlogfile_UOC.log 2> /export/home/oracle/s cripts/log/switchlogfile_UOC.err 10,25,40,55 * * * * /export/home/oracle/scripts/switchlogfile_CIF.sh > /export/home/oracle/scripts/log/switchlogfile_CIF.log 2> /export/home/oracle/s cripts/log/switchlogfile_CIF.err 0 6 * * * /export/home/oracle/scripts/purge_trc_UOC.sh >> /export/home/oracle/scripts/log/purge_trc_UOC.log 2>> /export/home/oracle/scripts/log/purge_trc_UOC.err 0…

Read More “cif crons” »

Linux/Unix, shell

Paste command syntax

Posted on 29-Jul-2005 By Admin No Comments on Paste command syntax

paste file1 file2 > out1 Above command will paste file1 with line by line setting from file2 amd stores output on out1 file.

Linux/Unix, shell

switchlogfile.sh

Posted on 29-Jul-2005 By Admin No Comments on switchlogfile.sh

#!/bin/sh . /export/home/oracle/oraprocs/oracle_env_10g_CIF ORACLE_HOME=/oracle/app/oracle/product/10.1;export ORACLE_HOME ORACLE_SID=CIF;export ORACLE_SID $ORACLE_HOME/bin/sqlplus

Linux/Unix, shell

For Search and replace unix command.

Posted on 29-Jul-2005 By Admin No Comments on For Search and replace unix command.

To remove any text becore patterrn “pvm” in all lines of file, you need to apply following vi editor command. %s/^.*pvm/pvm/g 🙂 “.” represend any single chanracter occurance.

Linux/Unix, shell

Search and Replace vi editor command.

Posted on 29-Jul-2005 By Admin No Comments on Search and Replace vi editor command.

Changing Case To change all the lower case characters to UPPER case characters, starting from the current line, and going for 5 lines, type :s/^.*$/U&/5 To change from UPPER to lower, type :s/^.*$/L&/5 Deleting characters To delete the first 5 characters off of every line in the current file, type :%s/^…..//g

Linux/Unix, shell

Jai Shree Ram

Posted on 29-Jul-2005 By Admin No Comments on Jai Shree Ram

God Bless All………..

Linux/Unix, shell

Jai Shree Ram

Posted on 29-Jul-2005 By Admin No Comments on Jai Shree Ram

God Bless All………..

Linux/Unix, shell

Posts pagination

Previous 1 … 14 15

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
  • column level grant syntax Oracle
  • Implementing Listener Security Oracle
  • grep multuple patterns Linux/Unix
  • rm_backup_arch_file.ksh Linux/Unix
  • Some useful Unix Commands Linux/Unix
  • shutdown linux Linux/Unix
  • remove archfiles only when it is applied to DR rm_archfiles.sh Linux/Unix
  • sqlnet.ora paramters Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme