Topic: Database Administration >> Static paramters of SGA
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| Title: Static paramters of SGA |
| rsreddy28 |
Posted: May 14, 2007 11:00:06 AM |
Total Post: 36
Joined: Mar, 2007
|
Hello ,
Can somebody tell me what are the static and dynamic paramters of SGA .
I told abt the dynamic parameters of SGA but I could not tell abt Static parameters.
I browsed but i could'nt find the exact answer for that.
And what is the diff between TKPROF and Explain Plan .
I was asked these questions in an interview.
Help me out guys plz .
bYe,
Raja
|
|
|
 Ratnaker |
| Posted: May 16, 2007 10:13:09 AM |  |
|
Total Post: 141
Joined: Apr, 2007
|
hi,
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
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 857 |
| Mohammed Taj | 746 |
| positive fanatic | 483 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 386 |
| Gopu Gopi | 333 |
| Gitesh Trivedi | 322 |
| Vinoth Kumar | 264 |
| neeraj sharma | 258 |
| Ramesh Jois | 246 |
|
|
