Extra SYS entries in V$session view?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Extra SYS entries in V$session view?

  1. #1
    Join Date
    Aug 2000
    Posts
    68

    Extra SYS entries in V$session view?

    Hi All

    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
    from V$session
    where schemaname ='SYS'

    results--

    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.
    Carpe Diem

  2. #2
    Join Date
    Aug 2000
    Posts
    68
    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.
    Carpe Diem

  3. #3
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    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.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  4. #4
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    ..or is there any RMAN backup in progress?
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  5. #5
    Join Date
    Aug 2000
    Posts
    68

    thanks

    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.
    Carpe Diem

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width