| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: tirggers
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:kevin_at_dulcian.com]
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:sawmillert_at_state.mi.us]
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.
>>> kevin_at_dulcian.com 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?
>>> Alex.Hillman_at_usmint.treas.gov 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:kevin_at_dulcian.com]
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
kevin_at_dulcian.com
--
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
--
Author: Kevin Kostyszyn
INET: kevin_at_dulcian.com
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: ListGuru_at_fatcity.com (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: Alex.Hillman_at_usmint.treas.gov
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: ListGuru_at_fatcity.com (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: sawmillert_at_state.mi.us
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: ListGuru_at_fatcity.com (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: kevin_at_dulcian.com
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: ListGuru_at_fatcity.com (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: sawmillert_at_state.mi.us
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: ListGuru_at_fatcity.com (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: Alex.Hillman_at_usmint.treas.gov
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: ListGuru_at_fatcity.com (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: kevin_at_dulcian.com
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: ListGuru_at_fatcity.com (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: Alex.Hillman_at_usmint.treas.gov 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: ListGuru_at_fatcity.com (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 Mon Apr 09 2001 - 17:22:57 CDT
 |
 |