Topic: Performance & Tuning >> After Upgrade 9.2.0.6 to 10.2.0.1 Slow thru-put and response times
|
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: After Upgrade 9.2.0.6 to 10.2.0.1 Slow thru-put and response times |
| Ty |
Posted: Mar 29, 2007 03:25:04 PM |
Total Post: 1
Joined: Mar, 2007
|
Good Day to all,
After upgrade of 9.2.0.6 to 10.2.0.1 on AIX 64bit, We are experiencing long running sql statements. Most of OLTP is fine, Any sql reading 1M+ rows have turned for the worse. These still runs very fast on 9.2.0.6 environment. Need suggestions from ALL:
Some of the INIT.ora parameters are:
open_cursors = 300
db_file_multiblock_read_count = 32 # LARGE
#db_cache_size = 60000
shared_pool_size = 300M # INITIAL
large_pool_size = 150M
java_pool_size = 100M
log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
processes = 500 # INITIAL
log_buffer = 163840 # INITIAL
# audit_trail = false # if you want auditing
timed_statistics = true # if you want timed statistics
# max_dump_file_size = 10000 # limit trace file size to 5M each
# Uncommenting the lines below will cause automatic archiving if archiving has
# been enabled using ALTER DATABASE ARCHIVELOG.
#log_archive_start = true
#rollback_segments = ( R01, R02, R03, R04, RBSBIG )
rollback_segments = ( R07, R08, R09, R10, R11, R12 )
# If using public rollback segments, define how many
# rollback segments each instance will pick up, using the formula
# # of rollback segments = transactions / transactions_per_rollback_segment
# In this example each instance will grab 40/10 = 4:
# transactions = 40
# transactions_per_rollback_segment = 10
# Global Naming -- enforce that a dblink has same name as the db it connects to
# global_names = false
db_block_size = 8192
os_authent_prefix = ""
# The following parameters are needed for the Advanced Replication Option
#job_queue_processes = 0
#job_queue_processes = 4
#job_queue_interval = 60
#distributed_transactions = 10
open_links = 4
compatible = "10.2.0"
#sort_area_size = 1024000
#sort_area_retained_size = 1024000
#hash_multiblock_io_count = 2
#_SYSTEM_TRIG_ENABLED = FALSE
##### TA ######
OPTIMIZER_MODE = FIRST_ROWS_10
#_unnest_subquery = false
#_complex_view_merging = false
#filesystemio_options = setall
#new for 10g
PGA_AGGREGATE_TARGET = 300M
#session_max_open_files = 20
#AQ_TM_PROCESSES=0
#_optimizer_cost_based_transformation=off
#_gby_hash_aggregation_enabled=false
#_index_join_enabled=false
#_disable_function_based_index=true
_ignore_desc_in_index = TRUE
#OPTIMIZER_FEATURES_ENABLE= "10.2.0"
#cursor_sharing = SIMILAR
optimizer_index_cost_adj = 100
optimizer_index_caching = 100
SGA_MAX_SIZE = 550M
|
|
|
 Nikki |
| Posted: Mar 30, 2007 12:07:36 AM |  |
|
Total Post: 10
Joined: Oct, 2003
|
Your SGA (db cache and shared pool) look very small. Now you can upload your AWR report at dbapool for tuning recommendations. Check this out at http://www.dbapool.com/perfrpt.php
- Nikki
|
|
|
|
|
| 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 | 814 |
| Mohammed Taj | 694 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 386 |
| positive fanatic | 361 |
| Gitesh Trivedi | 322 |
| Gopu Gopi | 239 |
| neeraj sharma | 228 |
| Ramesh Jois | 226 |
| snehalatha p | 169 |
|
|
