My Oracle Support Banner

19c:CREATE TABLE (PARTITION) Statement on Exadata hangs forever (Doc ID 2600819.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 19.1.0.0.0 and later
Information in this document applies to any platform.

Symptoms

1. Query was only running fine with DOP 88 and other then that it was hanging
2. There was no change in execution plan
3. query was going for full table scan
4.
WAIT #140318468669472: nam='cell smart table scan' ela= 83
cellhash#=525586571 p2=0 p3=0 obj#=2041850 tim=61380169489
WAIT #140318468669472: nam='cell smart table scan' ela= 2039
cellhash#=525586571 p2=0 p3=0 obj#=2041850 tim=61380171593
WAIT #140318468669472: nam='cell smart table scan' ela= 118
cellhash#=525586571 p2=0 p3=0 obj#=2041850 tim=61380171884
WAIT #140318468669472: nam='cell smart table scan' ela= 81
cellhash#=525586571 p2=0 p3=0 obj#=2041850 tim=61380172039>>>>>>>

5. cell disk behavior

CellCLI> list activerequest
0 BP03 "Smart scan" "Predicate Pushing"
"Queued for Predicate Disk"
0 BP03 "Smart scan" "Predicate Pushing"
"Queued for Predicate Disk"
0 BP03 "Smart scan" "Predicate Pushing" 

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
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.