Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

about first_load_time, last_load_time of v$sql..

872581Jul 25 2011 — edited Jul 25 2011
Hi, 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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 22 2011
Added on Jul 25 2011
4 comments
7,035 views