INACTIVE status here is not a hung process, they are logging in but not do any activities.
--
--------- Original Message ---------
DATE: Tue, 13 May 2003 09:06:39
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
Cc:
>DBAs....
>Hi to everybody...!!
>
>I was wondering about v$session entries with INACTIVE
>status, and OS processes...
>
>I have a lot of entries on a database with oil apps,
>getting this output (this is a short list, the full
>list is larger) (see at end).
>
>then:
>if I do:
>sql> !ps -ef | grep <Some OSPID> I get:
>
> oracle 19850 1 0 May 08 ? 0:04
>oracleowchiche
>(DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))
>
>As you can see... it has PPID = 1...
>I think they are hung processes.
>
>How can I make sure of that? is there a way of
>cleaning that processes from the DB?
>
>Any clues?
>
>TIA.
>
>JL
>
>SID SERIAL OSUSER OSPID STATUS SCHEMA
>TYPE
>--- ----- ------------ --------- -------- ----------
>----
>59 1062 oracle 1950 INACTIVE SYSTEM
>USER
>60 853 abk04 2286 INACTIVE FINALTAR
>USER
>61 1657 abk03 19850 INACTIVE TAR_E
>USER
>64 1150 abk05 11107 INACTIVE OWSYS
>USER
>66 3815 abk03 1877 INACTIVE OWSYS
>USER
>67 3103 oracle 7169 INACTIVE DBSNMP
>USER
>68 127 abk04 1834 INACTIVE FIELD_CAAN
>USER
>69 529 abk03 10883 INACTIVE FINALTAR
>USER
>70 32 abk03 10881 INACTIVE OWSYS
>USER
>74 25 abk03 2205 INACTIVE KANAAB
>USER
>75 53 abk03 2210 INACTIVE OWSYS
>USER
>76 10 abk03 2212 INACTIVE KANAAB
>USER
>77 48 abk05 2218 INACTIVE FINALTAR
>USER
>
>
>
>
>__________________________________
>Do you Yahoo!?
>The New Yahoo! Search - Faster. Easier. Bingo.
>http://search.yahoo.com
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Jose Luis Delgado
> INET: joseluis_delgado_at_yahoo.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).
>
>
____________________________________________________________
Get advanced SPAM filtering on Webmail or POP Mail ... Get Lycos Mail!
http://login.mail.lycos.com/r/referral?aid=27005
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: zions swordfish
INET: zettira_at_lycos.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 May 16 2003 - 12:56:49 CDT
