V$sql: first and last-load-time
From: FmHabash <fmhabash_at_gmail.com>
Date: Fri, 20 Mar 2009 08:35:18 -0400
Message-ID: <49c38d86.1fd6720a.02f3.ffffe2f7_at_mx.google.com>
I can see how and when first-load-time changes. Simply invalidating a cursor does it. However, could not come up with a way to manipulate last-load-time to understand what it really means. If a cursor gets reloaded, why doesn't first-lt changes. Why did oracle come up with this attribute for a sql.
Date: Fri, 20 Mar 2009 08:35:18 -0400
Message-ID: <49c38d86.1fd6720a.02f3.ffffe2f7_at_mx.google.com>
I can see how and when first-load-time changes. Simply invalidating a cursor does it. However, could not come up with a way to manipulate last-load-time to understand what it really means. If a cursor gets reloaded, why doesn't first-lt changes. Why did oracle come up with this attribute for a sql.
Thanks
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Mar 20 2009 - 07:35:18 CDT