Re: tirggers

So let me see if I have it straight, as long as the keep pool is larger than the tables and/or objects that I want to put in it, I should be ok? Also, sorry about that spelling error earlier, I don't want to be assing tables to the pool I want to assign them to the pool:) Kev
----- Original Message -----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Monday, April 09, 2001 7:05 PM

> 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).

-- 
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).