查看基本参数

5dm

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.