-
ver 7.2.2
Hi Friends
I have an ancient database whih has about 7 sessions in there which aren't user sessions.
They have sids and serial#'s as follows :
sid serial#
1 1
2 1
3 1
4 1
5 1
6 1
7 1
when I try an kill any of these sessions I get an error explaining that they are not user sessions
Does anyone know what type of sessions they could be ?
Thanks
Suresh
Once you have eliminated all of the impossible,
whatever remains however improbable,
must be true.
-
Hi..
also realised that these sessions appear in oracle 8 databases aswell. Do these sessions belong to the oracle background processes?
Thanks
Suresh
Once you have eliminated all of the impossible,
whatever remains however improbable,
must be true.
-
These are Oracle processes, for example, PMON, SMON, DBWR, etc.
David Knight
OCP DBA 8i, 9i, 10g
-
hi,
If you look at the owner of thes processes, you should see 'SYS'.
They are oracle internal processes...
Cheers
-
Once you have eliminated all of the impossible,
whatever remains however improbable,
must be true.
-
If you don't want to include the SID's of
background process just include in the WHERE statement:
select sid,.....
from v$session
WHERE username is not null;
Keep it cool.
-
sometimes you may have to use
select *
from v$session
where type <> 'BACKGROUND'
-
check for type = 'BACKGROUND' from the v$session. this will list u all the background processes. Hope that helps.
cheers,
Vinit
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|