Re: abt session

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: Sat, 06 Oct 2007 10:37:40 -0700
Message-ID: <1191692260.567774.263090@d55g2000hsg.googlegroups.com>

On Oct 6, 3:20 am, DA Morgan <damor..._at_psoug.org> wrote:
> sushil.kara..._at_gmail.com wrote:
> > hi
> > how to know which process is performing a user in a perticular session.
>
> PMON, SMON, DBWR, MMON, DMON, LGWR, ARCH ....
> What do processes have to do with sessions?
> --
> Daniel A. Morgan
> University of Washington
> damor..._at_x.washington.edu (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org

I think sushil is asking either how to find the Oracle sessions for a username or how to find the Oracle background sessions associated with a user front-end session.

To find all sessions for a user query v$session for the username.

To find the Oracle background process associated with a front-end process see the following:

Is there a way to trace a unix process id to a SID and SERIAL# ? http://www.jlcomp.demon.co.uk/faq/sid_from_proc.html

syshil, if you want to know something else you will need to post back with more detail of what it is you are really asking.

HTH -- Mark D Powell -- Received on Sat Oct 06 2007 - 12:37:40 CDT