| sudheer pai |
Posted: Jun 27, 2007 12:05:11 AM |
Total Post: 33
Joined: Feb, 2007
|
| how do i find out which parameter is dynamic and which parameter is static |
|
|
 Ratnaker |
| Posted: Jun 27, 2007 03:05:36 AM |  |
|
Total Post: 138
Joined: Apr, 2007
|
Hi Sudheer,
i posted answer about this question at 16 may 2007.
Static parameters are :
lock_name_space
processes
sessions
instance_groups
event
sga_max_size
pre_page_sga
shared_memory_address
hi_shared_memory_address
use_indirect_data_buffers
lock_sga
shared_pool_reserved_size
java_soft_sessionspace_limit
java_max_sessionspace_size
spfile
instance_type
enqueue_resources
fileio_network_adapters
disk_asynch_io
tape_asynch_io
dbwr_io_slaves
cluster_interconnects
gcs_server_processes
active_instance_count
control_files
log_file_name_convert
db_block_buffers
db_block_size
db_writer_processes
buffer_pool_keep
buffer_pool_recycle
max_commit_propagation_delay
compatible
remote_archive_enable
log_archive_start
log_archive_format
log_buffer
db_files
read_only_open_delayed
cluster_database
parallel_server
parallel_server_instances
cluster_database_instances
gc_files_to_locks
thread
recovery_parallelism
logmnr_max_persistent_sessions
dml_locks
replication_dependency_tracking
instance_number
transactions
transactions_per_rollback_segment
rollback_segments
undo_management
os_roles
rdbms_server_dn
max_enabled_roles
remote_os_authent
remote_os_roles
O7_DICTIONARY_ACCESSIBILITY
remote_login_passwordfile
audit_sys_operations
global_context_pool_size
db_domain
distributed_lock_timeout
commit_point_strength
instance_name
serial_reuse
cursor_space_for_time
utl_file_dir
smtp_out_server
create_bitmap_area_size
bitmap_merge_area_size
parallel_execution_message_size
shadow_core_dump
background_core_dump
session_max_open_files
open_links
open_links_per_instance
audit_trail
db_name
sp_name
db_unique_name
ifile
os_authent_prefix
sql92_security
blank_trimming
all this above parameter is static.rest of the prameter is dynamic
Ratnaker
|
|
|
|
|
| |
| Posted: Jun 27, 2007 05:47:03 AM | |
|
Total Post: 15
Joined: Dec, 2006
|
if the value of ISSES_MODIFIABLE & ISSYS_MODIFIABLE are false in v$parameter then that parameter is static.
|
|
|
|
|
| Navi |
| Posted: Jun 27, 2007 08:49:42 AM | |
|
Total Post: 60
Joined: Jun, 2007
|
Static Parameters :- All static parameters start with USER_tablename, ALL_tablename, DBA_tablename.
Dynamic Parameters :- All Dynamic Parameters start with V$tablename.
|
|
|
|
|
| Navi |
| Posted: Jun 27, 2007 08:58:22 AM | |
|
Total Post: 60
Joined: Jun, 2007
|
hi,
Sorry i have answered it wrong. This is the right answer:-
if the value of ISSES_MODIFIABLE & ISSYS_MODIFIABLE are false in v$parameter then that parameter is static.
The answer that i have mentioned is how can we differentiate
static views and dynamic views.
Regards,
Naveen
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
