No question at this time
DBA Top 10
1 A. Kavsek 10000
2 M. Cadot 9900
3 B. Vroman 5700
4 P. Wisse 4300
5 J. PĂ©ran 1800
6 . Lauri 1200
7 J. Schnackenberg 600
8 F. Pachot 500
9 Z. Hudec 400
9 G. Lambregts 400
9 N. Havard 400
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48503
Total active users1429
Act. users last 24h2
Act. users last hour0
Registered user hits last week104
Registered user hits last month599
Go up

Data retention for dba_hist_undostat and v$undostat
Next thread: RMAN PITR - Table from PROD to NON PROD environment
Prev thread: grant select one schema to another schema

Message Score Author Date
Hi, I have few databases 12c EE with Tuning Pac...... Lauri Nov 27, 2019, 14:32
I think this is the explantion: https://blog.toad...... Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts Lauri Nov 27, 2019, 16:05

Follow up by mail Click here


Subject: Data retention for dba_hist_undostat and v$undostat
Author: Lauri, Netherlands
Date: Nov 27, 2019, 14:32, 183 days ago
Os info: Linux x86 64bit
Oracle info: 12c
Error info: n/a
Message: Hi,

I have few databases 12c EE with Tuning Pack option, the view dba_hist_undostat returns no rows, and the view v$undostat has records up to five days ago.
Does someone know what the data retention is for dba_hist_undostat and v$undostat?

Kind Regards
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re-Data retention for dba_hist_undostat and v$undostat
Author: Lauri, Netherlands
Date: Nov 27, 2019, 16:05, 183 days ago
Score:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
Message: I think this is the explantion:
https://blog.toadworld.com/blog/2017/07/25/how-to-analyze-undo-statistics-to-proactively-avoid-undo-space-issues
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here