oracle dba - session question

Posted on 2005-05-04
Medium Priority
Last Modified: 2006-11-18

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.
Question by:dcmumbai
1 Comment
LVL 15

Accepted Solution

ishando earned 375 total points
ID: 13932590
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.

Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
Suggested Courses

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question