Home » SQL & PL/SQL » SQL & PL/SQL » SYSAUX IMPACT ON PERFORMANCE (12c ENT Edition 12.2.0.1.0)
icon1.gif  SYSAUX IMPACT ON PERFORMANCE [message #684761] Mon, 16 August 2021 22:44 Go to next message
vippysharma
Messages: 73
Registered: May 2013
Location: www
Member
Hi All - hope you are doing great...

I have one general question,

I have two DBs DB_DEV and DB_QA, configuration is same in both of them.
I have one SQL which is takin 45+ minutes in one DB_QA but on DB_DEV it take only 60-70 seconds to complete. And while checking DB_QA I found that SYSAUX tablespace is 95% full, is this reason can slow my SQL performance ??

I do research google or other stuff but didn't get proper answer, they all told about purging old STATs data etc.

Audit is enable on both DBs and STATISTICS_LEVEL = TYPICAL and also STATISTICS are up to date on both DBs.

But my question here is, is SYSAUX can make DB executions slow ?? or should I look into some other causes, if so what those should be ?

thanks !!
Re: SYSAUX IMPACT ON PERFORMANCE [message #684762 is a reply to message #684761] Tue, 17 August 2021 00:17 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

2nd option; please read http://www.orafaq.com/forum/index.php/mv/msg/206002/433888/#msg_433888 and post the required information.

Previous Topic: Creating rows every 5 minutes without overlap
Next Topic: How to execute dynamically the permission grant using AWS RDS custom procedure (merged)
Goto Forum:
  


Current Time: Thu Mar 28 18:30:35 CDT 2024