OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » 10g ASMM mechanism (10.2.0.4)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

10g ASMM mechanism [message #447820]

Thu, 18 March 2010 02:43

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 ?

Report message to a moderator

Re: 10g ASMM mechanism [message #447822 is a reply to message #447820]

Thu, 18 March 2010 02:47

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: 10g ASMM mechanism [message #447859 is a reply to message #447822]

Thu, 18 March 2010 04:42

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.

Report message to a moderator

Re: 10g ASMM mechanism [message #447872 is a reply to message #447859]

Thu, 18 March 2010 05:05

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: 10g ASMM mechanism [message #447883 is a reply to message #447872]

Thu, 18 March 2010 05:52

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.

Report message to a moderator