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!

dbms_shared_pool.purge() alert log messages in 12C

User_HSMK8Dec 19 2016 — edited Nov 1 2019

Hello,

After an upgrade to Oracle 12C, I am receiving the message below:

Mon Dec 19 12:26:44 2016

Executed dbms_shared_pool.purge(): hash=1ce3bg7e phd=400010939736d10 flags=156811294 childCnt=225 mask=1, purgeCnt=110 invalidCnt=0 ospid=9699988

How can I stop/supress message like this ?

I assume that, dbms_shared_pool.purge() procedure is leaded by the hash value of the sql that can be identified in v$sqlarea. Please corcect me if I am wrong with this.

Best Regards,

Damian

This post has been answered by ddf_dba on Dec 19 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 16 2017

Added on Dec 19 2016

#general-database-discussions

3 comments

997 views