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 <[EMAIL PROTECTED]>
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
<P>Hi guys ,</P>
<P>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.</P>
<P>Here is some information about the db.</P>
<P>Database size - 20GB</P>
<P>Optimizer - CHOOSE</P>
<P>Disk Structure - RAID 1+0</P>
<P>No. of processors - 4</P>
<P>Block Size - 8K</P>
<P>Archivelog mode : ARCHIVELOG</P>
<P>Please tell me what should be the ideal way I should try to trace the
problem. I thought of running <STRONG>UTLBSTAT/UTLESTAT</STRONG> or
<STRONG>STATSPACK</STRONG> and asked the user to run that part of the appln. Has
anybody worked with <STRONG>STATSPACK</STRONG> before ?</P>
<P>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.</P>
<P>Also can someone tell me the <U>ideal backup strategy</U> for this
database considering the fact that it's a 24x7 system.</P>
<P>Thanks in advance .</P>
<P>Chetan Chindarkar</P><p><br><hr size=1><b>Do You Yahoo!?</b><br>
<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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
