Hello Mogens, TCH is the touch count.
Cheers Connor OT - enjoy JL's conference this week. --- Mogens N�rgaard <[EMAIL PROTECTED]> wrote: > 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 times > >it was selected > > > > > >--- Whittle Jerome Contr NCI > <[EMAIL PROTECTED]> wrote: > > > >>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. > >>[EMAIL PROTECTED] > >>618-622-4145 > >>-- > >>Please see the official ORACLE-L FAQ: > http://www.orafaq.com > >>-- > >>Author: Whittle Jerome Contr NCI > >> INET: [EMAIL PROTECTED] > >> > >>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: [EMAIL PROTECTED] (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). > >> > > > > > >__________________________________________________ > >Do You Yahoo!? > >Send FREE video emails in Yahoo! Mail! > >http://promo.yahoo.com/videomail/ > > > > ===== Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) "Some days you're the pigeon, some days you're the statue" __________________________________________________ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
