RE: Lookup Table Usage

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Wed, 16 Jan 2002 14:50:45 -0800
Message-ID: <F001.003F2055.20020116143533@fatcity.com>

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 you how often a text string occurs.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Wednesday, January 16, 2002 3:20 PM To: Multiple recipients of list 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: DENNIS WILLIAMS
INET: DWILLIAMS_at_LIFETOUCH.COM

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------