OraFAQ Forum: Performance Tuning » Commit time format in retention table

Home » RDBMS Server » Performance Tuning » Commit time format in retention table

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

Commit time format in retention table [message #159154]

Thu, 16 February 2006 07:31

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