Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle Performance Tuning steps
For a 24 X 7 system I would incorporate a hot backup strategy
which can be executed without taking the system down and
allows for a point in time recovery. There are many scripts
floating around you could "borrow" to set this up.
Your performance issue is going to require some time to
understand and solve. it cannot be answered in a paragraph.
Consider buying Gaja Krishna Vaidyanatha and
Kirti Deshpande's book "Oracle Performance
Tuning 101" as it has been a big help to me.
Other things you might find helpful would be
www.hotsos.com which goes into great detail on the
10046 event trace and they also have an excellent
clinic I just went too.
Good Luck and Peace !
Mike
-----Original Message-----
Sent: Wednesday, June 26, 2002 3:39 AM
To: Multiple recipients of list ORACLE-L
Hi guys ,
Need some help. Actually we are looking here at a Oracle 8.1.7 db on HP-UNIX. The application was running fine uptil yesterday. Suddenly a part of the appln is running extremely slow. I can not figure what might be the problem. Wanted to track this down asap.
Here is some information about the db.
Database size - 20GB
Optimizer - CHOOSE
Disk Structure - RAID 1+0
No. of processors - 4
Block Size - 8K
Archivelog mode : ARCHIVELOG
Please tell me what should be the ideal way I should try to trace the problem. I thought of running UTLBSTAT/UTLESTAT or STATSPACK and asked the user to run that part of the appln. Has anybody worked with STATSPACK before ?
Can anybody tell me what should accurate and fastest way to hunt down the problem ? I think its something to do with indexes or changes in the queries.
Also can someone tell me the ideal backup strategy for this database considering the fact that it's a 24x7 system.
Thanks in advance .
Chetan Chindarkar
Do You Yahoo!?
Sign-up
<http://rd.yahoo.com/welcome/*http://fifaworldcup.yahoo.com/fc/en/spl> for
Video Highlights of 2002 FIFA World Cup
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Johnson, Michael
INET: Michael.Johnson_at_oln-afmc.af.mil
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 Wed Jun 26 2002 - 18:33:37 CDT
![]() |
![]() |