Re: table accesing
From: gazzag <gareth_at_jamms.org>
Date: Wed, 17 Dec 2008 04:24:12 -0800 (PST)
Message-ID: <84d5e52a-052d-43ef-ab70-1417f0f86147@d42g2000prb.googlegroups.com>
Date: Wed, 17 Dec 2008 04:24:12 -0800 (PST)
Message-ID: <84d5e52a-052d-43ef-ab70-1417f0f86147@d42g2000prb.googlegroups.com>
On 17 Dec, 08:37, mehraj hussain <mhdmeh..._at_gmail.com> wrote:
> hi, i have table called employees..
>
> many users are accescing this table at a time .. how can i find which
> users is accesing that table presently...
Not sure how, or why, you'd need to do this but I suspect the following views may help:
V$SESSION V$SQL V$SQL_AREA
HTH -g Received on Wed Dec 17 2008 - 06:24:12 CST