Oracle programming Art Study Notes (1)

1. sid: site identifie)
2. spfile: Server parameter file, which stores parameter files
3. query the current value of the database parameter (see the Oracle database reference manual ):
Select value from v $ parameter where name = 'pga _ aggregate_target'
Or

Show parameter pga_agg (Fuzzy Matching supported)

For example:

SQL> show parameter memory; </p> <p> name type value <br/> bytes ----------- bytes <br/> hi_shared_memory_address integer 0 <br/> memory_max_target big integer 600 M <br/> memory_target big integer 600 M <br/> shared_memory_address integer 0 <br/> SQL> show parameter sga; </p> <p> name type value <br/> certificate ----------- ------------------------------ <br/> lock_sga boolean FALSE <br/> pre_page_sga boolean FALSE <br/> sga_max_size big integer 460 M <br/> sga_target big integer 300 M <br/> SQL> show parameter pga; </p> <p> name type value <br/> ------------------------------------ <br/> pga_aggregate_target big integer 200 M <br/> SQL>

4. Modify the initial parameter file (static parameter file). manually modify the file and restart the service.
Modify the spfile parameter: alter system set pga_aggregate_target = 1g
5. default position of the pfile file:
$ Oracle_home/dbs (unix System)
% Oracle_home % \ database (windows)

6. How to check whether the SPFILE or PFILE parameter is enabled in oracle?
The Startup command of Oracle is opened with spfile by default.

SVRMGR> show parameter pfile;
NAME TYPE VALUE
------------------------------------------------------------------------
Spfile string % ORACLE_HOME % \ DATABASE \ SPFILE %

It is started with 'spfile '.