Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Poor Performance on Oracle9i - 9.2.0.7
Recently, we have migrated from 8.1.7.4 to 9.2.0.7 and now the
performance is terrible!!
Please, help us!!
The database server is Sun E6500 (24 SPARC processors and 24GB RAM mem)
and Solaris 2.6.
The database server is connected to IBM Shark Storage 2105 F20 using
two gigabit fiber channels. The size database is 400GB.
We have 350 Oracle Applications active users.
We have the Oracle Applications 11.5.9 running in another server - Sun
Fire V880 (4 processors SPARC and 8GB RAM mem) and Solaris 8.
The statspack is showing data contention in latches, specially, cache
buffers chains and library cache, as follows:
CACHE BUFFERS CHAINS
Gets = 561344520
Sleeps = 77469
Percentage = 48,99%
Cumulative = 48,99%
LIBRARY CACHE
Gets = 55715493
Sleeps = 55456
Percentage = 35,07%
Cumulative = 84,06 %
Please, checking if the init.ora parameters are correct.
db_name = PROD
control_files =
/prod11i/app/proddata/control01.ctl,/db1prod/oradata/PROD/control02.ctl,
/db1prod/oradata/PROD/control03.ctl
db_block_size = 8192
compatible = 9.2.0
_system_trig_enabled = TRUE
O7_DICTIONARY_ACCESSIBILITY = TRUE
row_locking = always nls_language = american nls_territory = america nls_date_format = DD-MON-RR nls_numeric_characters = ".," nls_sort = binary nls_comp = binary nls_length_semantics = byte max_enabled_roles = 100
db_cache_size = 1G db_block_checking = FALSE db_block_checksum = TRUE log_checkpoint_timeout = 1200 log_checkpoint_interval = 2147483647
log_archive_dest=/archPROD/PROD log_archive_format=arch%s.dbf log_archive_start=true undo_management = AUTO undo_tablespace = APPS_UNDOTS1
undo_suppress_errors = false workarea_size_policy = AUTO olap_page_pool_size = 4194304
Somebody can help us, please?
There are some tips to improve the performance on 9.2.0.7?
Thank you.
Received on Fri May 05 2006 - 10:09:38 CDT