DBA Scripts

[rdalvi]

Dear DBAs,

Do you have a script file which contains all
SQL statements to check the status of
database performance, Instance and tune.

If u dont mind, can you please mail me.

Thanks

Richard
(Email: drichard@mtlindia.com)

[oravijay]

Hi,

Infact Oracle themselves provides you a lot of SQL scripts.
For gathering information about your instance,
first run utlestat.sql and leave some period so that Oracle can generate the
statistics and then run utlbstat.sql. This generates a file in the OS.
Do this in high activity,low activity and medium activity in your database.
All the scripts are available in /rdbms/admin and
they starts with UTL as prefix.

Vijay.

[Sureshy]

Rdalvi, you may have mistyped : The sequence is actually ultbstat and then utlestat, b=begin e=end.


For tuning sql, try tracing a session and execute statements which are performing poorly. Use TKPROF to analyse trace file and explain plan. Make decisions from the output of tkprof.

Here is a good link which explains the process.

http://www.dbspecialists.com/present...e_explain.html

There are MANY useful tuning scripts on this site, use the link to 'Oracle Scripts' on the left.