Re: How to find the person who has analyzed the table

In article <8rh36t$gh$1_at_newton.pacific.net.sg>,   "Joshua" <joshua.cool_at_pacific.net.sg> wrote:
> Hi,
>
> Is there any way to find out the person(osuser) who has anlyzed the
 table ?
>
> If the table was analyzed two days back , how to find out the person ?
>
> Thanks in advance,
>
> Regards,
>
> Joshua.
>

By default Oracle does not capture the Oracle userid under which an analyze is run. If you want this information you will have to set up an audit trail.

--
Mark D. Powell  -- The only advice that counts is the advice that
 you follow so follow your own advice --


Sent via Deja.com http://www.deja.com/
Before you buy.