Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: HELP! Session ID from a PID!

Re: HELP! Session ID from a PID!

From: Yassir Khogaly <yassir_khogaly_at_lineone.net>
Date: Sat, 26 Jun 1999 10:52:52 +0300
Message-ID: <VUZc3.14$uY4.343@newreader.ukcore.bt.net>


set heading off
set termout off
ttitle off
clear breaks
clear computes
set heading on
set termout on

rem -----------------------------------------------------------------------
rem Current Users
rem -----------------------------------------------------------------------

set pagesize 66

column "DB UserName" format a15
column "OS UserName" format a15
column machine format a10
column terminal format a10

select username "DB UserName",

        osuser "OS UserName",
        substr(object,1,25) Object,
        command, machine, terminal, process, status
from v$access a, v$session s
where a.sid = s.sid
order by username
/
clear columns
column "OS Program Name" format a40

select username "DB UserName",

        osuser "OS UserName",
        substr(command,1,3) CMD,
        machine, terminal, process, status,
        program "OS Program Name"

from v$session
where type = 'USER'
order by username
/

<larionov_at_yahoo.com> wrote in message news:7l0mk1$dsr$1_at_nnrp1.deja.com...
> Hi,
>
> I found that on the system I manage ( Oracle 8.032 on Solaris2.6 )
> there is sometimes some oracle processes which take
> 25% or more of CPU.
> How can I find their SID in order to kill them.
>
> OK, I tried v$session, but it does not help
> when dealing with parallel query processes.
>
> For example the offending process is ora_p068_SID,
> and v$session in this case does not return any rows.
>
> Maybe there are some other dynamic views which I can use
> to determine their SID ( and serial number )?
>
> Please help!
>
> When posting please send a copy to
> larionov_at_yahoo.com
>
> Thank you!
>
> Michael.
>
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Sat Jun 26 1999 - 02:52:52 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US