This discussion is archived
6 Replies Latest reply: Feb 26, 2013 10:09 AM by EdStevens RSS

seeing many spid for one session

507581 Newbie
Currently Being Moderated
Hi,

I am seeing many spid for one session


I have connected to oracle (linux) from a sqlplus (windows).

from this idle session I get sid and serial#;

now I logged in oracle server (linux) and see that there are 84 process to the one session ( in v$session)


Is something wrong in this:
STATUS          SID        PID    SERIAL#     AUDSID USERNAME                       OSUSER                         MACHINE                                                          TERMINAL                PROCESS                  SPID                     PROGRAM                                      EVENT
-------- ---------- ---------- ---------- ---------- ------------------------------ ------------------------------ ----------------------------------- ------------------------------ ------------------------ ------------------------ ------------------------------------------------ ----------------------------------------------------------------
INACTIVE         81          1      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                                          sqlplus.exe          SQL*Net message from client

INACTIVE         81          9      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                 9396                 sqlplus.exe                               SQL*Net message from client
INACTIVE         81         10      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                 9398                 sqlplus.exe                               SQL*Net message from client
INACTIVE         81         11      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                 9400                 sqlplus.exe                               SQL*Net message from client
INACTIVE         81         12      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                 9402                 sqlplus.exe                               SQL*Net message from client
INACTIVE         81         13      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                 9404                 sqlplus.exe                               SQL*Net message from client
INACTIVE         81         14      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                 9406                 sqlplus.exe                               SQL*Net message from client
INACTIVE         81         15      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                 9408                 sqlplus.exe                               SQL*Net message from client
INACTIVE         81         16      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                 9410                 sqlplus.exe                               SQL*Net message from client
INACTIVE         81         17      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                 9412                 sqlplus.exe                               SQL*Net message from client
INACTIVE         81         18      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                 9415                 sqlplus.exe                               SQL*Net message from client
INACTIVE         81         19      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                 2638                 sqlplus.exe                               SQL*Net message from client
INACTIVE         81         20      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                 9471                 sqlplus.exe                               SQL*Net message from client
INACTIVE         81         21      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                 9474                 sqlplus.exe                               SQL*Net message from client
INACTIVE         81         22      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                 9476                 sqlplus.exe                               SQL*Net message from client
INACTIVE         81         23      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                 9479                 sqlplus.exe                               SQL*Net message from client
INACTIVE         81         24      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                 9494                 sqlplus.exe                               SQL*Net message from client
INACTIVE         81         25      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                 9521                 sqlplus.exe                               SQL*Net message from client
INACTIVE         81         26      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                 32302                sqlplus.exe                               SQL*Net message from client
INACTIVE         81         27      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                 32306                sqlplus.exe                               SQL*Net message from client
INACTIVE         81         28      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                 32320                sqlplus.exe                               SQL*Net message from client
INACTIVE         81         29      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                 21358                sqlplus.exe                               SQL*Net message from client
INACTIVE         81         30      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                 9549                 sqlplus.exe                               SQL*Net message from client
INACTIVE         81         31      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                 21361                sqlplus.exe                               SQL*Net message from client
INACTIVE         81         32      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                 21462                sqlplus.exe                               SQL*Net message from client
INACTIVE         81         33      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                 21464                sqlplus.exe                               SQL*Net message from client
INACTIVE         81         34      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                 21495                sqlplus.exe                               SQL*Net message from client
INACTIVE         81         35      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                 21497                sqlplus.exe                               SQL*Net message from client
INACTIVE         81         36      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                 32327                sqlplus.exe                               SQL*Net message from client
INACTIVE         81         37      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                 32334                sqlplus.exe                               SQL*Net message from client
INACTIVE         81         38      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                 11210                sqlplus.exe                               SQL*Net message from client
INACTIVE         81         39      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                 22265                sqlplus.exe                               SQL*Net message from client
INACTIVE         81         40      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                 32338                sqlplus.exe                               SQL*Net message from client
INACTIVE         81         41      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                 32345                sqlplus.exe                               SQL*Net message from client
INACTIVE         81         42      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                 32350                sqlplus.exe                               SQL*Net message from client
INACTIVE         81         43      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                 29871                sqlplus.exe                               SQL*Net message from client
INACTIVE         81         44      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                 32360                sqlplus.exe                               SQL*Net message from client
INACTIVE         81         45      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                 7945                 sqlplus.exe                               SQL*Net message from client
INACTIVE         81         46      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                 32364                sqlplus.exe                               SQL*Net message from client
INACTIVE         81         47      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                 32369                sqlplus.exe                               SQL*Net message from client
INACTIVE         81         48      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                 32373                sqlplus.exe                               SQL*Net message from client
INACTIVE         81         49      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                 29887                sqlplus.exe                               SQL*Net message from client
INACTIVE         81         50      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                 32383                sqlplus.exe                               SQL*Net message from client
INACTIVE         81         51      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                 32388                sqlplus.exe                               SQL*Net message from client
INACTIVE         81         52      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                 32392                sqlplus.exe                               SQL*Net message from client
INACTIVE         81         53      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                 32401                sqlplus.exe                               SQL*Net message from client
INACTIVE         81         54      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                 32408                sqlplus.exe                               SQL*Net message from client
INACTIVE         81         55      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                 32413                sqlplus.exe                               SQL*Net message from client
INACTIVE         81         56      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                 32417                sqlplus.exe                               SQL*Net message from client
INACTIVE         81         57      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                 8438                 sqlplus.exe                               SQL*Net message from client
INACTIVE         81         58      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                 29898                sqlplus.exe                               SQL*Net message from client
INACTIVE         81         59      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                 29686                sqlplus.exe                               SQL*Net message from client
INACTIVE         81         60      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                 29691                sqlplus.exe                               SQL*Net message from client
INACTIVE         81         61      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                 29704                sqlplus.exe                               SQL*Net message from client
INACTIVE         81         62      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                 29715                sqlplus.exe                               SQL*Net message from client
INACTIVE         81         63      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                 29729                sqlplus.exe                               SQL*Net message from client
INACTIVE         81         64      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                 29737                sqlplus.exe                               SQL*Net message from client
INACTIVE         81         65      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                 29741                sqlplus.exe                               SQL*Net message from client
INACTIVE         81         66      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                 29745                sqlplus.exe                               SQL*Net message from client
INACTIVE         81         67      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                 29752                sqlplus.exe                               SQL*Net message from client
INACTIVE         81         68      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                 29760                sqlplus.exe                               SQL*Net message from client
INACTIVE         81         69      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                 29808                sqlplus.exe                               SQL*Net message from client
INACTIVE         81         70      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                 29824                sqlplus.exe                               SQL*Net message from client
INACTIVE         81         71      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                 29831                sqlplus.exe                               SQL*Net message from client
INACTIVE         81         72      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                 29839                sqlplus.exe                               SQL*Net message from client
INACTIVE         81         73      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                 29843                sqlplus.exe                               SQL*Net message from client
INACTIVE         81         74      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                 29853                sqlplus.exe                               SQL*Net message from client
INACTIVE         81         75      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                 29903                sqlplus.exe                               SQL*Net message from client
INACTIVE         81         76      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                 29919                sqlplus.exe                               SQL*Net message from client
INACTIVE         81         77      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                 29924                sqlplus.exe                               SQL*Net message from client
INACTIVE         81         78      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                 29940                sqlplus.exe                               SQL*Net message from client
INACTIVE         81         79      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                 14967                sqlplus.exe                               SQL*Net message from client
INACTIVE         81         80      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                 29949                sqlplus.exe                               SQL*Net message from client
INACTIVE         81         81      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                 9135                 sqlplus.exe                               SQL*Net message from client
INACTIVE         81         82      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                 9137                 sqlplus.exe                               SQL*Net message from client
INACTIVE         81         84      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                 6679                 sqlplus.exe                               SQL*Net message from client
INACTIVE         81         85      40127     290541 SYSTEM                         Administrator                  AHOA                                               AHOA                176:2144                 7787                 sqlplus.exe                               SQL*Net message from client

84 rows selected.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points