Showing posts from February, 2008

trcsess utility

The trcsess utility consolidates trace output from selected trace files based on several criteria:

trcsess &nbsp[output=output_file_name]
trcsess output=main.trc service=psdwh *trc
After the consolidate trace file had been generated you can execute tkprof on it.
For example:
tkprof main.trc main.prf sys=no sort=exeela
TKPROF: Release - Production on Thu Feb 28 13:38:23 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
for more information:

Disk Structure Command for ASM - asmdisks

In my firm we have a seperation between System guys to the DBAs, we don't have root privileges. this is the reason that they are peparing us the ASM disks.
After using "/etc/init.d/oracleasm createdisk..." I tailored a script to see all the information that I can get WITHOUT the need to connect to the ASM instance.

export ORACLE_HOME=`grep ASM /etc/oratab | cut -d: -f2`
export PATH=$PATH:~$user/dba/scripts/bin:$ORACLE_HOME/bin
export SID=`grep ASM /etc/oratab | cut -d: -f1`

printf "\n%-15s %-14s %-11s %s\n" "ASM disk" "based on" "Minor,Major" "Size (Mb)"
printf "%-15s %-14s %-11s %s\n" "===============" "=============" "===========" "========="
for i in `/etc/init.d/oracleasm listdisks`
v_asmdisk=`/etc/init.d/oracleasm querydisk $i | awk '{print $2}' | sed 's/\"//g'`
v_minor=`/etc/init.d/oracleasm querydisk $i | awk -F[ '{print $2}' | awk -F…