KEEP pool has the same LRU algoritm as default one (maybe there are some
small differences) - but main thing is that if you assigned to KEEP pool
objects with combined size > than KEEP pool size (also CR blocks need to be
considered) blocks of these objects will be pushed out of KEEP pool - same
as it was for default pool.
Alex Hillman
-----Original Message-----
From: Kevin Kostyszyn [SMTP:[EMAIL PROTECTED]]
Sent: Monday, April 09, 2001 3:26 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: tirggers
I agree with that, but don't you assing tables to the keep pool?
And if
that is the case and they are all in the keep pool then that would
leave me
to believe that they will not get booted from the keep pool until
the db is
shutdown and restarted?
Kev
-----Original Message-----
Alex
Sent: Monday, April 09, 2001 2:40 PM
To: Multiple recipients of list ORACLE-L
My understanding was that it will be in the keep pool until database
close
or until something else will push it from the pool ( if one has more
blocks
for keep pool than keep pool size) - not until session which used
these
block ends.
Alex Hillman
-----Original Message-----
From: Tim Sawmiller [SMTP:[EMAIL PROTECTED]]
Sent: Monday, April 09, 2001 8:35 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: tirggers
Once accessed they should stay in memory the duration of the
session.
>>> [EMAIL PROTECTED] 04/06/01 01:20PM >>>
I do specify Buffer_pool_keep but I was under the impression
that
you needed
to FTS the tables to get them into memory?
-----Original Message-----
Sawmiller
Sent: Friday, April 06, 2001 9:07 AM
To: Multiple recipients of list ORACLE-L
Why not just specify BUFFER POOL KEEP in an alter table
statement?
>>> [EMAIL PROTECTED] 04/05/01 05:56PM >>>
What is the problem to write something like
Select * from <table_name> for all tables that you need or
if there
are too
many such tables - create a new table with names of the
tables and
use
dynamic SQL .
Alex Hillman
-----Original Message-----
From: Kevin Kostyszyn [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, April 05, 2001 5:28 PM
To: Multiple recipients of list ORACLE-L
Subject: tirggers
Hi Intelligent DBA's
I was wondering if anyone knows how to
create a
trigger that
would fire off
at database startup time and run a script to do full
table
scans on
several
tables to get them into the buffer cache keep pool?
Right
now I do
it
manually and would like to automate the task.
Sincerely,
Kevin Kostyszyn
DBA
Dulcian, Inc
www.dulcian.com
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
--
Author: Kevin Kostyszyn
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hillman, Alex
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tim Sawmiller
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kevin Kostyszyn
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tim Sawmiller
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hillman, Alex
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kevin Kostyszyn
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hillman, Alex
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).