From: Muqthar Ahmed (Muqthar.Ahmed@DECORATETODAY.COM)
Date: Thu Aug 15 2002 - 14:43:57 EDT
Tim,
Ask DBA to run the following query and it will ask you to "Enter value for spid:", enter PID no: 14494
set verify off
set linesize 100
col username format a15
col osuser format a10
col program format a30
select a.username, a.osuser, a.program, a.process, spid, sid, a.serial#
from v$session a, v$process b
where a.paddr = b.addr
and spid = '&spid';
Muqthar Ahmed
-----Original Message-----
From: TIM MUELLER [mailto:MUELLT@JFS.HAMILTON-CO.ORG]
Sent: Thursday, August 15, 2002 1:26 PM
To: aix-l@Princeton.EDU
Subject: Odd Oracle Process
Our Oracle DBA just brought this to my attention and asked if I knew anything about it. I don't, so I'm hoping one of you can shed some light on this. The process below appeared for the first time recently, if not today, and is unkillable (at least kill -9 14494 won't kill it). Any ideas? TIA.
UID PID PPID C STIME TTY TIME CMD
oracle 14494 1 120 Dec 31 - 0:00 []
Tim Mueller
Hamilton County Dept. of Job & Family Services
Cincinnati, Ohio USA
muellt@jfs.hamilton-co.org
This archive was generated by hypermail 2.1.7 : Wed Apr 09 2008 - 22:16:09 EDT