Meaning of columns in V$SQLAREA: FIRST_LOAD_TIME, LAST_LOAD_TIME, LAST_ACTIVE_TIME
In V$SQLAREA there is a column named EXECUTIONS.
For a query the value of this column is 21911 executions.
I need to know the time period for these executions.
In other words in how many hours did these executions occur in?
There are other columns named FIRST_LOAD_TIME, LAST_LOAD_TIME, and LAST_ACTIVE_TIME.
FIRST_LOAD_TIME is defined as the Timestamp of the parent creation time.
Is it correct to assume that this this is the first time the sql was run on the database and LAST_LOAD_TIME is the last time.
Example of actual output for the query.
0