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.


Received on Fri Mar 20 2009 - 07:35:18 CDT

Original text of this message