Home » RDBMS Server » Server Administration » Miscellaneous Part in Shared Pool (Oracle 10g,HP-UX)
Miscellaneous Part in Shared Pool [message #416526] Mon, 03 August 2009 04:33 Go to next message
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 #416528 is a reply to message #416526] Mon, 03 August 2009 04:45 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please post the query you used to get this result; there is more "misc" part in v$sgastat in 10.2.

See:
http://forums.databasejournal.com/showthread.php?p=76847

Please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter), use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version with 4 decimals.

Regards
Michel

[Updated on: Mon, 03 August 2009 04:46]

Report message to a moderator

Re: Miscellaneous Part in Shared Pool [message #416530 is a reply to message #416528] Mon, 03 August 2009 04:51 Go to previous messageGo to next message
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

Re: Miscellaneous Part in Shared Pool [message #416533 is a reply to message #416530] Mon, 03 August 2009 05:00 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Directly query v$sgastat and you will know which parts take the space.

Regards
Michel
Re: Miscellaneous Part in Shared Pool [message #416541 is a reply to message #416533] Mon, 03 August 2009 05:09 Go to previous messageGo to next message
vinniora
Messages: 56
Registered: October 2008
Location: Mumbai
Member
i Have done that sir,but i want to know what is miscellaneous part stands for in shared pool.Does High value of this affect the system if so then how to reduce it or tune it.
Re: Miscellaneous Part in Shared Pool [message #416560 is a reply to message #416541] Mon, 03 August 2009 05:37 Go to previous message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And I say execute the second part of the query without grouping the result and you will see which part os sga takes place.
Just do it.

Regards
Michel
Previous Topic: Want to use 32GB RAM in oracle 9i
Next Topic: Get a list of schemas which are able to update into objects under another user
Goto Forum:
  


Current Time: Thu Dec 08 02:28:24 CST 2016

Total time taken to generate the page: 0.05791 seconds