Re: SQL Performance

On Tue, 01 Mar 2005 11:54:11 -0800, dalst36 wrote:  

> I have been asked to monitor SQL to tell me when we are performing
> better than others. Can anyone tell me what kinds of scheduled jobs or
> scripts they utilize?

alter system set events='10046 trace name context forever, level 10'; alter system set events='10053 trace name context forever, level 1';

That will produce few trace files in USER_DUMP_DEST that you can analyze at your leisure. Occasionally, you can do the following, connected as sysdba:

SQL> connect sys as sysdba
Enter password:
Connected.
SQL> oradebug setmypid
Statement processed.
SQL> oradebug dump systemstate 10
Statement processed.
SQL> That will also produce all the information necessary for you to analyze performance of your Oracle instance. You can even use oradebug to set events like 10046 and 10053.

-- 
A clean tie attracts the soup du jour.