Re: session wait fun

no offence taken! I hadn't thought about the epoch. ok, so how does the epoch get in to the seconds in wait column for a row in v$session? oh and I've confirmed this on a exadata as well. truly bizarre!



Thanks!


________________________________
 From: Niall Litchfield <niall.litchfield_at_gmail.com>
To: orclwzrd_at_yahoo.com 
Cc: David Fitzjarrell <oratune_at_yahoo.com>; oracle-l <oracle-l_at_freelists.org> 
Sent: Wednesday, January 8, 2014 5:41 AM
Subject: Re: session wait fun
 


Hi John,

Can you trace a session as well and see if the wait times reported there are also crazy. I'd then be using that as a test case for Oracle support. At the risk of insulting your intelligence you have double checked that your query for wait times makes sense.. BTW did my maths on the train last night make sense? I.e does the implied start of wait correspond to Jan 1st 1970? 

--
http://www.freelists.org/webpage/oracle-l