数据库的两种初始化参数

SQL查询数据库参数文件类型

最新推荐文章于 2024-07-19 08:58:00 发布

心毅

最新推荐文章于 2024-07-19 08:58:00 发布

阅读量405

点赞数

CC 4.0 BY-SA版权

文章标签：数据库 file archive cache service login

本文链接：https://blog.youkuaiyun.com/guhui2509/article/details/7624839

验证现在数据库使用的参数文件类型.

SQL> select distinct isspecified from v$spparameter;

ISSPEC
------
TRUE
FALSE

SQL> select isspecified,count(*) from v$spparameter group by ISSPECIFIED;

ISSPEC COUNT(*)
------ ----------
TRUE 28
FALSE 233

上述表示28个参数存于二进制参数文件,233个参数为默认值

两类参数文件互相转换:

create pfile from spfile;

create spfile from pfile;

参数文件的优先级

Spfilesid.ora

Spfile.ora

Initsid.ora

SQL> col value for a40
SQL> select name,value from v$spparameter where ISSPECIFIED='TRUE';

processes 150
sga_target 184549376
control_files /u01/app/oracle/oradata/orcl/control01.ctl
control_files /u01/app/oracle/oradata/orcl/control02.ctl
control_files /u01/app/oracle/oradata/orcl/control03.ctl
db_block_size 8192
db_keep_cache_size 4194304
db_recycle_cache_size 4194304
compatible 10.2.0.1.0
log_archive_dest_1 location=/u01/app/oracle/flash_recovery2
_disable_logging FALSE
db_file_multiblock_read_count 16
db_recovery_file_dest /u01/app/oracle/flash_recovery_area
db_recovery_file_dest_size 4294967296
undo_management AUTO
undo_tablespace UNDOTBS1
remote_login_passwordfile EXCLUSIVE
db_domain
dispatchers (PROTOCOL=TCP) (SERVICE=orclXDB)
utl_file_dir /u01/osql/pfile
job_queue_processes 10
background_dump_dest /u01/app/oracle/admin/orcl/bdump
user_dump_dest /u01/app/oracle/admin/orcl/udump
core_dump_dest /u01/app/oracle/admin/orcl/cdump
audit_file_dest /u01/app/oracle/admin/orcl/adump
db_name orcl
open_cursors 500
pga_aggregate_target 10485760