Discussion :

[parko26]

Bonjour mes amis
la question est :
Le parametre LARGE_POOL_SIZE est de 50Mo.Vous executez ALTER SYSTEM SET LARGE_POOL_SIZE=100M.Puis vous arretez et redemarrez la base de données .Quel est la taille de LARGE_POOL?
a-50MB
b-100MB
c-La valeur par defaut LARGE_POOL_SIZEi
d-Le LARGE_POOL_SIZE comme vous l'avez défini dans le fichier d'initialisation
mois je choisi la reponse d ;est ce que c'est exact .car si on arrete la base de données et o on redemarer serveur oracle lire les valeurs de fichier d'init et allouer le SGA.merci d'avance

[FSiebert]

Bonjour,

C'est vrai si vous utilisez un PFILE, faux si vous utilisez un SPFILE.

Voir la notion de SCOPE :

SCOPE The SCOPE clause lets you specify when the change takes effect. Scope depends on whether you started up the database using a traditional plain-text parameter file (pfile) or server parameter file (spfile).

MEMORY indicates that the change is made in memory, takes effect immediately, and persists until the database is shut down. If you started up the database using a parameter file (pfile), then this is the only scope you can specify.

SPFILE indicates that the change is made in the server parameter file. The new setting takes effect when the database is next shut down and started up again. You must specify SPFILE when changing the value of a static parameter that is described as not modifiable in Oracle Database Reference.

BOTH indicates that the change is made in memory and in the server parameter file. The new setting takes effect immediately and persists after the database is shut down and started up again.

If a server parameter file was used to start up the database, then BOTH is the default. If a parameter file was used to start up the database, then MEMORY is the default, as well as the only scope you can specify.