Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: HELP! Session ID from a PID!
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, statusfrom v$access a, v$session s
select username "DB UserName",
osuser "OS UserName", substr(command,1,3) CMD, machine, terminal, process, status, program "OS Program Name"
<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