v$session and high water mark
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: v$session and high water mark

Hybrid View

  1. #1
    Join Date
    Apr 2001
    Posts
    151
    We are running Oracle 8.0.6.1 on NT 4.0/sp6a
    Querry from v$session - 1126 rows selected
    Is there any relationship between this number and database high water mark?
    If I have sort_area_size = 768000, can I say memory used by users is aroung 768000 * 1126
    Just need some clarification.
    Thanks
    Elin@trend

  2. #2
    Join Date
    Jan 2002
    Posts
    59
    There is no relation between v$session and HWM.
    HWM is concerned with permenant segments and not at a DB level.
    Atleast this is not the right math to calculate the UserProcess Memory. Sort_area_size doesnt come into this calculation.

    Thanx
    Sanjay

  3. #3
    Join Date
    Apr 2001
    Posts
    151
    when user connected to oracle (dedicate server), sort_area_size = 768000 was allocated for this user. We have only 250 users, but with about 1200 (from v$session).
    What do these number tell me:
    a. 768000 * 250 users
    and b. 768000 * 1200
    I was told by Oracle technical support, our system is hitting the resource limits (they use b formula).
    ???
    Elin@trend

  4. #4
    Join Date
    Jan 2002
    Posts
    59
    Though the process is eligible to use MAX sort_area_size, but uses only during a qualified query.

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