Trace Analyzer : The Good Tool for Performance Monitoring

Just Came across one Good Performance Analysis Tool from Oracle.Itz Trace Analyzer.
Trace Analyzer is an Improved version of Oracle TKPROF.With Proper Layout and Format.
Trace Analyzer Utility download details are given in Metalink Note:224270.1

Download from the link and follow the steps given in the instruction.txt of the trca.zip file

Steps to Trace the Concurrent Request.

1).Enable the trace for the Concurrent Program using the following Navigation

Concurrent->Program->Define->'Program Name'

And check out the Enable Trace option

this will create the *trc file in udump directory

2)Once the Concurrent Request is completed look for the trace file with the name of request id

$ ls *requestid*

3).Login to sqlplus
SQL> conn apps/
SQL>set serverout on
SQL>exec trca$i.trace_analyzer('vis_ora_14328_SYSADMIN.trc');

Once the above procedure is completed it will create the html file the local Directory.

This file can be used for analysis of Performance.

Bullet Points:- Oracle Applications DBA

1). Environment Variable APPLFENV gives the environment variables file(*env file) which is sourced in the node

2).To find the Character Set of the Database

Use,

SQL>select value from nls_database_parameters where parameter = 'NLS_CHARACTERSET'

3)To find the free disk space in ASM

Use,

SQL.select sum(free_mb) from v$asm_disk;

4).To skip the particular job when running a patch/maintenance pack
use the hidden option '8' in 'adctrl' to skip and start the job.


5)To check whether the Applications running on RAC

SQL>select is_rac_db from fnd_databases;Output would be either Y/N

6)To check the location of Voting Disk
Use ,

$crsctl query css votedisk

O/P would be somewhat like,

0 0 /dev/votediskLocated 1 Vote disk

Handy UNIX Commands for Oracle Professionals

Like to share some good and handy UNIX commands which would be really helpful support professionals


1).To find the top 10 larger files in the Directory,

$ls -lrt | awk '{print $5,$9}' | sort -nr head | xargs ls -lrt


2) To find the access and Modification details of a file

$istat

*This command is available for AIX only

3).To remove file which are older then say 7 days

$find . -mtime +7 -exec rm {} \;

4).Locate Files That Contain Certain Strings

$ find . -printxargs grep -i v\$dba_objects

5)To Delete top 10 files in directory which has huge size

use,

$du -sk sort -nr head awk '{print $2}' xargs rm -r