设置数据库初始化参数
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