Dbms_Stats.Gather_Fixed_Object_Stats Is Hanging While Reading X$DBKFDG
(Doc ID 2417784.1)
Last updated on SEPTEMBER 20, 2022
Applies to:
Oracle Database Cloud Schema Service - Version N/A and laterGen 1 Exadata Cloud at Customer (Oracle Exadata Database 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
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
- Calling DBMS_STATS.GATHER_FIXED_OBJECT_STATS hangs
- Hanganalyze will show query on X$DBKFDG waiting for 'ADR block file read' :
Oracle session identified by:
{
instance: 1
os id: 4676
process id: 36, ORACLE.EXE (SHAD)
session id: 11
session serial #: 3714
}
is waiting for 'ADR block file read' with wait info:
...
heur. time in wait: 32 min 14 sec
timeout after: never
wait id: 228724
blocking: 0 sessions
current sql: /* SQL Analyze(0) */ select /*+ full(t) no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring xmlindex_sel_idx_tbl no_substrb_pad */to_char(count("ADDR")),substrb(dump(min("ADDR"),16,0,64),1,240),substrb(dump(max("ADDR"),16,0,64),1,240),to_char(co
... -----------------------------------------------------------------------------------------------------------------------------------> Query is truncated but it is acting on X$DBKFDG - Call stack is similar to following :
skgfqio <- sdbgrfbibf_io_block_file <- dbgrfrbf_read_block_file <- dbgrmflrp_read_page <- dbgrmblgp_get_page
<- dbgrmblrp_read_page <- dbgrmqmgp_get_page <- dbgrmqmsk_scan_key <- dbgrmqmnp_next_page <- dbgrmqmif_internal_fetch
<- dbgrmqmf_fetch_real <- dbgrmqmf_fetch
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 |