OraFAQ Forum: Performance Tuning » Performance issues

Home » RDBMS Server » Performance Tuning » Performance issues (Oracle 9i ,SunT2000)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Performance issues [message #319866]

Tue, 13 May 2008 04:54

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?

Report message to a moderator

Re: Performance issues [message #327477 is a reply to message #319866]

Mon, 16 June 2008 09:12

alanm
Messages: 284
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

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

Report message to a moderator

Re: Performance issues [message #327672 is a reply to message #327595]

Tue, 17 June 2008 03:29

alanm
Messages: 284
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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jun 27 21:29:46 CDT 2024