This is im telling Kishore
Test data
Some OS level threshold for performance.
Some OS level threshold for performance. Run queue > 8 : May indicate an overloaded CPU. Page_in and Page_out > 50 : May indicate overloaded RAM memory. This should be correlated with page-outs and scan rate. user+system CPU > 70% : Indicates periods with a fully-loaded CPU subssystem.Periods of 100% utilization are only a concern…
find_du.ksh to find # of files, their sizes in current folder and its subdolder
#!/usr/bin/ksh for dirname in `find . -type “d”` do #print “dirname is $dirname”; tot_files=`ls -rlt $dirname| grep -i “^-” | wc -l` tot_file_size=`ls -rlt $dirname| grep -i “^-” | awk ‘{tot+=$5} END {print tot/1024/1024}’` echo “Folder : $dirname, Total Files : $tot_files, Total File Sizes : $tot_file_size MB” done
Looping for remote servers and find its database from oratab file.
if you wish for your Unix Oracle user to be able to connect to the remote server named prodwest, then the prodwest server must contain an .rhosts file in its Oracle user’s home directory. This file must contain an entry allowing the remote Oracle user to connect. Your system administrator can help you configure your…
Read More “Looping for remote servers and find its database from oratab file.” »
Validating ORACLE_SID againt oratab file.
The following script shows how to check an Oracle SID to be sure that it’s valid. The script expects the SID to be passed in as the first parameter, and it begins by checking to see if a parameter was even passed. The script next counts the number of times the first parameter value appears…
Some useful Unix Commands
(1) Find all SQL files that contain “dba” pattern in current directory. find . -name “*sql” -print | xargs grep -i “dba” (2) script to kill all Oracle background processes for a database. This is a common Unix script used by Oracle DBAs when a database is locked up, and Server Manager cannot be used…
Logic to chech # of parameters command line parameters
# Exit if no first parameter $1. if [ -z “$1” ] then echo “Usage: check_parms.ksh (where value is > 100)” exit 99 fi # Exit if no second parameter $2. if [ -z “$2” ] then echo “Usage: check_parms.ksh (where value is > 100)” exit 99 fi # Exit if parm is not greater…
Read More “Logic to chech # of parameters command line parameters” »
oracle tips… from http://www.bijoos.com/oracle/douknow.htm
1998/10 In PL/SQL you can suspend a session using dbms_lock.sleep (seconds) which is equivalent to the ‘sleep’ command in UNIX. The parameter (number data type) can even be specified in hundredth of a second (10, 10.01, 10.5, 0.99 are all legal values). 1998/11 When you TRUNCATE a table, the storage parameter NEXT is automatically reset…
Read More “oracle tips… from http://www.bijoos.com/oracle/douknow.htm” »
How to find where datafile is created dbf_info.sql
column name format a60 column created format a25 select name, to_char(creation_time, ‘DD-MON-RRRR:HH24:MI’) created from v$datafile_header order by creation_time /
To find explain plan for a statement that occurred in past.
Find hash value & time when this plan was taken for particular sql id. Filename : fphv.sql REM *** Find Plan Hash value column plan_hash_value format 999999999999 accept v_sqlid prompt ‘Enter SQL_ID : ‘ select distinct sql_id, plan_hash_value, to_char(timestamp, ‘DD-MON-RRRR:HH24:MI:SS’) from dba_hist_sql_plan where sql_id=’&v_sqlid’; Then, Apply sql id and plan_hash_value for a unique plan. REM…
Read More “To find explain plan for a statement that occurred in past.” »