Home » RDBMS Server » Performance Tuning » performance issue on oracle 8
performance issue on oracle 8 [message #274449] Tue, 16 October 2007 01:59 Go to next message
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
Re: performance issue on oracle 8 [message #274454 is a reply to message #274449] Tue, 16 October 2007 02:12 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:

always giveing integrity constraint violated

This is not a performance problem but a data one.

Quote:

and it is very slow

First read How to Identify Performance Problem and Bottleneck

Quote:

storongly feel that check_point_interval(99999999) is very high.

Why? Did you check what is the purpose of this parameter?

Quote:

this is the instance summary:

Summary of what?

Quote:

please suggest some solutions

Read and study How to Identify Performance Problem and Bottleneck

Regards
Michel
Previous Topic: difference between db_buffer_keep and db_keep_cache_size?
Next Topic: parallel query
Goto Forum:
  


Current Time: Sat Dec 10 18:21:40 CST 2016

Total time taken to generate the page: 0.13019 seconds