ORA-07445 [smboPut()] On A Query Scanning A Clustered Table
(Doc ID 2256985.1)
Last updated on FEBRUARY 23, 2022
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.1 and laterOracle Database Cloud Schema 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
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
ORA-07445 [smboPut()+485] raised on a query with clustered table.
============
Plan Table
============
--------------------------------------------------+-----------------------------------+
| Id | Operation | Name | Rows | Bytes | Cost | Time |
--------------------------------------------------+-----------------------------------+
| 0 | SELECT STATEMENT | | | | 5479 | |
| 1 | SORT ORDER BY | | 2 | 200 | 5479 | 00:01:06 |
| 2 | HASH UNIQUE | | 2 | 200 | 5479 | 00:01:06 |
| 3 | FILTER | | | | | |
| 4 | SORT GROUP BY | | 2 | 200 | 5479 | 00:01:06 |
| 5 | HASH JOIN | | 15K | 1461K | 5478 | 00:01:06 |
| 6 | HASH JOIN | | 2677 | 209K | 4800 | 00:00:58 |
| 7 | TABLE ACCESS FULL | <TABLE_NAME1> | 2677 | 99K | 4730 | 00:00:57 |
| 8 | TABLE ACCESS FULL | <TABLE_NAME2>| 2663 | 109K | 70 | 00:00:01 |
| 9 | INDEX FAST FULL SCAN | <INDEX_NAME1> | 294K | 5872K | 677 | 00:00:09 |
portion of the call stack:
smboPut
soroPut
qersoSORowPRowsets
qerghFetch
qersoProcessULS process underlying row source
qersoFetchSimple
qersoFetch QERSO: Fetch from a sort row source
Changes
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 |