show parameter pfile
Taper <Return> pour la suite
NAME |TYPE |VALUE
------------------------------------|-----------|------------------------------
spfile |string |
sire>>>show parameter sga
Taper <Return> pour la suite
NAME |TYPE |VALUE
------------------------------------|-----------|------------------------------
lock_sga |boolean |FALSE
pre_page_sga |boolean |FALSE
sga_max_size |big integer|232M
sga_target |big integer|0
sire>>>show parameter cache_size
Taper <Return> pour la suite
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_cache_size |big integer|0
db_keep_cache_size |big integer|0
db_recycle_cache_size |big integer|0
sire>>>show parameter pool_size
Taper <Return> pour la suite
NAME |TYPE |VALUE
------------------------------------|-----------|------------------------------
global_context_pool_size |string |
java_pool_size |big integer|4M
large_pool_size |big integer|0
olap_page_pool_size |big integer|0
shared_pool_size |big integer|104M
streams_pool_size |big integer|0
Partager