about first_load_time, last_load_time of v$sql..
872581Jul 25 2011 — edited Jul 25 2011Hi, all.
I am confused about first_load_time and last_load_time of v$sql. (oracle is 10.2.0.4)
---------------------
The following is from v$sql.
inst_id : 1
sql_id : cvahcqx8nxcwa
child_number : 0
hash_value : 1364112266
plan_hash_value : 127586245
first_load_time : 2011-07-17/07:00:53
last_load_time : 2011-07-24/07:06:33
----------------
First load time is the time when the sql(sql_id) was loaded to library cache.
Last load time is the time when the sql plan was changed.
This is my guess. Is this right?
If not, what is the exact meaning of first_load_time, and last_load_time in this case?
Thanks in advance.
Best Regards.