Home » RDBMS Server » Performance Tuning » Commit time format in retention table
Commit time format in retention table [message #159154] Thu, 16 February 2006 07:31 Go to next message
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
Re: Commit time format in retention table [message #159262 is a reply to message #159154] Fri, 17 February 2006 01:13 Go to previous messageGo to next message
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
Senior Member
It might be #secs since 1/1/1970 GMT. This places you data around 30/11/2005. Is that about right?

_____________
Ross Leishman
icon14.gif  Re: Commit time format in retention table [message #159309 is a reply to message #159262] Fri, 17 February 2006 04:54 Go to previous message
arado196
Messages: 4
Registered: February 2006
Junior Member
Exact!!!

Thanks!
Previous Topic: functional index and bind variable problem
Next Topic: Slow query performance...
Goto Forum:
  


Current Time: Fri Mar 29 03:03:29 CDT 2024