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 :
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 ?
also realised that these sessions appear in oracle 8 databases aswell. Do these sessions belong to the oracle background processes?
These are Oracle processes, for example, PMON, SMON, DBWR, etc.
If you look at the owner of thes processes, you should see 'SYS'.
They are oracle internal processes...
If you don't want to include the SID's of
background process just include in the WHERE statement:
WHERE username is not null;
Keep it cool.
sometimes you may have to use
where type <> 'BACKGROUND'
check for type = 'BACKGROUND' from the v$session. this will list u all the background processes. Hope that helps.