oracle dba - session question

Posted on 2005-05-04
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

    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
    How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

    737 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

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now