Database Administration (MOSC)

MOSC Banner

Meaning of columns in V$SQLAREA: FIRST_LOAD_TIME, LAST_LOAD_TIME, LAST_ACTIVE_TIME

edited Apr 21, 2010 1:17AM in Database Administration (MOSC) 2 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center