Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle and Unix Performance

RE: Oracle and Unix Performance

From: Viraj Luthra <>
Date: Tue, 12 Dec 2000 12:20:01 +1000
Message-Id: <>


Thanks Satar for the comments. What do BSTAT and ESTAT recommend, I thought these scripts were used for volume trialing. Please if could show me the reporting from these tools that would be great. In addition to this, do you see some other parameters every other day. Also have you started the BSTAT or ESTAT as a regular cron job or some thing?

Please if any one else also has any suggestions, please do. Any help greatly appreciated.




On Mon, 11 Dec 2000 11:41:24  
 Satar Naghshineh wrote:

>to be honest, it's hard to take a proactive approach on performance tuning
>in a diverse database environment. I basically look at what queries the
>users usually execute on a frequent basis and see if I can improve the
>performance of those queries any. I also run BSTAT and ESTAT every two weeks
>to see what it recommends. I watch the alert log and walk around and speak
>with the users and basically see what they see.
>> -----Original Message-----
>> From: Viraj Luthra []
>> Sent: Sunday, December 10, 2000 8:26 PM
>> To: Multiple recipients of list ORACLE-L
>> Subject: Oracle and Unix Performance
>> Hello all,
>> I sent 1 message before on this mailing list but not sure where it
>> disappeared.
>> Any way folks I need your help. I need to know what parameters you DBA's
>> and System Administrators(SA) would like to see in a performance
>> monitoring tool. Specifically what parameters does a DBA or a SA look for
>> each morning so as to confirm that there systems are working properly or
>> are tuned properly.
>> What performance metrics do you look for day in and day out so that you
>> are always aware that the systems are working to the desired levels of
>> performace. Please I need a speedy reply.
>> Thanks and Regards,
>> Raja
>> Get FREE Email/Voicemail with 15MB at Lycos Communications at
>> --
>> Please see the official ORACLE-L FAQ:
>> --
>> Author: Viraj Luthra
>> INET:
>> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>> San Diego, California -- Public Internet access / Mailing Lists
>> --------------------------------------------------------------------
>> To REMOVE yourself from this mailing list, send an E-Mail message
>> to: (note EXACT spelling of 'ListGuru') and in
>> the message BODY, include a line containing: UNSUB ORACLE-L
>> (or the name of mailing list you want to be removed from). You may
>> also send the HELP command for other information (like subscribing).
Get FREE Email/Voicemail with 15MB at Lycos Communications at
Received on Mon Dec 11 2000 - 20:20:01 CST

Original text of this message