Hi Sameer

I got it. When a particular user is executing a query, the "server" attribute of v$session changes to "shared" otherwise it is "none". I also checked out the "status" and "queue" attributes of v$circuit. Both give very useful information.

Thanks
Burzin