| Which is memory set to shared pool? [message #264881] |
Tue, 04 September 2007 22:11  |
trantuananh24hg
Messages: 744
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 #264884 is a reply to message #264881] |
Tue, 04 September 2007 22:25  |
trantuananh24hg
Messages: 744
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 #264965 is a reply to message #264881] |
Wed, 05 September 2007 02:29 |
trantuananh24hg
Messages: 744
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!
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
