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