Database Tuning (MOSC)

MOSC Banner

SQL query slow

edited Jun 21, 2010 8:38PM in Database Tuning (MOSC) 3 commentsAnswered
   

We are have two development server, here we can call server10 and server11.

 

Server’s having same hardware and OS, but different oracle version, server 10 and server 11 having oracle 10g and oracle 11g respectively.

 

Problem, when you run sql  query in oracle 11g  it’s  very slow compare to oracle 10g server.

 

Here I have checked

1)      sga size –  comparatively 11g size is big

2)      no full table scan

 

 

 

OS – SUN

DB: 11.1.0.7.0, 10.2.0.4.0

can you give me advice or idea,  how to overcome the issue?

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