Home » Other » Training & Certification » Which 3 can be change dynamically
Which 3 can be change dynamically [message #256300] Fri, 03 August 2007 14:22 Go to next message
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
Re: Which 3 can be change dynamically [message #256304 is a reply to message #256300] Fri, 03 August 2007 14:35 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
A, B & C.

Next time specify the version that the question is for.
Re: Which 3 can be change dynamically [message #256425 is a reply to message #256304] Sat, 04 August 2007 12:42 Go to previous messageGo to next message
itguru
Messages: 19
Registered: July 2007
Junior Member
It is for Oracle 9i.

But when try to change large_pool_size size with alter system gives error.

large_pool_size ISSYS_MOD = False
Re: Which 3 can be change dynamically [message #256431 is a reply to message #256425] Sat, 04 August 2007 13:03 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
My guess would be you are querying a 9i R1 database?
Previous Topic: 1Z0-042 Exam
Next Topic: packages
Goto Forum:
  


Current Time: Thu Dec 08 14:44:16 CST 2016

Total time taken to generate the page: 0.10196 seconds