Database Administration (MOSC)

MOSC Banner

Significantly slow performance when selecting from sys.aud$ in production vs. from test instance.

edited Oct 18, 2019 5:03AM in Database Administration (MOSC) 3 commentsAnswered

I've just noticed in TEST selecting from sys.aud$ ... performance is significantly better than same select  issued in Production.     They  both have a large numjber of rows (3 months retention).     Test takes a couple seconds, production takes 30-45 seconds.

This is a RHEL 6 server, db has been relatively recently upgraded to Oracle 12.2.0.1

I've read a lot of articles, not found the cause yet.

Yes, both are in the SYSTEM tspace, and that will be remedied shortly by moving to a new AUDIT tspace.

My plan if I can't resolve will be to truncate the table and move it to the new space and watch it more closely.

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