Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: tirggers

RE: tirggers

From: Hillman, Alex <Alex.Hillman_at_usmint.treas.gov>
Date: Mon, 09 Apr 2001 10:58:04 -0700
Message-ID: <F001.002E5786.20010409104026@fatcity.com>

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).
Received on Mon Apr 09 2001 - 12:58:04 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US