rogue sessions

[Sureshy]

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

[Sureshy]

Hi..

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

Thanks

Suresh

[dknight]

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

[shadow21]

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

Cheers

[Sureshy]

Thanks Folks

[reydp]

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.

[pando]

sometimes you may have to use

select *
from v$session
where type <> 'BACKGROUND'

[vinit]

check for type = 'BACKGROUND' from the v$session. this will list u all the background processes. Hope that helps.

cheers,