Re: Lookup Table Usage

From: Mogens Nørgaard <mln_at_miracleas.dk>
Date: Sun, 20 Jan 2002 02:23:59 -0800
Message-ID: <F001.003F50EE.20020120013025@fatcity.com>

And in 8i there's a column in x$bh which counts the number of times the buffer is touched (as I recall) called XNC or something?

Rachel Carmichael wrote:

  you could turn auditing on on the table and count the number of timesit was selected--- Whittle Jerome Contr NCI <Jerome.Whittle_at_scott.af.mil> wrote:   

    Hi,Oracle 7.3.4 on Unix.The database has dozens of little lookup tables. I'd like to cachethoseused the most. Is there a way to see how often a table is queried?Thanks,Jerry WhittleACIFICS DBANCI Information Systems Inc.jerome.whittle@scott.af.mil618-622-4145--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Whittle Jerome Contr NCI  INET: Jerome.Whittle@scott.af.milFat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051San Diego, California        -- Public Internet access / MailingLists--------------------------------------------------------------------To REMOVE yourself from this mailing list, send a

n E-Mail messageto: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).     

    __________________________________________________Do You Yahoo!?Send FREE video emails in Yahoo! Mail!http://promo.yahoo.com/videomail/
    
    
    
    

Received on Sun Jan 20 2002 - 04:23:59 CST