Hi Michael
I would check v$sqlarea on sql_id for given query.
Look for parse_calls column value increases for every soft parse.
Different SQL_ID might be other to way to find hard parse.
First_load_time column provide when was SQL loaded first time.
Karth
Sent from my IPhone
On Aug 15, 2015, at 10:32 PM, Michael Calisi <oracle455@xxxxxxxxx> wrote:--
Is there a way to check whether a query is being hard or soft parsed?
