Re: cache vs keep buffer pool

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Wed, 28 Aug 2002 12:43:43 +0100
Message-ID: <3d6cb76f$0$237$ed9e5944@reading.news.pipex.net>

"Nuno Souto" <nsouto_at_optushome.com.au.nospam> wrote in message news:3d6b960e$0$29911$afc38c87_at_news.optusnet.com.au...
> > Point taken ;) But it would be interesting to know how many DBAs use the
> > CACHE clause vs the KEEP pool...
>
> Well, how many 7.3.4 dbs out there? ;)

Put me down for two. And one of those 6.0.36 jobbies. Viz.

SQL*DBA: Version 6.0.36.6.1 - Production on Wed Mar 5 12:27:19 1980

ORACLE RDBMS V6.0.36.6.1, transaction processing option - Production PL/SQL V1.0.36.2.2 - Production

SQLDBA> You'll note the hardware isn't especially Y2K compliant either.

Max number of extents (121) for segment blah reached. => Max amount of patience for DBA reached!

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************

Received on Wed Aug 28 2002 - 06:43:43 CDT