Thanks, Connor. Oh, did I enjoy the Master Class this past week. A couple
of situations:
14 people, including Millsap, Steve Adams, Jonathan Lewis, James Morle and
what have you sitting around my oak table one evening when dinner is served.
Most of the guys simply closed their laptops,
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
by: [EMAIL PROTECTED]
01/17/02 10:45 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
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
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: (bcc: CHITALE Hemant Krishnarao/Prin DBA/CSM/ST Group)
Subject: Re: Lookup
Jerry - If they are stored in separate tablespaces, it would be easy.
However, we DBAs tend to not keep small code tables in separate tablespaces.
You can dump v$sqltext to an O.S. file and search for these table names to
get an idea of how often they are used. On Unix, for example, grep can tell
Use database auditing.
Lookup 'audit' in the SQL manual.
Jared
Whittle Jerome
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