How to Check for Quarantines and Drop them with cellcli on Exadata Storage Server
(Doc ID 2799584.1)
Last updated on NOVEMBER 16, 2022
Applies to:
Oracle Exadata Storage Server Software - Version 11.1.3.1.0 and laterInformation in this document applies to any platform.
Symptoms
On the storage cell server alert history can see messages like the following
15_1 2018-09-07T14:19:44-04:00 critical "A SQL PLAN quarantine has been added. As a result, Smart Scan is disabled for SQL statements with the quarantined SQL plan. Quarantine id : 70 Quarantine type : SQL PLAN Quarantine reason : Crash Quarantine Plan : SYSTEM Quarantine Mode : FULL_Quarantine DB Unique Name : DB1 Incident id : 9 SQLID : b4ddqpjmc704q SQL Plan details : {SQL_PLAN_HASH_VALUE=9954606, PLAN_LINE_ID=4} In addition, the following disk regions have been quarantined, and Smart Scan will be disabled for these regions: Disk Region : {Grid Disk Name=DATA01_CD_09_dbm01celadm07, offset=240745709568, size=1M} Disk Region : {Grid Disk Name=DATA01_CD_09_dbm01celadm07, offset=240744660992, size=1M} Disk Region : {Grid Disk Name=DATA01_CD_09_dbm01celadm07, offset=240747806720, size=1M} Disk Region : {Grid Disk Name=DATA01_CD_09_dbm01celadm07, offset=240746758144, size=1M} "
21 2020-02-05T10:55:15-05:00 critical "ORA-07445: exception encountered: core dump [0000000000000000+139953425802766] [11] [0x000000000] [] [] []"
22 2020-02-05T10:55:15-05:00 critical "ORA-07445: exception encountered: core dump [0000000000000000+139952918749392] [11] [0x000000000] [] [] []"
23_1 2020-02-05T10:55:58-05:00 critical "A SQL PLAN quarantine has been added. As a result, Smart Scan is disabled for SQL statements with the quarantined SQL plan. Quarantine id : 100 Quarantine type : SQL PLAN Quarantine reason : Crash Quarantine Plan : SYSTEM Quarantine Mode : FULL_Quarantine DB Unique Name : DBPRD Incident id : 49 SQLID : 5b51s2nphpv3x SQL Plan details : {SQL_PLAN_HASH_VALUE=2956149736, PLAN_LINE_ID=80} In addition, the following disk regions have been quarantined, and Smart Scan will be disabled for these regions: Disk Region : {Grid Disk Name=DATA01_CD_02_dbm01celadm07, offset=1266860163072, size=1M} Disk Region : {Grid Disk Name=DATA01_CD_02_dbm01celadm07, offset=1266861211648, size=1M} "
Changes
N/A
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |