Home » RDBMS Server » Performance Tuning » Which is memory set to shared pool?
Which is memory set to shared pool? [message #264881] Tue, 04 September 2007 22:11 Go to next message
trantuananh24hg
Messages: 668
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
Hi all!

My OS: Windows Server 2003
My Oracle Database: 10.2.0.1
My Oracle AS: 10.1
Physical Memory : 3GB


Default Shared_Pool_Size: 400M
Default Buffer Cache: 125M
Default Redo Buffer: 50M
Default Java Pool: 8M
Default Large Pool: 8M

At the last weekend, my log_track script presented that some Shared_Pool increased to 90% during 6 hours.

DBMS_STAT pack took some information about the shared pool need to increase.

Script job took information about free memory at 0.

Which memory can I set to Shared Pool?

Thank you very much!
Re: Which is memory set to shared pool? [message #264882 is a reply to message #264881] Tue, 04 September 2007 22:15 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member


Quote:
Which memory can I set to Shared Pool?


Shared_pool_size parameter.
Re: Which is memory set to shared pool? [message #264884 is a reply to message #264881] Tue, 04 September 2007 22:25 Go to previous messageGo to next message
trantuananh24hg
Messages: 668
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
If only shared_pool_size, it's simply for me.

In Oracle DB 10g, the Automatic Shared Memory Management configures the shared memory, including the buffer cache and the SGA_TARGET is recommended to set equal as SGA.

I tried to set parameter Shared_Pool_Size = 1024MB, but DB can not startup.


Thank you!


Re: Which is memory set to shared pool? [message #264887 is a reply to message #264881] Tue, 04 September 2007 22:46 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Hai There,

If you set only sga_target other settings will oracle implicitly set as they need. You need not to worry about it.


Re: Which is memory set to shared pool? [message #264965 is a reply to message #264881] Wed, 05 September 2007 02:29 Go to previous messageGo to next message
trantuananh24hg
Messages: 668
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
Yeah!

I just found the section of it.
Thanks for your reply!

I've migrated in 10g DB, and something not like 9i.

What about spreport.sql? Is it same to 9i? And, if I want to run spcreate.sql, is it still in /rdbms/admin?

Thank you!

Re: Which is memory set to shared pool? [message #264971 is a reply to message #264965] Wed, 05 September 2007 02:49 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
What about spreport.sql? Is it same to 9i?

Quite the same, make a diff if you want the details.
Quote:
And, if I want to run spcreate.sql, is it still in /rdbms/admin?

Yes

Regards
Michel


Re: Which is memory set to shared pool? [message #265164 is a reply to message #264971] Wed, 05 September 2007 10:15 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
You can also run now ADDMRPT.sql and AWRRPT.sql Wink
Previous Topic: netstat| grep 1522| wc -l
Next Topic: Help - Tuning query
Goto Forum:
  


Current Time: Wed Dec 07 18:28:49 CST 2016

Total time taken to generate the page: 0.12467 seconds