rogue sessions

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

Hi..

also realised that these sessions appear in oracle 8 databases aswell. Do these sessions belong to the oracle background processes?

Thanks

Suresh

These are Oracle processes, for example, PMON, SMON, DBWR, etc.

hi,
If you look at the owner of thes processes, you should see 'SYS'.
They are oracle internal processes...

Cheers

Thanks Folks

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,