Re: session wait fun
- From: John D Parker <orclwzrd@xxxxxxxxx>
- To: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- Date: Thu, 9 Jan 2014 12:03:44 -0800 (PST)
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@xxxxxxxxx>
To: orclwzrd@xxxxxxxxx
Cc: David Fitzjarrell <oratune@xxxxxxxxx>; oracle-l <oracle-l@xxxxxxxxxxxxx>
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?
Other related posts:
