79989

79989



To predict the percentage of reads saved for difTerent databa.se cache sizes:

1.    In EM Express, from the Configu ratfon menu, select Memory.

The Memory Management page appears. In the Memory Settings section, the Management Modę value is Manuał in the SGA Memory subsection.This indicates that Manuał Shared Memory Management is enabled for the database.

2.    Use the Buffer Cache Advisor graph (which appears to the right of the Memory Settings section) to predict the percentage of reads saved for potential database cache sizes.

In the Buffer Cache Advisor graph:

■Potential values for the DB_CACHE_SIZE initialization parameter (in MB) are represented on the horizontal axis of the graph. The current setting of the DB_ CACHE_SI ZE initialization parameter is indicated by a blue dot.

■The corrcsponding values of reads saved are represented on the vcrtical axis of the graph. The plotted values are expressed as a percentage relative to the currcnt setting of the DB_CACHE_SIZE initialization parameter.

Negative values represent the percentage of an increase in reads (when the mcmory allottcd to Oracle is smallcr than the current setting). whilc positivc valucs represent the percentage of dccrcasc in reads (when the mcmory alloted to Oracle is larger than the current setting.

An orange linę on the graph plots different values that can be specified for the DB_ CACHE_SIZE initialization parameter. Click any dot on the orange linę to see a prediction of the percentage of reads saved for the DB_CACHE_SIZE value represented by that dot.

In this figurę, the Buffer Cache Advisor graph indicates that inereasing the current value of the DB_CACHE_SIZE initialization parameter will not increase the percentage of reads savcd.

3.    To change the value of the DB_CACHE_SIZE initialization parameter:

a.    Click Configure Memory on the Mcmory Management page.

The Initialization Parameter page appears.

b.    Select the DB_CACHE_SIZE initialization parameter and click Set.

The Set Initialization Parameter page appears.



Wyszukiwarka

Podobne podstrony:
We use this formula to fine the number of cells reąuired for Stavanger and Sandnes „ „   &
don of metnyl bromide gas on to lucerne seed infcsted witb Dirylenchus dipsaci to predict the l
(22) When an agreed paediatric investigation plan has led to the authorisation of a paediatric
9.    Battersby N.S., Morgan P.: A notę on the use of the CEC L-33A-93 test to p
C. To determine the importance of the detailed geomorphological map for the development of geomorpho
iThe manner of easing the lockdown has been gradual for all EU5 nations to minimise the risk of seco
Physics.in Canada/10 auchorlzed to perform the duties of the Office for which he is so elected for t
htdctmw 134 Weil, that wraps it up for now, gang. Naturally, we’ve only been able to scratch the sur
Creative Doughcraft5 5Three ducks out for a walk These ducks are charmirtg, cheerfui and easy
That is in formal words, but for your information the effect is to introduce the Office of past pres
David Drake and Bill?wcett The Fleet Crisis 3 PLEDGED TO PROTECT US ALL. The fortunes of war ma
57521 w25S LEPT A wooden scaffold designed for infantry to allow them to reach the top of a&nbs
44 M. SIKORSKI ABSTRACT The aim of this paper is to review the most widely used techniąue for studie

więcej podobnych podstron