This content has been marked as final. Show 3 replies
Hi KK;1 person found this helpful
Please review below doc which could gives you some idea and path
High "Resmgr:Cpu Quantum" Wait Events In 11g Even When Resource Manager Is Disabled [ID 949033.1]
Jobs Running With Module Name "DBMS_SCHEDULER", Action Name Like "ORA$AT" And How To Disable Them [ID 1380802.1]
Automatic SQL Tuning - SQL Profiles. [ID 271196.1]
Thanks helios. I will have a look at it and update.
1 person found this helpful
There was a thread on a french forum where someone came asking a question about his SYSTEM Tablespace growing significantly everyday
I was looking for an imapct of disabling SQL Tuning and Resource Manager on one of the production databases.
After several back and forth he ends up saying that his SYSTEM Tablespace is growing due to the SQL tuning advisor. He disabled it and came two days after confirming that the abnormal
space growing of his SYSTEM tablespace has gone.
At least this is one of the (good) side effects of disabling the SQL tuning advisor.
Hope this helps