Database Administration (MOSC)

MOSC Banner

Performance issue with db_block_checksum in 10.2.0.4 ?

edited Aug 10, 2009 7:19PM in Database Administration (MOSC) 1 commentAnswered

Hi,

We are having issues with performance after converting from 9i to 10.2.0.4, with both reads and inserts. 

I found a bug 6814520 which relates to performance issues being experienced under 10.2.0.3 on Solaris Sparc64 when db_block_checksum is set to true. 

We are using solaris sparc64 so I think we may be hitting this bug.  I have not reset the db_block_check to false yet.

The bug notes that a patch is available for 10.2.0.3 and 11.1. The problem is fixed from 11.2 onwards and will be fixed in 10.2.0.5.

My question is will there be a patch for 10.2.0.4 ?

thanks.

 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center