Dbms_Stats.Gather_Fixed_Object_Stats Is Hanging While Reading X$DBKFDG
(Doc ID 2417784.1)
Last updated on AUGUST 04, 2018
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.2 and laterInformation 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 (cp4ef.cp4ef)
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 :
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
<- dbgrmblrp_read_page <- dbgrmqmgp_get_page <- dbgrmqmsk_scan_key <- dbgrmqmnp_next_page <- dbgrmqmif_internal_fetch
<- dbgrmqmf_fetch_real <- dbgrmqmf_fetch
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! |