Re: uptime
- From: Paul Drake <bdbafh@xxxxxxxxx>
- To: mcdonald.connor@xxxxxxxxx
- Date: Thu, 13 Sep 2012 08:45:48 -0400
Connor,
It wouldn't be that difficult to construct a scenario where this might make
sense.
Imagine if they are using LargePages (lock pages in memory),
pre_page_sga=true, nightly full cold backups staged on local disk.
The OS filesystem cache hasn't been disabled.
Each time after the cold backup task has been completed, the oracle.exe
process is attempting to acquire a relatively large amount of memory.
The OS filesystem cache is now bloated from the buffered file copy
operations.
An OS restart would allow the respective oracle.exe processes to acquire
large contiguous areas of memory without competing with the existing memory
allocations.
Do they have sacrificial users that come in early just to warm up the
buffer cache and shared pool?
Paul
I'm a fan of the "/J" switch for xcopy on MS W2K8 R2.
I'm not a fan of cold backups on a scheduled basis, but some people want
them generated on a monthly basis for their "full cold monthlies" so that
they can practice DR exercises without the need to bother the dba.
On Thu, Sep 13, 2012 at 12:32 AM, Connor McDonald <mcdonald.connor@xxxxxxxxx
> wrote:
> Hi all,
> I need to convince a client that they dont need restart their Oracle db
> (and their Windows server) every night.
>
> Can anyone send me:
>
> select to_char(min(logon_time),'DD/MM/YYYY HH24:MI:SS') started,
> round(sysdate-min(logon_time),2) days
> from v$session
>
> for any long-in-the-tooth Windows server they've got...
>
> Thanks,
> Connor
>
> --
> Connor McDonald
> ===========================
> blog: connormcdonald.wordpress.com
> web: http://www.oracledba.co.uk
>
> "If you are not living on the edge, you are taking up too much room."
> - Jayne Howard
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
http://www.completestreets.org/faq.html
http://safety.fhwa.dot.gov/ped_bike/docs/pamanual.pdf
--
//www.freelists.org/webpage/oracle-l
Other related posts:
