This "Last Activity" date/time is calculated as "sysdate - (v$timer.hsecs - v$sesstat.value) / 8640000" where we use v$sesstat for statistics#=13 which is session last activity time in 100ths of seconds since the beginning of the epoch. The v$timer.hsecs returns the system time in 100ths of seconds since the beginning of the epoch. Both times wraps around to 0 after about 479 days. Anyway, if you do not have TIMED_STATISTICS enabled in the parameter file (INIT.ORA) most likely that v$sesstat.value is equal to 0 for any session and therefore the described formula produces incorrect result. : I have OMS 2.05 : This could be a bug or just a configuration problem on my, end but I need to : try to resolve it regardless. The Date/Time displayed, when the : Connections Icon is selected, is incorrect. : This did not come up as a critical issue until recently. I needed to track : several sessions that would lock up when started, but the only way I could : identify them is the time they logged on. Unfortunately all of my : Date/Times displayed are wrong. i.e. today which is 10/22/1999 13:21:35 is : displaying 12/5/99 7:32:56. : We have a different date format as our default date format which is: : YYYY-MM-DD HH:MI.SS . Could this be the problem ?? : And if it is how can I fix this ? or Is this a bug ? : Thanks for an excellent product, : Rich
|