ORA-07445 [smboPut()] On A Query Scanning A Clustered Table (Doc ID 2256985.1)

Last updated on MAY 17, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.1 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 | INDVJOB | 2677 | 99K | 4730 | 00:00:57 |
| 8 | TABLE ACCESS FULL | INDV_COLL_PER| 2663 | 109K | 70 | 00:00:01 |
| 9 | INDEX FAST FULL SCAN | PK_INDVJOB | 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

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms