| Bad results from V$LOGMNR_LOGS!! [message #129329] |
Sun, 24 July 2005 03:16 |
samizn
Messages: 7
Registered: March 2005
|
Junior Member |
|
|
I submitted this question at another section of the forums but I think this is the right place to post it...
I am using Oracle 9.2.0.1 on PC.
I am querying the V$LOGMNR_LOGS to get the LOW_TIME and HIGH_TIME of the redo logs and I am getting bad results!!
select to_char(LOW_TIME,'YYYY-MM-DD HH24:MI:SS'),
to_char(HIGH_TIME,'YYYY-MM-DD HH24:MI:SS')
from V$LOGMNR_LOGS
TO_CHAR(LOW_TIME,'Y TO_CHAR(HIGH_TIME,'
------------------- -------------------
2005-07-11 12:04:25 2005-07-12 12:20:44
2005-07-12 12:20:44 2005-07-13 12:36:13
2005-07-13 12:36:13 1988-01-01 00:00:00
These results are not accurate... I can see in the logminer that it contains records with timestamp bigger than "2005-07-13 12:36:13"!!!
What wrong??!! it seems like this view is not being updated!!!
Note: I get the same behavior when using Oracle 10.1.0.1!!
[Updated on: Sun, 24 July 2005 03:17] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
