OraFAQ Forum: SQL & PL/SQL » SYSAUX IMPACT ON PERFORMANCE

Home » SQL & PL/SQL » SQL & PL/SQL » SYSAUX IMPACT ON PERFORMANCE (12c ENT Edition 12.2.0.1.0)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SYSAUX IMPACT ON PERFORMANCE [message #684761]

Mon, 16 August 2021 22:44

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 !!

Report message to a moderator

Re: SYSAUX IMPACT ON PERFORMANCE [message #684762 is a reply to message #684761]

Tue, 17 August 2021 00:17

Michel Cadot
Messages: 68767
Registered: March 2007
Location: Saint-Maur, France, https...

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.

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Aug 30 19:44:32 CDT 2025