Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Test Case for Inserting Multiple (2.3 Million rows in 26 Seconds) Oracle
  • Example of How To Resize the Online Redo Logfiles Note:1035935.6 Oracle
  • Caching sequence in Memory Oracle
  • Configure ssh authentications for RAC Oracle
  • handling filenname with space Linux/Unix
  • Changing default shell Linux/Unix
  • find_du.ksh to find # of files, their sizes in current folder and its subdolder Linux/Unix
  • Insert cause enqueue locks Oracle
  • Important Solaris Commands Linux/Unix
  • DBMS_UTILITY PACKAGE Oracle
  • oracle 11g RAC on vmware Oracle
  • Find Command Linux/Unix
  • Gather Stats manually using DBMS_STATS after disabling DBMS_SCHEDULER jobs as previous entry Oracle
  • find_log_switch.sql Find log switches in graphical manner Oracle
  • 10g RAC: Troubleshooting CRS Root.sh Problems Oracle

Category: Linux/Unix

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
  • AWR license Oracle
  • fkwoindex.sql /* Find FK without Index */ Oracle
  • RMAN : Consistent Backup, Restore and Recovery using RMAN Oracle
  • Database logon trigger issue Oracle
  • How to sort list of files on basis of their sizes. Linux/Unix
  • Remove duplicate rows from table Oracle
  • sql_plan9i.sql Oracle
  • crtgr.sql /* For creating trigger from data dictionary */ Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme