RE: Oracle Performance

From: Aponte, Tony <AponteT_at_hsn.net>
Date: Thu, 11 Jan 2001 12:52:15 -0500
Message-Id: <10738.126411@fatcity.com>

Scaling Oracle8i by James Moley (Addison Wesley) has a chapter on dbaman that sounds just right for you. It has awk scripts to strip the SQL statements out of trace file and covert it into TCL scripts to be executed by dbaman. You can generate some activity (maybe from another instance) by tracing some sessions or create the statements yourself and them feed them into dbaman. As for the metrics a DBA would want to see, these are addressed by the other chapters. In a nutshell, I look at reducing resource consumption or improving throughput(learned that from the book). It also thought me a more disciplined approach to my performance improvements efforts.

Tony Aponte

-----Original Message-----
From: Viraj Luthra [mailto:viraj999_at_lycos.com] Sent: Thursday, January 11, 2001 12:30 AM To: Multiple recipients of list ORACLE-L Subject: Oracle Performance - Please Help

Hello every one,

I have just created a database in Oracle on aix4.33. Since my data base is new and created fresh, all my hit ratios are great. But I am not able to get any activity in there. So please help in the following 2 areas:-

1.How do I create activity in my database, that is all the hit ratios will show some realistic figures. By creating activity, I mean, let the database do something.May be I could run some adhoc sql statements etc. Hit ratios like Database buffer, library, data dictionary hit ratios etc.

2. Also what performance metrics I could paint. Eg I know one that is, I could see how many sessions are waiting, after I get the number of sessions, then I can drill down into 1 session and see what is the session waiting for, and then I see whether it is waiting for a particular latch or lock or something, and then I further drill down and see what lock it is and what type of lock?

Therefore please advise, as to what all scenarios you DBAs out there would like to see from a performance tool. I would like to make these kind of situations.

Please help at the earliest, any kind of leads or books or ideas will help.

Thanks and Regards,

Raja

Get your small business started at Lycos Small Business at http://www.lycos.com/business/mail.html
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Viraj Luthra
INET: viraj999_at_lycos.com

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: ListGuru_at_fatcity.com (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). Received on Thu Jan 11 2001 - 11:52:15 CST

RE: Oracle Performance - Please Help