Select Fails with ORA-7445 [smbqb1nx()+185] (Doc ID 1672204.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 to 12.1.0.1 [Release 11.2 to 12.1]
Information in this document applies to any platform.

Symptoms

Select fails with:

ORA-07445: exception encountered: core dump [smbqb1nx()+185] [SIGSEGV] [ADDR:0x0] [PC:0x69A6B15] [SI_KERNEL(general_protection)] []

 

Explain plan in incident file shows a Window Sort operation: 

| 0   | SELECT STATEMENT            |                |       |       |  989K |           |
| 1   |  VIEW                       |                |   100 |   11M |  989K |  03:22:28 |
| 2   |   COUNT STOPKEY             |                |       |       |       |           |
| 3   |    VIEW                     |                |  481K |   51G |  989K |  03:22:28 |
| 4   |     WINDOW SORT PUSHED RANK |                |  481K | 3711M |  989K |  03:22:28 |
| 5   |      TABLE ACCESS FULL      | SUP_00000207252|  481K | 3711M |  198K |  00:41:36 |

  

Call Stack:

smbqb1nx ksxb1inc ksxb1cmp qerwnWriteToDisk smbwrt smbput sorputqb qerwnRowP kdstf00001010000kmP
kdsttgr qertbFetch qerwnFetch qervwFetch qercoFetch qervwFetch opifch2 kpoal8 opiodr ttcpip opitsk
opiino opiodr opidrv sou2o opimai_real ssthrdmain main

 

 

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