Home » RDBMS Server » Performance Tuning » Performance issues (Oracle 9i ,SunT2000)
Performance issues [message #319866] Tue, 13 May 2008 04:54 Go to next message
vaishalikatarki
Messages: 43
Registered: April 2008
Location: Bangalore
Member

Hi,

When I run the stress I get the below udump:
Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
ORACLE_HOME = <path>
System name: SunOS
Node name: veritas7
Release: 5.10
Version: Generic_118833-36
Machine: sun4v
Instance name: <sid>
Redo thread mounted by this instance: 1
Oracle process number: 21
Unix process pid: 12164, image: oracle@veritas7 (TNS V1-V3)

*** SESSION ID:(18.3) 2008-05-12 20:47:31.497
Thread checkpoint rba:0x001e7c.00009aaa.0010 scn:0x0000.13e0d059
On-disk rba:0x001e7c.00009f73.0000 scn:0x0000.13e0d5e6
Use incremental checkpoint cache-low RBA
Thread 1 recovery from rba:0x001e7c.00009e96.0000 scn:0x0000.00000000
----- Redo read statistics for thread 1 -----
Read rate (ASYNC): 110Kb in 0.01s => 0.00 Mb/sec
Longest record: 0Kb, moves: 0/485 (0%)
----------------------------------------------
----- Recovery Hash Table Statistics ---------
Hash table buckets = 32768
Longest hash chain = 1
Average hash chain = 15/15 = 1.0
Max compares per lookup = 1
Avg compares per lookup = 950/965 = 1.0
----------------------------------------------
*** 2008-05-12 20:47:31.542
KCRA: start recovery claims for 15 data blocks
*** 2008-05-12 20:47:31.543
KCRA: buffers claimed = 15/15, eliminated = 0
*** 2008-05-12 20:47:31.545
Recovery of Online Redo Log: Thread 1 Group 16 Seq 7804 Reading mem 0
----- Recovery Hash Table Statistics ---------
Hash table buckets = 32768
Longest hash chain = 1
Average hash chain = 15/15 = 1.0
Max compares per lookup = 1
Avg compares per lookup = 965/965 = 1.0
----------------------------------------------

Can anyone let me know what does this dump indiactes?
Re: Performance issues [message #327477 is a reply to message #319866] Mon, 16 June 2008 09:12 Go to previous messageGo to next message
alanm
Messages: 282
Registered: March 2005
Senior Member

hi,
I believe oracle is carrying out an internal cleanup.

regards

Alan

[Updated on: Mon, 16 June 2008 10:13] by Moderator

Report message to a moderator

Re: Performance issues [message #327595 is a reply to message #327477] Tue, 17 June 2008 00:26 Go to previous messageGo to next message
vaishalikatarki
Messages: 43
Registered: April 2008
Location: Bangalore
Member

Hi Alan,

As you said that oracle is that "oracle is carrying out an internal cleanup" is this required.Will this reduce the performance?

If so how can I avoid the oracle cleanup.

Regards,
Vaishali

Re: Performance issues [message #327672 is a reply to message #327595] Tue, 17 June 2008 03:29 Go to previous message
alanm
Messages: 282
Registered: March 2005
Senior Member

hi,
what kind of stress testing are you carrying out?
there might be some impact on performance but Oracle has decided by whatever it is programmed that an clean up is required. you will not be able to stop this.

regards

Alan

[Updated on: Thu, 17 July 2008 11:17] by Moderator

Report message to a moderator

Previous Topic: Need help in tuning this procedure
Next Topic: SQL Tune
Goto Forum:
  


Current Time: Sun Dec 11 02:39:01 CST 2016

Total time taken to generate the page: 0.09452 seconds