Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: To Cycle or Not to Cycle : That is the question

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

From: William Rogge <>
Date: Fri, 8 Dec 2000 08:52:50 -0500
Message-Id: <>

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 []
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 ?

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:
Author: Pat Howe - Contractor

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: (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 Fri Dec 08 2000 - 07:52:50 CST

Original text of this message