| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: STATUS INACTIVE in V$session
Inactive only means that the session is not currently executing any sql. It is quite normal for a session to switch back and forth from active to inactive. Now if you find sessions with a status of SNIPED, those are hung due to the client being unresponsive. If you issue a kill -3 <spid> where SPID comes from the V$PROCESS view, you'll end up with an ORA-7445 error in the alert.log and a core dump that can be safely ignored.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-----Original Message-----
Sent: Friday, May 16, 2003 1:57 PM
To: Multiple recipients of list ORACLE-L
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:Received on Fri May 16 2003 - 15:08:13 CDT
>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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: DGoulet_at_vicr.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).
 |
 |