10G and Undo

[Sambo8]

Hi there,

THis may be a dumb? but I've hardly touched 10g is there anyway of finding out what time of day the undo tablespace is getting the most transactions?

Cheers

Sam

 

[jimirvine]

Check out V$UNDOSTAT

 

[Sambo8]

Thanks Jim,

This helps as it gives the date, but no time is that something I can tweak to show the time?

Many thanks,

Sam

 

[hoinz]

Sam,

it seems you are unaware of the features of Oracle's datatype date. Actually it is date and time; however by default only date is shown.

For a start try this:

select to_char(begin_time,'YYYYMMDD-HH24MISS') from v$undostat;

And in case you prefer another format, have a look at the manual; I think you will find it when you look for an explanation of function to_char()

hope this helps