Extra SYS entries in V$session view?
When i queried the V$session view.
I can see my background processes As i should:
However i seem to have 4 extra SYS entries in there that i can't explain, the logontime is today's date & time however.
I cannot understand where these 'extra' sys entries came from any ideas??
select sid, serial#, status, schemaname, osuser, type
where schemaname ='SYS'
1 1 ACTIVE SYS SYSTEM BACKGROUND
2 1 ACTIVE SYS SYSTEM BACKGROUND
3 1 ACTIVE SYS SYSTEM BACKGROUND
4 1 ACTIVE SYS SYSTEM BACKGROUND
5 1 ACTIVE SYS SYSTEM BACKGROUND
6 1 ACTIVE SYS SYSTEM BACKGROUND
9 32789 ACTIVE SYS USER
13 42478 ACTIVE SYS USER
15 2782 ACTIVE SYS USER
19 34386 ACTIVE SYS USER
If anyone can suggest somthing great thanks, or if i can provide more information, just post & i'll reply asap.
thanks in advance for any advice/help recieved.
Just a reply to my own msg.
But i think its, users who are connected are updating tables.
So sys is updating the data dictionary that's why it's showing up in the V$Session im sure.
No, yo'we got it wrong. When oracle updates data dictionary on behalf of users, it does not open any extra sessions for that. So those are not sessons to support user updates.
Those sessions belong to job queue processes - check your parameter JOB_QUEUE_PROCESSES and you'l find it is set to 4 - hence your 4 "phantom" sessions.
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
..or is there any RMAN backup in progress?
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
Rman is not runnig so thats not it.
Jmodic is correct...my job_queue_process is set to 4..they are the phantom sys sessions..
many thanks Jmodic & Sanjay G.
Click Here to Expand Forum to Full Width