RE: To Cycle or Not to Cycle : That is the question

We are still running 7.3.4 (I know, it should be upgraded) but we NEVER cycle the database. Our operation runs 24/7 and have never encountered any reason to recycle the database. We run on a UNIX platform which does not require periodic rebooting, so it works out quite well.

-----Original Message-----

From:	Pat Howe - Contractor [SMTP:pat.howe_at_Terabeam.com]
Sent:	Thursday, December 07, 2000 10:34 PM
To:	Multiple recipients of list ORACLE-L
Subject:	To Cycle or Not to Cycle : That is the question

I would like to see some dialog on the following issue : Is there a "need" to cycle an Oracle database ? and if so how frequently ?

IE;
Can you and should you keep a Oracle database up and running continually for
3, 6,..months?

I have always thought that it is a good idea to recycle an instance weekly (if you can) to cleanup memory and take a cold backup.
>From a server perspective (SUN SPARC SOLARIS) I do not have any
pre-conceived ideas and have left this up to the SA's to decide.

The shop I am currently at performs hot backups and does not have a scheduled cycle of the databases or the servers. In fact they want to avoid
re-cycling the box because of problems they have had in the past with the disk drives not spinning back up (if there is a planned outage they make sure they have a hardware techie on site and a good backup). They have had one database up and running for 3 months.

Is this the norm ??

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Pat Howe - Contractor
  INET: pat.howe_at_Terabeam.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).