Which initialization parameter is a dynamic parameter that lets you specify or adjust the size of the large pool component of the SGA?

Which initialization parameter is a dynamic parameter that lets you sp

1.	Which initialization parameter is a dynamic parameter that lets you specify or adjust the size of the large pool component of the SGA?
A.	STREAMS_POOL_SIZE
B.	JAVA_POOL_SIZE
C.	LARGE_POOL_SIZE
D.	SHARED_POOL_SIZE
Answer» D. SHARED_POOL_SIZE

Discussion

No Comment Found

Related MCQs

In defining Application Services for Oracle Database 10g which Services describe applications, application functions, and data ranges as either functional services or data-dependent services?
In viewing information about the SGA which view Displays information about the amount of SGA memory available for future dynamic SGA resize operations?
Which is the correct parameter used for CREATE_PROGRAM?
What is used to execute STARTUP and SHUTDOWN commands while starting up a database?
Which attribute enables you to control the amount of logging in the Scheduler performs for setting the scheduler attribute?
In the platform-specific default location, Oracle Database locates your initialization parameter file by examining filenames in which of the following order?
What kind of an eventis raised when the Scheduler reacts to the event by starting a job and you can even create a schedule that references an event instead of containing date, time, and recurrence information?
Based on the existing program which way is used to CREATE_JOB?BEGINDBMS_SCHEDULER.CREATE_JOB (job_name => 'my_new_job3',program_name => 'my_saved_program1',schedule_name => 'my_saved_schedule1');END;
When a job is picked for processing, select the correct order in which job executes.1. Starts a database session as the owner of the job, starts a transaction, and then starts executing the job.2. Gathers all the metadata needed to run the job. As an example, arguments of the program and privilege information.3. Once the job is complete, the slave commits and ends the transaction.4. Closes the session
Which is the location of the Oracle Database that can store and manage files related to backup and recovery?

Which initialization parameter is a dynamic parameter that lets you specify or adjust the size of the large pool component of the SGA?

Discussion

No Comment Found

Related MCQs

Reply to Comment