| performance issue on oracle 8 [message #274449] |
Tue, 16 October 2007 01:59  |
rc_ora
Messages: 2
Registered: September 2007
|
Junior Member |
|
|
ours is a typical production environment...
always giveing integrity constraint violated ,when wnat to print new bar codes(application people also checked ,but no problem)...
and it is very slow oracle 805 and solaris 2.6 having 5to 6 online production databases,
can you find some solution ( recenlty i joined)
bitmap_merge_area_size 1048576
compatible 8.0.5.2.0
db_block_buffers 20000
db_file_direct_io_count 64
db_files 80
hash_area_size 10000000
log_checkpoint_interval 99999999
log_buffer 8192000
shared_pool_size 100000000
shared_pool_reserved_size 5000000
this is the instance summary:
CPU used by this session 0
consistent changes 5866698
consistent gets 924645983
db block changes 50416726
db block gets 72605699
enqueue requests 468421
enqueue timeouts 0
enqueue waits 95
execute count 4591022
free buffer inspected 543428
free buffer requested 311360914
parse time cpu 0
physical reads 321816120
physical writes 1684514
recursive calls 1150853
redo entries 25434009
redo log space requests 14
redo size 4949470204
redo wastage 38334656
redo write time 0
redo writes 156265
sorts (disk) 43
sorts (memory) 252566
sorts (rows) 107529744
summed dirty queue length 319287
table fetch by rowid 302122581
table fetch continued row 23413540
table scan rows gotten 27448146990
table scans (long tables) 31075
table scans (short tables) 2350888
user calls 27191877
user commits 105011
user rollbacks 42459
write requests 5988
the database is using solaris 2.6 and facing severe performance issue( os is having more than 6
active instances)
i hope i need to increase the db+_block_buffer and
storongly feel that check_point_interval(99999999) is very high.
please suggest some solutions
thanks
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
