Setting of which parameter can affect the performance of the database?

Options
- Initialization parameter
- SGA parameter
- Memory parameter
- Both a and b

CORRECT ANSWER : Memory parameter

Discussion Board
Memory Parameters

The settings of memory parameters can affect the performance of your database. When you install your database, these parameters are tuned to meet the requirements of the environment that you specify. Memory parameters are initialization parameters that determine the total size of the system global area (SGA) and the program global area (PGA), and of the subcomponents of the SGA.

Prajakta Pandit 02-14-2017 12:43 AM

Initialization Parameter

It is initilization parameter , memory is one of them

CHANDRA 04-25-2016 04:31 PM

At my opinion correct answer is Initialization parameter

Changing a list of initialization parameters (memory parameter just one of them) can cause performance problems. OPTIMIZER_MODE is one of examples. LOG_BUFFER, SORT_AREA_SIZE ... and many others.

Maksim 01-3-2014 05:28 AM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Related Content

Advertisement
 
▲