oracle dba - session question
Posted on 2005-05-04
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.