Oracle参数查询命令Oracle参数查询命令show parameter的小技巧
参数查询参数查询复制SQL> show parameter db_; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_16k_cache_size big integer 0 db_2k_cache_size big integer 0 db_32k_cache_size big integer 0 db_4k_cache_size big integer 0 db_8k_cache_size big integer 0 db_block_buffers integer 0 db_block_checking string FALSE db_block_checksum string TRUE db_block_size integer 8192 db_cache_advice string ON db_cache_size big integer 0 NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_create_file_dest string db_create_online_log_dest_1 string db_create_online_log_dest_2 string db_create_online_log_dest_3 string db_create_online_log_dest_4 string db_create_online_log_dest_5 string db_domain string db_file_multiblock_read_count integer 8 db_file_name_convert string db_files integer 200 db_flashback_retention_target integer 1440 NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_keep_cache_size big integer 0 db_name string Ora813 db_recovery_file_dest string d:\oracle\product\10.2.0/flash _recovery_area db_recovery_file_dest_size big integer 2G db_recycle_cache_size big integer 0 db_unique_name string Ora813 db_writer_processes integer 1 dbwr_io_slaves integer 0 rdbms_server_dn string standby_archive_dest string %ORACLE_HOME%\RDBMS NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ standby_file_management string MANUAL SQL> spool off; 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.46.47.48.
本文地址：http://www.bzve.cn/html/369d8199549.html
版权声明
本文仅代表作者观点，不代表本站立场。
本文系作者授权发表，未经许可，不得转载。