- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 65 Insurance
- 536.7K On-Premises Infrastructure
- 138.4K Analytics Software
- 38.6K Application Development Software
- 5.9K Cloud Platform
- 109.5K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.2K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
DBA_HIST_UNDOSTAT returns no rows within PDBs
currently I'm analyzing an issue with autotuned undo retention (Very high "TUNED_UNDORETENTION" => It's equal to instance runtime ) .
While doing this I've noticed that DBA_HIST_UNDOSTAT only returns rows if you query it in the CDB$ROOT. In all PDBs it will returns no rows.
We have local undo in PDBs enabled and Oracle 184.108.40.206 running on OL 7.5. Diagnostic Pack is licensed and enabled.
The alternative view CDB_HIST_UNDOSTAT returns only rows for container id 1, which is cdb$root.
Does anybody have the same behavior and an explanation/solution?