设置数据库初始化参数

 

 

SQL> 
SQL> col name for a36
SQL> col value for a20
SQL> select name,value from v$parameter where isbasic='TRUE' order by name;
 
NAME                                 VALUE
------------------------------------ --------------------
cluster_database                     TRUE
compatible                           11.2.0.4.0
control_files                        +DATA_DB/orcl/contro
                                     lfile/current.256.89
                                     2839137
 
db_block_size                        8192
db_create_file_dest                  +DATA_DB
db_create_online_log_dest_1          
db_create_online_log_dest_2          
db_domain                            
db_name                              orcl
db_recovery_file_dest                
db_recovery_file_dest_size           0
db_unique_name                       orcl
instance_number                      2
ldap_directory_sysauth               no
log_archive_dest_1                   
log_archive_dest_2                   
log_archive_dest_state_1             enable
log_archive_dest_state_2             enable
nls_language                         AMERICAN
nls_territory                        AMERICA
 
NAME                                 VALUE
------------------------------------ --------------------
open_cursors                         300
pga_aggregate_target                 0
processes                            150
remote_listener                      scanip:1521
remote_login_passwordfile            EXCLUSIVE
sessions                             247
sga_target                           0
shared_servers                       0
star_transformation_enabled          FALSE
undo_tablespace                      UNDOTBS2
 
30 rows selected