Re: how to know the process/packages/objects accessed by an user in a session

From: Valentin Minzatu <valentinminzatu_at_yahoo.com>
Date: 7 Mar 2007 07:15:40 -0800
Message-ID: <1173280540.213502.202840@j27g2000cwj.googlegroups.com>

On Mar 7, 6:46 am, "Bobby" <almit..._at_gmail.com> wrote:
> Hi,
> I want to know what all are the processes which are accessing a set of
> objects for a monitoring purpose. What are the possibilities other
> than doing a search in the file dumps extracted?
> Thanks,
> Bobby

V$ACCESS gives you the list of objects per session ID. For monitoring purposes, auditing is probably the right way to go, as gazzag suggested, because it is already built and you need not to code for it.

Valentin Received on Wed Mar 07 2007 - 09:15:40 CST