oracle 所有引數資訊x$ksppi

polestar123發表於2009-07-14

select ksppinm,ksppdesc from x$ksppi where ksppinm like 'db%'

結果如下

1 dbwr_io_slaves DBWR I/O slaves
2 db_file_name_convert datafile name convert patterns and strings for standby/clone db
3 db_block_buffers Number of database blocks cached in memory
4 db_block_checksum store checksum in db blocks and check during reads
5 db_block_size Size of database block in bytes
6 db_cache_size Size of DEFAULT buffer pool for standard block size buffers
7 db_2k_cache_size Size of cache for 2K buffers
8 db_4k_cache_size Size of cache for 4K buffers
9 db_8k_cache_size Size of cache for 8K buffers
10 db_16k_cache_size Size of cache for 16K buffers
11 db_32k_cache_size Size of cache for 32K buffers
12 db_keep_cache_size Size of KEEP buffer pool for standard block size buffers
13 db_recycle_cache_size Size of RECYCLE buffer pool for standard block size buffers
14 db_writer_processes number of background database writer processes to start
15 db_cache_advice Buffer cache sizing advisory
16 db_files max allowable # db files
17 db_file_multiblock_read_count db block to be read each IO
18 db_create_file_dest default database location
19 db_create_online_log_dest_1 online log/controlfile destination #1
20 db_create_online_log_dest_2 online log/controlfile destination #2
21 db_create_online_log_dest_3 online log/controlfile destination #3
22 db_create_online_log_dest_4 online log/controlfile destination #4
23 db_create_online_log_dest_5 online log/controlfile destination #5
24 db_recovery_file_dest default database recovery file location
25 db_recovery_file_dest_size database recovery files size limit
26 db_flashback_retention_target Maximum Flashback Database log retention time in minutes.
27 db_block_checking header checking and data and index block checking
28 db_domain directory part of global database name stored with CREATE DATABASE
29 db_name database name specified in CREATE DATABASE
30 db_unique_name Database Unique Name[@more@]

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/70612/viewspace-1024126/,如需轉載,請註明出處,否則將追究法律責任。

相關文章