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!

What is LAST_ACTIVE_TIME column in v$sql view

oratestAug 30 2010 — edited Aug 30 2010

Hi,

I am using Oracle 10.2.0.3 version.

I have a doubt in v$sql view.

What is the meaning of LAST_ACTIVE_TIME column in v$sql view?

I presume it is the latest time when this SQL was executed in the database. M I right?

As per Oracle docs it's definition is as below.

LASTACTIVE_TIME - Time at which the query plan was last active ._

Thanks in advance.

Best Regards,
oratest

This post has been answered by 618702 on Aug 30 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 27 2010

Added on Aug 30 2010

#general-database-discussions

2 comments

4,195 views