Database Tuning (MOSC)

MOSC Banner

New database creating delays in running sql queries.

edited Mar 28, 2012 5:17AM in Database Tuning (MOSC) 22 comments
Hi Gurus,

With my customer, I have done oracle database migration to new environment fron a single node Oracle database to 2 node Oracle Cluster database. Please note the hardware details. I have attached the init parameter comparison file for your review.

OLD Server:

HP DL380 G5

CPU = Intel Xeon E5440 @ 2.83GHz 2.83GHz

RAM = 32GB

OS = Windows Server 2003 R2 EE SP2 (32-bit)


New Servers (2 nodes):

Sun Blade x6270 M2 Server Module

CPU = Intel Xeon X5670 @ 2.93 GHz 2.93 GHz

RAM = 32GB

OS = Windows Server 2008 EE R2 (x64)


Performance Problem:

I am facing delays while running SQL queries on new environment whereas the similar queries running fast on old env.

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