Re: Lookup Table Usage

Auditing would be more reliable, it's static.

Using v$db_object_cache would require monitoring the view, determining the difference from the last time you checked it, etc. You would lose any data between the last time you checked and a database shutdown.

Jared

hemantchitale_at_charteredsemi.com
Sent by: root_at_fatcity.com
01/17/02 10:45 PM
Please respond to ORACLE-L  

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        Re: Lookup Table Usage

Try using V$DB_OBJECT_CACHE , I think it does exist in 7.3.4

Hemant K Chitale
Principal DBA
Chartered Semiconductor Manufacturing Ltd

Jared.Still_at_radisys.com 17/01/2002 07:07 AM Sent by: root_at_fatcity.com

Please respond to ORACLE-L   

             To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>

             cc: (bcc: CHITALE Hemant Krishnarao/Prin DBA/CSM/ST Group)  

             Subject: Re: Lookup Table Usage         

Use database auditing.

Lookup 'audit' in the SQL manual.

Jared

                    "Whittle Jerome

                    Contr NCI"                To:     Multiple recipients
of list ORACLE-L <ORACLE-L_at_fatcity.com>
                    <Jerome.Whittle_at_sco       cc:

                    tt.af.mil>                Subject:     Lookup Table
Usage
                    Sent by:

                    root_at_fatcity.com



                    01/16/02 01:20 PM

                    Please respond to

                    ORACLE-L

Hi,

Oracle 7.3.4 on Unix.

The database has dozens of little lookup tables. I'd like to cache those used the most. Is there a way to see how often a table is queried?

Thanks,

Jerry Whittle
ACIFICS DBA
NCI Information Systems Inc.
jerome.whittle_at_scott.af.mil
618-622-4145

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Whittle Jerome Contr NCI
  INET: Jerome.Whittle_at_scott.af.mil

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:
  INET: Jared.Still_at_radisys.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: 
  INET: hemantchitale_at_charteredsemi.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: 
  INET: Jared.Still_at_radisys.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).