Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Large Growth Of WRI$_ADV_SQLT_PLANS

3434169Jul 19 2017

Hello,

Oracle Database - Enterprise Edition - Version 11g R2

Symptoms

* Abnormal growth of table sys.WRI$_ADV_SQLT_PLAN

* Running AWRINFO.SQL report shows most of the space is used by WRI$_ADV_SQLT_PLAN

COMPONENT    MB               SEGMENT_NAME                                                                        SEGMENT_TYPE
NON_AWR 2,176.0              SYS.WRI$_ADV_SQLT_PLANS                                           TABLE

Can i apply the same solution note ID 2205210.1 for my oracle database version 11g?

Or there is another way to solve this problem?

How can I avoid a future growth of this tables?

With Thanks,

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 16 2017
Added on Jul 19 2017
0 comments
963 views