| Miscellaneous Part in Shared Pool [message #416526] |
Mon, 03 August 2009 04:33  |
vinniora
Messages: 56
Registered: October 2008
Location: Mumbai
|
Member |
|
|
Hi all, I would like to know about Miscellaneous Part in shared pool what it is??Is it affecting the oracle instance and i also want to know why
miscellaneous part of shared pool is having high value.
Shared Pool miscellaneous 2,083,673,640
Shared Pool sql area 150,915,480
Shared Pool library cache 96,907,000
Shared Pool free memory 33,116,296
thank you in advance
|
|
|
|
|
|
| Re: Miscellaneous Part in Shared Pool [message #416530 is a reply to message #416528] |
Mon, 03 August 2009 04:51  |
vinniora
Messages: 56
Registered: October 2008
Location: Mumbai
|
Member |
|
|
Dear sir, oracle version is 10.1.2.0 and the query is
SELECT 'Shared Pool' area, name, sum(bytes)
FROM v$sgastat
WHERE pool = 'shared pool' and
name in ('library cache','dictionary cache','free memory','sql area')
group by name
union all
SELECT 'Shared Pool' area, 'miscellaneous', sum(bytes)
FROM v$sgastat
WHERE pool = 'shared pool' and
name not in ('library cache','dictionary cache','free memory','sql area')
group by pool
order by 3 desc;
[Updated on: Mon, 03 August 2009 04:54] Report message to a moderator |
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
