Re: Logging question

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Sun, 14 Mar 2004 15:32:48 +0100
Message-ID: <f7q8509j8v8ldmpgbovl0bgnl0sdhh7b08@4ax.com>

On Sun, 14 Mar 2004 14:34:46 +0100, "Tom Miskiewicz" <miskiewicz2_at_yahoo.com> wrote:

>Hello!
>
>I'm using Oracle 8.1.7. Is there any loggin facility, that allows me to
>monitor queries being executed on specific tables?
>Lets say, I have 10 tables named TableA - TableJ. I want enable a log on
>TableB for, lets say a week or two, to analyze the queries being executed on
>that table.
>
>Regards
>Thomas
>

Just install statspack, and automatically collect statistics every hour. Statspack will also collect the queries being executed together with resources consumed.
The installation procedure are in
$ORACLE_HOME/rdbms/admin/spcreate.sql

--
Sybrand Bakker, Senior Oracle DBA

Received on Sun Mar 14 2004 - 08:32:48 CST