Oracle:基本的初始化参数
基本的初始化参数的获得:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 |
SQL> set linesize 900 SQL> col name for a28 SQL> col value for a40 SQL> run 1* select name,type,value from v$parameter where isbasic='TRUE' NAME TYPE VALUE ---------------------------- ---------- ---------------------------------------- processes 3 150 sessions 3 247 nls_language 2 AMERICAN nls_territory 2 AMERICA sga_target 6 0 control_files 2 /u01/app/oracle/oradata/orcl/control01.c tl, /u01/app/oracle/fast_recovery_area/o rcl/control02.ctl db_block_size 3 8192 compatible 2 11.2.0.0.0 log_archive_dest_1 2 log_archive_dest_2 2 log_archive_dest_state_1 2 enable log_archive_dest_state_2 2 enable cluster_database 1 FALSE db_create_file_dest 2 db_create_online_log_dest_1 2 db_create_online_log_dest_2 2 db_recovery_file_dest 2 /u01/app/oracle/fast_recovery_area db_recovery_file_dest_size 6 4322230272 undo_tablespace 2 UNDOTBS1 instance_number 3 0 ldap_directory_sysauth 2 no remote_login_passwordfile 2 EXCLUSIVE db_domain 2 shared_servers 3 1 remote_listener 2 db_name 2 orcl db_unique_name 2 orcl open_cursors 3 300 star_transformation_enabled 2 FALSE pga_aggregate_target 6 0 30 rows selected. SQL> |
——————————————
Done。