Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: newbie dba question

RE: newbie dba question

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Thu, 27 Feb 2003 07:44:02 -0800
Message-ID: <F001.0055B8B7.20030227074402@fatcity.com>


Alex

    I would recommend you install Oracle's STATSPACK, if you haven't already. If you haven't, consider buying Don Burleson's book "Oracle9i High-Performance Tuning with STATSPACK". You can run some STATSPACK snapshots while the system is normal and see what the performance is like. Ask people to report slowdowns to you as soon as they notice it. When reported, run STATSPACK snapshots at 5-minute intervals. This can really help you get to the bottom of what is causing the slowdown. Also work with your system administrator to see what can be observed on the hardware side.

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Wednesday, February 26, 2003 9:54 PM To: Multiple recipients of list ORACLE-L

Hello Gurus,

I heard that if I can get great ORACLE advice, this is the place, so here is my question. I've been asked to take over an existing db in production. What would be the right way to get a "quick" understanding on what's happening in it in terms ways for proactive tuning? I am just getting started while trying to be ahead of the curve. Is this something I should be looking into, or is it more like if it ain't broke, don't fix it? :). It'd be nice to get started and have a good view on what's going on. Also, can someone can share their experience on what can be done when customers report intermittent, but rather dramatic slowdowns in the system. Please note, the slowdowns are reported to be occurring in the entire system. What would be a good place to look when this happens and get some quick feedback?

Thank you very much!

Best regards,

Alex


Do you Yahoo!?
Yahoo! <http://rd.yahoo.com/finance/mailtagline/*http://taxes.yahoo.com/> Tax Center - forms, calculators, tips, and more

--

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

Author: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.COM

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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 Feb 27 2003 - 09:44:02 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US