• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 823
  • Last Modified:

oracle dba - session question


I have one user brc , she is running some front end unica application. v$session shows 53 recods for that user in v$session. I am giving some sample. It's oracle 9, unix server , datawarehousing environment.
Should I get one session record or should i get different sid and serial# to same user if she is using it from different terminals or she might be running something in parallel. login times for 47 records are same.

Could you please explain how to read session and if i have to kill this user's session then do i have to find all 53 sid and serail# ?

SID      SERIAL#      USERNAME      PROGRAM      
119      12012      BRC      unicab@b (TNS V1-V3)      
296      3289      BRC      unicab@b (TNS V1-V3)      
73      1150      BRC      oracle@a (P007)      
238      326      BRC      oracle@explorer (P011)      
112      6549      BRC      oracle@a (P018)      
196      748      BRC      oracle@a (P024)      
21      7341      BRC      oracle@a (P031)      
15      3007      BRC      oracle@a (P033)      
76      1800      BRC      oracle@a (P035)      
281      2045      BRC      oracle@a (P037)      
169      16054      BRC      oracle@a (P036)      

Thanka lot in advance.
1 Solution
The (Pnnn) identifiers in the program column suggest that she is running a job a query/job that has spawned a lot of parallel processes. You might want to examine why there are 37 parallel processes, and maybe put a lower limit in place.

You will get a separate sid, serial# for each connection to the database, so if she has logged in twice, you will have 2 different sid/serial# for her. The parallel processes will be seen as separate connections which are created automatically by Oracle.

If you need to kill the session, it would be best to kill the session that issued the command that caused the parallel processes to be spawned. It should be one of the unicab@b ones rather that the oralce@b ones.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now