My Oracle Support Banner

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

Last updated on FEBRUARY 14, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.1 and later
Oracle 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.