Home » RDBMS Server » Server Administration » different results
different results [message #372767] Wed, 07 March 2001 14:34 Go to next message
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

Report message to a moderator

Re: different results [message #372772 is a reply to message #372767] Thu, 08 March 2001 08:01 Go to previous message
sunil gupta
Messages: 11
Registered: September 2000
Junior Member
U need to give a join between the two tables ie between V$DB_OBJECT_CACHE , V$SQLAREA then only u will get the correct result.

Report message to a moderator

Previous Topic: Query
Next Topic: Re: number of rows in select with minus
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jun 29 13:30:34 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.