Oracle Study Notes: Create and delete databases-from Oracle10g

■ View the server parameter file used

SQL> show parameter spfile;

■ Use server parameter files to create text parameter files

SQL> Create pfile from spfile;

SQL> Create pfile [= '...'] From spfile [= '...'];

■ create a server parameter file

SQL> Create spfile from pfile = '... ';

the spfile name is not specified. The default value is: spfile $ oracle_sid.ora

or

SQL> Create spfile = '... /new_spfile.ora 'from pfile = '... ';

■ change initialization parameters

scope = spfile only changes the parameters in the server parameter file. effect: for dynamic parameters, this change will be performed at the next Startup

it takes effect and remains unchanged. For static parameters, the effect is the same as that for dynamic parameters. Only the scope clause with this change uses

static parameters

scope = memory: Only parameters in the memory are changed. effect: for dynamic parameters, this change takes effect immediately, but is not updated

server parameter files, so changes cannot be permanently retained. Static Parameters cannot be changed like this

scope = both: both the parameters in the server parameter file and the parameters in the memory are changed. effect: for dynamic parameters, the

changes take effect immediately and are permanently retained; static Parameters cannot be changed like this

If the server does not use the server parameter file, an error occurs when scope = spfile or scope = both is specified.

If you use the server parameter file to start the routine, the default value is scope = both. If you use the traditional text to initialize the parameter file startup routine,

The default value is scope = memory.

For dynamic parameters, you can specify the deferred keyword. If this keyword is specified, the change will only affect future sessions.

■ Change the maximum number of worker queue processes allowed by the instance, specify a comment, and change it in memory.

SQL> alter system set job_queue_processes = 50

Comment = 'temporary change on 2006.12.05'

Scope = memory;

■ view initialization parameters

show parameters

SQL> show parameters db_recovery_file_dest;

■ V $ parameter this view displays the currently used parameter values

SQL> select name, value from V $ Parameter

Where name = 'db _ recovery_file_dest ';

■ V $ spparameter this view displays the current content of the server parameter file. If the instance does not use the server parameter file, this view will return

NULL (null) value.

SQL> select name, value from V $ spparameter

Where name = 'db _ recovery_file_dest ';