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 <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED]
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: [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).
