Home » RDBMS Server » Server Administration » 10g ASMM mechanism (10.2.0.4)
10g ASMM mechanism [message #447820] Thu, 18 March 2010 02:43 Go to next message
ankush_chawla
Messages: 136
Registered: November 2006
Senior Member
I have few confusion with oracle 10g ASMM and want some suggestions before implementing

1.sga_target = 1024 M .
db_cache_size = 0
shared_pool_size = 0
sga_max_size as 1024M
large_pool=24 M
java_pool=24 M
Will Oracle automatically set the size of shared pool and db cache while starting the instance.

2. In case i manually specify value of db_cache_size and shared_pool_size.
DOes the size manually specified is the minimum and inital size of shared pool and db cache ?
Will it can resize (increase/decrease) as per the workload ?




Re: 10g ASMM mechanism [message #447822 is a reply to message #447820] Thu, 18 March 2010 02:47 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
2. Yes. Yes but never decrease below the values you gave.

Have a look at V$SGA_RESIZE_OPS.

Regards
Michel
Re: 10g ASMM mechanism [message #447859 is a reply to message #447822] Thu, 18 March 2010 04:42 Go to previous messageGo to next message
ankush_chawla
Messages: 136
Registered: November 2006
Senior Member
thanks for the reply

1. But the 1 st point still remain unaswered.

2. As per my underestanding oracle will never decrease the size specified in the init file for shared_pool and db_Cache
let me know if i m wrong in my understanding.
Re: 10g ASMM mechanism [message #447872 is a reply to message #447859] Thu, 18 March 2010 05:05 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
1. But the 1 st point still remain unaswered.

I don't see any question in point 1.

Quote:
2. As per my underestanding oracle will never decrease the size specified in the init file for shared_pool and db_Cache
let me know if i m wrong in my understanding.

Correct. If you want to efficiently use ASMM use spfile not init.ora as then Oracle will know the last used values and has not to restart from the beginning to find again the appropriate values at next instance start.

Regards
Michel
Re: 10g ASMM mechanism [message #447883 is a reply to message #447872] Thu, 18 March 2010 05:52 Go to previous messageGo to next message
ankush_chawla
Messages: 136
Registered: November 2006
Senior Member
thanks for the reply.

i want to know can i set the db_cache_size as 0 and shared_pool_size as 0 in init file and allow oracle to initialize thier size while starting the instance.
Re: 10g ASMM mechanism [message #447888 is a reply to message #447883] Thu, 18 March 2010 06:07 Go to previous messageGo to next message
ankush_chawla
Messages: 136
Registered: November 2006
Senior Member
if i set the value of shared_pool_size to a non-zero value .
will oracle auto tune it or not?
Re: 10g ASMM mechanism [message #447891 is a reply to message #447888] Thu, 18 March 2010 06:14 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you set sga_target.

Regards
Michel
Previous Topic: Unable to use existnig oraInventory location during installation
Next Topic: OS_CPU_WAIT_TIME AND PHYSICAL_MEMORY_BYTE
Goto Forum:
  


Current Time: Sat Dec 10 17:01:25 CST 2016

Total time taken to generate the page: 0.10295 seconds