OraFAQ Forum: Server Utilities » Undo Retention Table

Home » RDBMS Server » Server Utilities » Undo Retention Table - Extent Commit Time

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Undo Retention Table - Extent Commit Time [message #159100]

Thu, 16 February 2006 02:47

arado196
Messages: 4
Registered: February 2006

Junior Member

I made a dump of an undo segment header block to read the extent commit time in the Retention Table.

I saw this:

Retention Table
-----------------------------------------------------------
Extent Number:0 Commit Time: 1133357275
Extent Number:1 Commit Time: 1133357278
Extent Number:2 Commit Time: 1133357288
Extent Number:3 Commit Time: 1133357296
Extent Number:4 Commit Time: 1133357299
Extent Number:5 Commit Time: 1133357306
Extent Number:6 Commit Time: 1133357319
Extent Number:7 Commit Time: 1133357324
Extent Number:8 Commit Time: 1133357333
Extent Number:9 Commit Time: 1133357338

Which is the date format of Commit Time?

I read somewhere that the format is Julian time but when i try to convert the julian string 1133357333 in the format YYYY-MON-DD HH24:MI:SS using

select TO_CHAR(to_date('11333573334','J'), 'YYYY-MON-DD HH24:MI:SS') from dual

i obtained an ora-01830 error.

Thanks

Report message to a moderator