Database Administration (MOSC)

MOSC Banner

count(*) is taking more time in production vs test

Hi Experts ...Need your kind help on what else i can check to improve the simple count query which takes about 4 seconds in production but takes less than a second in test.

Database : 12.2.0.1 April 2021 CPU patch.


TEST:

Production:

So far i collected stats and i see table and index stats are upto date.

Please suggest what else i can do to improve the query performance.

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