OraFAQ Forum: Training & Certification » Which 3 can be change dynamically

Home » Other » Training & Certification » Which 3 can be change dynamically

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

Which 3 can be change dynamically [message #256300]

Fri, 03 August 2007 14:22

itguru
Messages: 19
Registered: July 2007

Junior Member

I found only two can be change dynamically using ALTER SYSTEM
[ISSYS_MOD = IMMEDIATE]

Quote:

select name,issys_modifiable from V$parameter where name IN ( 'db_cache_size','large_pool_size','shared_pool_size','java_pool_size','log_buffer') ;

NAME_______________ISSYS_MOD
----------------------------------------------------------------
shared_pool_size____IMMEDIATE
large_pool_size_____FALSE
java_pool_size______FALSE
db_cache_size______IMMEDIATE
log_buffer__________FALSE

Identify three components of an Oracle instance for which you can change the size
dynamically. (Choose three.)

A. Database Buffer Cache
B. Large Pool
C. Shared Pool
D. Java Pool
E. Redo Log Buffer

Report message to a moderator