Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: find the system process for an oracle session
Nope. Brazillians do not have football, only soccer.
I've never seen a brazillian team going to the superbowl.
I believe that Denver and Packers will be going there this
year. None of those two teams is from Brazil.
> -----Original Message-----
> From: MOORE, Peter Rbh [mailto:Peter.MOORE.RBH_at_reading.sema.slb.com]
> Sent: Friday, November 22, 2002 11:04 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: find the system process for an oracle session
>
>
> Ginko Biloba?
> Isn't he a Brazilian footballer?
>
> Pete
>
>
> > -----Original Message-----
> > From: Ruth Gramolini [mailto:rgramolini_at_tax.state.vt.us]
> > Sent: 22 November 2002 15:51
> > To: MOORE, Peter Rbh; ORACLE-L_at_fatcity.com
> > Subject: Re: find the system process for an oracle session
> >
> >
> > Thanks! I had a senior moment there. Guess I'll get some
> > coffee to wash
> > down my Ginko Biloba.
> >
> > Ruth
> > ----- Original Message -----
> > From: "MOORE, Peter Rbh" <Peter.MOORE.RBH_at_reading.sema.slb.com>
> > To: <ORACLE-L_at_fatcity.com>; <rgramolini_at_tax.state.vt.us>
> > Sent: Friday, November 22, 2002 10:28 AM
> > Subject: RE: find the system process for an oracle session
> >
> >
> > > select p.spid, s.sid, s.username, s.program
> > > from v$session s, v$process p
> > > where p.addr = s.paddr
> > >
> > > p.spid shows you the o/s process ID for the session.
> > >
> > > --
> > > Peter Moore
> > > Systems DBA,
> > > Mid-Range Centre of Expertise,
> > > Global Service Delivery,
> > > SchlumbergerSema,
> > > Reading
> > >
> > > Phone: 0118 963 6827
> > > Email: pmoore7_at_slb.com
> > >
> > >
> > > > -----Original Message-----
> > > > From: Ruth Gramolini [mailto:rgramolini_at_tax.state.vt.us]
> > > > Sent: 22 November 2002 14:54
> > > > To: Multiple recipients of list ORACLE-L
> > > > Subject: find the system process for an oracle session
> > > >
> > > >
> > > > Good morning,
> > > >
> > > > Can anyone send my the sql to find the system process
> > being used by an
> > > > oracle session. I know this has been out here before, but I
> > > > can't find it
> > > > in my saved stuff.
> > > >
> > > > Thanks in advance,
> > > > Ruth
> > > >
> > > > --
> > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > > --
> > > > Author: Ruth Gramolini
> > > > INET: rgramolini_at_tax.state.vt.us
> > > >
> > > > Fat City Network Services -- 858-538-5051
> > http://www.fatcity.com
> > > > San Diego, California -- Mailing list and web
> > hosting services
> > > >
> >
> ---------------------------------------------------------------------
> > > > To REMOVE yourself from this mailing list, send an
> E-Mail message
> > > > to: ListGuru_at_fatcity.com (note EXACT spelling of
> > 'ListGuru') and in
> > > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > > (or the name of mailing list you want to be removed
> > from). You may
> > > > also send the HELP command for other information (like
> > subscribing).
> > > >
> > >
> > >
> > > _________________________________________________________
> > > This email is confidential and intended solely for the use of the
> > > individual to whom it is addressed. Any views or opinions
> > presented are
> > > solely those of the author and do not necessarily
> represent those of
> > > SchlumbergerSema.
> > > If you are not the intended recipient, be advised that you
> > have received
> > > this email in error and that any use, dissemination,
> > forwarding, printing,
> > > or copying of this email is strictly prohibited.
> > >
> > > If you have received this email in error please notify the
> > > SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600.
> > > _________________________________________________________
> > >
> >
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: MOORE, Peter Rbh
> INET: Peter.MOORE.RBH_at_reading.sema.slb.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: MGogala_at_oxhp.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Fri Nov 22 2002 - 12:04:12 CST