Cursor Mutex X Wait Events: After Upgrading To 12.2 (Doc ID 2298504.1)

APPLIES TO:
Oracle Database – Enterprise Edition – Version 12.2.0.1 and later
Oracle Database Cloud Schema Service – Version N/A and later
Oracle Database Exadata Express Cloud Service – Version N/A and later
Oracle Database Exadata Cloud Machine – Version N/A and later
Oracle Cloud Infrastructure – Database Service – Version N/A and later
Information in this document applies to any platform.

CHANGES
Upgraded the database to 12.2.0.1.0

CAUSE
The default value for _cursor_obsolete_threshold is 1024 pre 12.2, but has increased to 8192 in 12.2.

SOLUTION
Consider setting the parameter _cursor_obsolete_threshold to 1024, the default value for previous versions.
Alter system set “_cursor_obsolete_threshold”=1024 scope=spfile
reboot database.

0 پاسخ

دیدگاه خود را ثبت کنید

تمایل دارید در گفتگوها شرکت کنید؟
در گفتگو ها شرکت کنید.

دیدگاهتان را بنویسید