Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!postnews1.google.com!not-for-mail From: joel-garry@home.com (Joel Garry) Newsgroups: comp.databases.oracle.server Subject: Re: How to perform a health check? Date: 30 Sep 2004 16:12:30 -0700 Organization: http://groups.google.com Lines: 44 Message-ID: <91884734.0409301512.5393022f@posting.google.com> References: <1096519785.966597@yasure> NNTP-Posting-Host: 67.116.125.178 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: posting.google.com 1096585950 3249 127.0.0.1 (30 Sep 2004 23:12:30 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Thu, 30 Sep 2004 23:12:30 +0000 (UTC) Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:226024 Daniel Morgan wrote in message news:<1096519785.966597@yasure>... > Stimi wrote: > > > Hi everyone, > > > > In order to maintain an oracle database in an optimal condition, good > > maintenance is a necessity. > > > > Can anyone show me how to carry out a good health check of an oracle 8i > > database? > > > > Thanks in advance. > > Do you really think anyone can give you 5+ years of experience in a > usenet posting? There are 1000 page books on the subject that don't > completely cover it. I would suggest you find another source of > employment. Daniel: I didn't see the OP, but come on, as quoted couldn't we give a better answer than that? This really should be a faq, not a weenie-slap. All I can imagine is you've seen something else from the poster. And I seem to recall some of those books do health checks... > > Oh ... and 8i begins desupport in 3 months so you might want to think > about getting a different version of the database. OP: http://metalink.oracle.com/metalink/plsql/ml2_documents.showFrameDocument?p_database_id=NOT&p_id=131704.1 has some interesting scripts, some of which may be very misleading as far as actually telling the health of a db. There used to be one called tfsmstat, but they seem to have gotten rid of it. It needed to be taken with several grains of salt, but some things were useful just to see if the db was in the ballpark, like if the log buffer size was reasonable, undo block contention, latch contention and library cache pinning. Like everyone said, use V9 OEM and statspack and check the alert logs. jg -- @home.com si bogus. I thought Binky's dream house was better: http://www.dilbert.com/comics/dilbert/duh/