Re: How to justify a Database Shutdown

From: Nuno Souto <dbvision_at_iinet.net.au>
Date: Mon, 19 Jan 2009 21:06:02 +1100
Message-ID: <4974508A.4040606_at_iinet.net.au>

Guillermo Alan Bort wrote,on my timestamp of 19/01/2009 8:32 PM:

> On the other hand, there are a few queries with over 500
> executions/day that perform a full table scan on a 19M records

Hmmmm, we have a few dozen a day on a table with 2.7 *billion* rows and that instance stays up for months...

More than likely that problem - if indeed there is one - can be solved with a flush of the shared pool at a convenient idle point. I can't think of an instance where anyone would need to "recycle" - that is such an inappropriate term - an Oracle instance in Unix that is not in memory or cpu shortage.

-- 
Cheers
Nuno Souto
in sunny Sydney, Australia
dbvision_at_iinet.net.au
--
http://www.freelists.org/webpage/oracle-l

Received on Mon Jan 19 2009 - 04:06:02 CST