| Strange date on v$undostat [message #178972] |
Fri, 23 June 2006 13:03  |
crfilho
Messages: 2
Registered: June 2006
Location: Brazil
|
Junior Member |
|
|
Hi all,
Since 2 weeks ago my undotbs has been growing. It has reched the limit of 32 Gb. I´ve already recreated, but it´s still growing.
Checking the v$undostat, i noticed that there was dates from 2025. See the query and results below.
SELECT TO_CHAR (begin_time, 'mm/dd/yyyy hh24:mi:ss') BEGIN,
TO_CHAR (end_time, 'mm/dd/yyyy hh24:mi:ss') END, undoblks, unxpstealcnt,
unxpblkrelcnt, unxpblkreucnt, ssolderrcnt
FROM v$undostat;
And the results (Just 2 first column)
BEGIN END
06/05/2025 16:43:43 06/05/2025 16:47:18
06/05/2025 16:33:43 06/05/2025 16:43:43
06/05/2025 16:23:43 06/05/2025 16:33:43
06/01/2025 16:53:43 06/05/2025 16:23:43
Have this dates any influence over the undo tablespace? How can i "correct" them ?
Thanks in advance
Claudionor C. Rocha Filho
DBA ORACLE & SQL SERVER
Rio de Janeiro - Brasil
|
|
|
|
|
|
 Re: Strange date on v$undostat [message #179263 is a reply to message #178972] |
Mon, 26 June 2006 09:44  |
crfilho
Messages: 2
Registered: June 2006
Location: Brazil
|
Junior Member |
|
|
Hi Frank,
Thanx for your reply. My system date is correct. I think it was wrong 2 weeks ago and oracle get this wrong date. I tried update v$undostat but it isn't updatable and i can't find out a way to correct these wrong dates on v$undostat.
Claudionor C. Rocha Filho
DBA ORACLE & SQL SERVER
Rio de Janeiro - Brasil
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
