Oracle-L: Re:Oracle Performance Tuning steps

From: <dgoulet_at_vicr.com>
Date: Wed, 26 Jun 2002 05:33:27 -0800
Message-ID: <F001.00488590.20020626053327@fatcity.com>

Chetan,

First questions, What changed? Did someone add/delete an index? Was there an oversized data load done? When were the statistics, if present, last computed? Has a new program/application been added to the server? Did a memory bank go offline? Did a disk interface card go offline?

I use HP's HP-UX boxes as well, except most of my DB's are 10 times larger then yours. Just about everytime something like that happens, especially all of a sudden, one of those questions is the cause. The last item I'd go looking for, have only had one instance of it so far, is a unrestricted user who released "the query from HELL" into the database as a "one time requirement". If you can find him/her I've a used gallows rope is still here, one usage only.

Dick Goulet

____________________Reply Separator____________________
Author: Chetan <orachetan_at_yahoo.com>
Date:       6/26/2002 2:18 AM

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 for Video Highlights of 2002 FIFA World Cup
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 <hr size=1>Do You Yahoo!? 
<a

href="http://rd.yahoo.com/welcome/*http://fifaworldcup.yahoo.com/fc/en/spl">Sign -up for Video Highlights</a> of 2002 FIFA World Cup

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: dgoulet_at_vicr.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 Wed Jun 26 2002 - 08:33:27 CDT