| different results [message #372766] |
Wed, 07 March 2001 14:34 |
chris Yu
Messages: 2
Registered: March 2001
|
Junior Member |
|
|
I have two queries:
select sum(sharable_mem) from v$db_object_cache;
select sum(sharable_mem), sum(250*users_opening)
from v$sqlarea;
Because I want to add three figures and I unite them into:
SELECT SUM(a.sharable_mem)+SUM(b.sharable_mem)
+SUM(250*b.users_opening) "SGA minimum required"
FROM V$DB_OBJECT_CACHE a, V$SQLAREA b;
Not only I got the different results, the speed is very slow. Is there any one can tell me what is wrong?
Thanks
Chris
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
