How Oracle queries initialization parameters (vi) Description of Create Pfile method check at the beginning

Query initialization parameters A lot of ways, such as show PARAMETER, or query V$parameter, here a brief summary.

This article describes the Create Pfile method to check initialization parameters.

There are a number of methods that are used to query initialization parameters in a database. In fact, there is a more obvious way, is the way to create Pfile:

Sql> Show Parameter SPFile

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

SPFile string +data/test/spfiletest.ora

sql> Create pfile = '/export/home/oracle/inittest1.ora ' from SPFile;

The file has been created.

Sql> Host More/export/home/oracle/inittest1.ora

test2.__db_cache_size=541065216

test1.__db_cache_size=524288000

test2.__java_pool_size=4194304

test1.__java_pool_size=4194304

test2.__large_pool_size=4194304

test1.__large_pool_size=4194304

Test1.__oracle_base= '/data/oracle ' #ORACLE_BASE set from environment

Test2.__oracle_base= '/data/oracle ' #ORACLE_BASE set from environment

test2.__pga_aggregate_target=260046848

test1.__pga_aggregate_target=260046848

test2.__sga_target=775946240

test1.__sga_target=775946240

Test2.__shared_io_pool_size=0

Test1.__shared_io_pool_size=0

test2.__shared_pool_size=218103808

test1.__shared_pool_size=234881024

Test2.__streams_pool_size=0

Test1.__streams_pool_size=0

*.audit_file_dest= '/data/oracle/admin/test/adump '

*.audit_trail= ' DB '

*.cluster_database=true

*.cluster_database_instances=3

*.compatible= ' 11.1.0.0.0 '

*.control_files= ' +data/test/controlfile/current.529.684067899 '

*.db_block_size=8192

*.db_create_file_dest= ' +data '

*.db_domain= '

*.db_name= ' Test '

*.diagnostic_dest= '/data/oracle '

Test1.instance_number=1

test2.instance_number=2

*.log_archive_config= '

*.log_archive_dest_1= ' Location=/data/oracle/oradata/test/archivelog '

*.open_cursors=300

test1.open_cursors=500

test2.open_cursors=700

*.pga_aggregate_target=256901120

*.processes=150

*.remote_login_passwordfile= ' EXCLUSIVE '

Test1.remote_login_passwordfile= ' SHARED '

*.sga_target=772800512

Test1.thread=1

test2.thread=2

*.undo_tablespace= ' UNDOTBS1 '

Test2.undo_tablespace= ' UNDOTBS2 '

With this statement, all the initialization parameters set in the SPFile are at a glance.

In addition to the create PFILE from SPFile, the 11g also adds the Create PFILE from memory option, allowing users to generate PFILE files directly from the parameters currently in effect in the database, using this method, You can resolve the situation where the instance-level parameters that are set in the Pfile in the last article are covered in the SPFile database-level parameters:

sql> Create pfile = '/export/home/oracle/inittest1.ora ' from memory;

The file has been created.

Sql> Host More/export/home/oracle/inittest1.ora

# Oracle Init.ora parameter file generated by instance test1 on 06/12/2009 15:18:46

test1.__db_cache_size=500m

test2.__db_cache_size=516m

This article URL address: http://www.bianceng.cn/database/Oracle/201410/45548.htm