Oracle-L: Re: newbie dba question

From: david davis <ddoralist_at_hotmail.com>
Date: Thu, 27 Feb 2003 08:44:12 -0800
Message-ID: <F001.0055BAB6.20030227084412@fatcity.com>

Alex

In my experience, when I have inherited systems worrying about "tuning" was the least of my concerns. I could think of other things to look into first (no particular order):

Backup/Recovery procedures
- like do backups happen, archivelog mode on (you would be surprised)
Database Event monitoring and notification processes in place
Security
Database Layout
System Resources => got enough room for your next backup

As for tuning, I will leave that for the many DBA's on the list who are Guru's in that field.

David

>From: Alex Dashko <newbie_dba_at_YAHOO.COM>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: newbie dba question
>Date: Wed, 26 Feb 2003 19:53:48 -0800
>
>
>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! Tax Center - forms, calculators, tips, and more

The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: david davis
  INET: ddoralist_at_hotmail.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 - 10:44:12 CST