Database Tuning (MOSC)

MOSC Banner

Same table different performance


We have 2 tables say DBO.Price and DBO1.PRICE in the same database. The DBO1.PRICE is created from DBO.Price thus has the same structure, data, Indexes. Itresides in the same database which means both use the same underlying resources. DBO1.PRICE was created by export dump.

After the copy we Gathered STATS on DBO1.PRICE, did a table shrink as well as did an INDEX REBUILD. Yet, when our application is mapped to DBO.Price i get a response time of 5 records while when it is mapped to DBO1.Price i get a response time of 20 seconds.

The execution plan for both are also the same. I am unable to come to any logical conclusion for the difference in performance. Anything else I am missing that has to be done to have the same response timings.

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center