v$parameter values [message #57742] |
Wed, 02 July 2003 23:14 |
Elavarasan
Messages: 7 Registered: January 2002
|
Junior Member |
|
|
Hi all,
We have the following values ZERO in our v$parameter (actualy in the init.ora). Event DB_BLOCK_BUFFERS is also 0. Will it have any impact in the performance. What are the changes required in these values?
aq_tm_processes
archive_lag_target
db_16k_cache_size
db_2k_cache_size
db_32k_cache_size
db_4k_cache_size
db_8k_cache_size
db_block_buffers
db_keep_cache_size
db_recycle_cache_size
dbwr_io_slaves
fast_start_io_target
hi_shared_memory_address
hpux_sched_noage
instance_number
java_max_sessionspace_size
java_soft_sessionspace_limit
job_queue_processes
license_max_sessions
license_max_users
license_sessions_warning
log_archive_trace
log_checkpoint_interval
optimizer_index_caching
parallel_min_percent
parallel_min_servers
plsql_native_library_subdir_count
recovery_parallelism
session_cached_cursors
shared_memory_address
sort_area_retained_size
thread
timed_os_statistics
Our Oracle server is currently very slow. Need your help on this.
Regards
Elavarasan
|
|
|