We are running Oracle 22.214.171.124 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.
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.
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).
Though the process is eligible to use MAX sort_area_size, but uses only during a qualified query.