SQL> select name,value from v$parameter where isbasic='TRUE' order by name;
NAME
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
cluster_database
FALSE
compatible
11.2.0.0.0
control_files
+FRA/sztech1/controlfile/current.261.798486437, +FRA/sztech1/controlfile/current
.260.798486437
NAME
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
db_block_size
8192
db_create_file_dest
+FRA
db_create_online_log_dest_1
NAME
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
db_create_online_log_dest_2
db_domain
db_name
sztech1
NAME
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
db_recovery_file_dest
+FRA
db_recovery_file_dest_size
4322230272
db_unique_name
sztech1
NAME
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
instance_number
0
ldap_directory_sysauth
no
log_archive_dest_1
NAME
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
log_archive_dest_2
log_archive_dest_state_1
enable
log_archive_dest_state_2
enable
NAME
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
nls_language
AMERICAN
nls_territory
AMERICA
open_cursors
300
NAME
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
pga_aggregate_target
0
processes
150
remote_listener
NAME
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
remote_login_passwordfile
EXCLUSIVE
sessions
248
sga_target
0
NAME
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
shared_servers
1
star_transformation_enabled
FALSE
undo_tablespace
UNDOTBS1
NAME
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
30 rows selected.
| 欢迎光临 重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛 (http://bbs.cqsztech.com/) | Powered by Discuz! X3.2 |