Re: Oracle Performance Tuning steps

Please run STATSPACK - which will give systemwide database performance diagnostics
- you could check the hitratios, top wait events and resource consuming queries
once report taken - upload it to www.oraperf.com - for suggestions check metalink article
 NOTE.149121.1 Gathering a StatsPack snapshot - if you can log into metalink

Thanks,
Kavi

Chetan wrote:

> Thanks ,
>
> I looked into the database. There r some waits happening on the undo
> blocks (non-system) but could not figure out whether this could
> possibly cause such a slowdown of the system. Also there were some
> indexes newly created on some of the tables which are causing
> problems.
>
> What's the best approch anyways to hunt down the problem in a
> situation like this ?
>
> - Chetan
>
> BigP wrote:
>
> cheten ,find processid of the application , look into
> database waits , that will give u some hint .Also look into
> db buffers to find if there are full table scans flushing db
> buffer . btw Did u ran statistics ? -Bigp
>
> ----- Original Message -----
> From: Chetan
> To: Multiple recipients of list ORACLE-L
> Sent: Wednesday, June 26, 2002 3:38 AM
> Subject: Oracle Performance Tuning steps
> 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
>
>
> -----------------------------------------------------------------------
> Do You Yahoo!?
> Sign-up for Video Highlights of 2002 FIFA World Cup

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kavitha Muthukumaren
  INET: Kavitha.Muthukumaren_at_oracle.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).



text/x-vcard attachment: Card for Kavitha Muthukumaren