参数查询参数查询复制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.