Re: Table use investigation
From: Harel Safra <harel.safra_at_gmail.com>
Date: Wed, 22 Aug 2012 20:09:31 +0300
Message-ID: <CA+UC=5EtkKZTy=znD16RymdPenMc5F08PKqRYXVRr79AHQnSTA_at_mail.gmail.com>
I'd define auditing on the table and wait to see what comes up: http://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_4007.htm#i2059073 AUDIT SELECT
ON hr.employees;
Harel
Date: Wed, 22 Aug 2012 20:09:31 +0300
Message-ID: <CA+UC=5EtkKZTy=znD16RymdPenMc5F08PKqRYXVRr79AHQnSTA_at_mail.gmail.com>
I'd define auditing on the table and wait to see what comes up: http://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_4007.htm#i2059073 AUDIT SELECT
ON hr.employees;
Harel
On Wed, Aug 22, 2012 at 8:02 PM, Anthony Ballo <anthony.ballo_at_onecall.com>wrote:
> I have assumed responsibility for a 5 year old running EBS 12 database and
> came across a mysterious table that has grown to 186m rows. It is created
> via trigger on a standard EBS (Advanced Pricing) table named:
> QP.QP_PREQ_LINE_ATTRS_TMP_T. This trigger basically archives the data from
> this GTT from Advanced Pricing in EBS.
>
> ...
>
> Anthony
>
>
>
>
>
>
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Aug 22 2012 - 12:09:31 CDT