Home » RDBMS Server » Server Administration » Oracle configuration (Oracle 11g)
Oracle configuration [message #603880] Fri, 20 December 2013 03:11 Go to next message
oracle_doubt
Messages: 96
Registered: December 2012
Location: CHENNAI
Member
Hi all,
Please provide recommended parameter values for this attached parameters sheet.

[Updated on: Fri, 20 December 2013 03:20]

Report message to a moderator

Re: Oracle configuration [message #603884 is a reply to message #603880] Fri, 20 December 2013 03:26 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Not that I could help you, but - people don't want to download files from an unknown source. Why wouldn't you simply post that information within your message? If it is a long one, use [spoiler] tags to cut it short (visually).
Re: Oracle configuration [message #603889 is a reply to message #603884] Fri, 20 December 2013 03:33 Go to previous messageGo to next message
oracle_doubt
Messages: 96
Registered: December 2012
Location: CHENNAI
Member
Please provide recommended values:
Name
aq_tm_processes
archive_lag_target
audit_file_dest
audit_sys_operations
audit_syslog_level
audit_trail
background_core_dump
background_dump_dest
bitmap_merge_area_size
blank_trimming
buffer_pool_keep
buffer_pool_recycle
circuits
client_result_cache_lag
client_result_cache_size
commit_logging
commit_point_strength
commit_wait
commit_write
compatible
control_file_record_keep_time
control_files
control_management_pack_access
core_dump_dest
cpu_count
create_bitmap_area_size
create_stored_outlines
cursor_bind_capture_destination
cursor_sharing
cursor_space_for_time
db_16k_cache_size
db_2k_cache_size
db_32k_cache_size
db_4k_cache_size
db_8k_cache_size
db_block_buffers
db_block_checking
db_block_checksum
db_block_size
db_cache_advice
db_cache_size
db_create_file_dest
db_create_online_log_dest_1
db_create_online_log_dest_2
db_create_online_log_dest_3
db_create_online_log_dest_4
db_create_online_log_dest_5
db_domain
db_file_multiblock_read_count
db_file_name_convert
db_files
db_flashback_retention_target
db_keep_cache_size
db_lost_write_protect
db_name
db_recovery_file_dest
db_recovery_file_dest_size
db_recycle_cache_size
db_securefile
db_ultra_safe
db_unique_name
db_unrecoverable_scn_tracking
db_writer_processes
dbwr_io_slaves
ddl_lock_timeout
deferred_segment_creation
dg_broker_config_file1
dg_broker_config_file2
dg_broker_start
diagnostic_dest
disk_asynch_io
dispatchers
distributed_lock_timeout
dml_locks
dst_upgrade_insert_conv
enable_ddl_logging
event
fal_client
fal_server
fast_start_mttr_target
fast_start_parallel_rollback
filesystemio_options
fixed_date
global_context_pool_size
global_names
hs_autoregister
ifile
instance_name
java_jit_enabled
java_max_sessionspace_size
java_pool_size
java_soft_sessionspace_limit
job_queue_processes
large_pool_size
ldap_directory_access
ldap_directory_sysauth
license_max_sessions
license_max_users
license_sessions_warning
listener_networks
local_listener
lock_name_space
lock_sga
log_archive_config
log_archive_dest
log_archive_dest_1
log_archive_dest_state_1
log_archive_format
log_archive_local_first
log_archive_max_processes
log_archive_min_succeed_dest
log_archive_trace
log_buffer
log_checkpoint_interval
log_checkpoint_timeout
log_checkpoints_to_alert
log_file_name_convert
max_dispatchers
max_dump_file_size
max_enabled_roles
max_shared_servers
memory_max_target
memory_target
nls_length_semantics
nls_nchar_conv_excp
o7_dictionary_accessibility
object_cache_max_size_percent
object_cache_optimal_size
olap_page_pool_size
open_cursors
open_links
open_links_per_instance
optimizer_capture_sql_plan_baselines
optimizer_dynamic_sampling
optimizer_features_enable
optimizer_index_caching
optimizer_index_cost_adj
optimizer_mode
optimizer_secure_view_merging
optimizer_use_invisible_indexes
optimizer_use_pending_statistics
optimizer_use_sql_plan_baselines
os_authent_prefix
os_roles
parallel_adaptive_multi_user
parallel_automatic_tuning
parallel_degree_limit
parallel_degree_policy
parallel_execution_message_size
parallel_max_servers
parallel_min_servers
parallel_min_time_threshold
parallel_servers_target
parallel_threads_per_cpu
permit_92_wrap_format
pga_aggregate_target
plscope_settings
plsql_ccflags
plsql_code_type
plsql_debug
plsql_optimize_level
plsql_v2_compatibility
plsql_warnings
processes
query_rewrite_enabled
query_rewrite_integrity
rdbms_server_dn
read_only_open_delayed
recovery_parallelism
recyclebin
redo_transport_user
remote_dependencies_mode
remote_listener
remote_login_passwordfile
remote_os_authent
remote_os_roles
replication_dependency_tracking
resource_limit
resource_manager_cpu_allocation
resource_manager_plan
result_cache_max_result
result_cache_max_size
result_cache_mode
result_cache_remote_expiration
resumable_timeout
rollback_segments
sec_case_sensitive_logon
sec_max_failed_login_attempts
sec_protocol_error_further_action
sec_protocol_error_trace_action
sec_return_server_release_banner
serial_reuse
service_names
session_max_open_files
sessions
sga_max_size
sga_target
shadow_core_dump
shared_memory_address
shared_pool_reserved_size
shared_pool_size
shared_server_sessions
shared_servers
skip_unusable_indexes
smtp_out_server
sort_area_retained_size
sort_area_size
spfile
sql92_security
sql_trace
sqltune_category
standby_archive_dest
standby_file_management
star_transformation_enabled
statistics_level
streams_pool_size
thread
timed_os_statistics
timed_statistics
trace_enabled
transactions
transactions_per_rollback_segment
undo_management
undo_retention
undo_tablespace
use_indirect_data_buffers
use_large_pages
user_dump_dest
utl_file_dir
workarea_size_policy
xml_db_events
Re: Oracle configuration [message #603890 is a reply to message #603889] Fri, 20 December 2013 03:36 Go to previous messageGo to next message
Roachcoach
Messages: 1576
Registered: May 2010
Location: UK
Senior Member
I'm sorry, but it is needed

http://i1035.photobucket.com/albums/a438/pics56/messages/793861297-ImpliedFacepalm.jpg
Re: Oracle configuration [message #603894 is a reply to message #603889] Fri, 20 December 2013 03:41 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

42 for all of them.

Re: Oracle configuration [message #603917 is a reply to message #603880] Fri, 20 December 2013 05:30 Go to previous messageGo to next message
gazzag
Messages: 1118
Registered: November 2010
Location: Bedwas, UK
Senior Member
If there were "recommended" values, why would Oracle provide parameters and not just hard-code everything?

@Roachcoach Nice implied facepalm Very Happy
Re: Oracle configuration [message #603922 is a reply to message #603880] Fri, 20 December 2013 06:31 Go to previous messageGo to next message
martijn
Messages: 286
Registered: December 2006
Location: Netherlands
Senior Member
Dear Siraj,

I have the distinct feeling, something is going wrong here.
I see you allready have about 95 posts to this forum. I would like to think that you by now should know what information to supply to get some answers.
Some things that are often asked (for various types of questions):
- RDBMS version
- OS
- explain plans
- DML DDL
- Actual queries
- Expected load
- number of users
-...
-...
- What did you try yourself?
- Docmentation references

In your post you however gave us a whole lot of parameters.
That's it, A whole lot of parameters.

Why do you think we, well let me speak for myself, I, will give serious answers.?

Once again, we're just a bunch of volunteers, we are not paid to do someone else's work.
Re: Oracle configuration [message #604012 is a reply to message #603922] Sun, 22 December 2013 22:41 Go to previous messageGo to next message
oracle_doubt
Messages: 96
Registered: December 2012
Location: CHENNAI
Member
Hi gazzag,
Recommended values means what you recommend for those parameters..Ok..If you want post it otherwise...
Hi martijn,
Thanks for your advice..
Re: Oracle configuration [message #604013 is a reply to message #604012] Sun, 22 December 2013 22:45 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Please provide recommended values:
It depends

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/
Re: Oracle configuration [message #604015 is a reply to message #604012] Sun, 22 December 2013 22:53 Go to previous messageGo to next message
oracle_doubt
Messages: 96
Registered: December 2012
Location: CHENNAI
Member
You are right.I am posting all parameters here.I just want default values for some parameter which can hold a default value.
Anyways i found somewhere.Now no need..

I am not asking server related values,i know without knowing about server we cant able to configure..

[Updated on: Sat, 08 March 2014 13:29] by Moderator

Report message to a moderator

Re: Oracle configuration [message #604016 is a reply to message #604015] Sun, 22 December 2013 22:56 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>I just want default values for some parameter which can hold a default value.
default parameter values are Oracle version dependent
Re: Oracle configuration [message #604235 is a reply to message #604015] Thu, 26 December 2013 08:37 Go to previous message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
siraj.accet wrote on Mon, 23 December 2013 04:53
You are right.I am posting all parameters here.I just want default values for some parameter which can hold a default value.


Default values for all that can have them can be found in the documentation.

[Updated on: Sat, 08 March 2014 13:29] by Moderator

Report message to a moderator

Previous Topic: tablespace monitoring script - used% should show 100%
Next Topic: query to identify the Oracle Home
Goto Forum:
  


Current Time: Thu Mar 28 09:35:02 CDT 2024