Re: Parse
From: Karth Panchan <keyantech_at_gmail.com>
Date: Sat, 15 Aug 2015 23:48:48 -0400
Message-Id: <1B9E36BA-2B65-4256-81CD-C08A269A69A3_at_gmail.com>
Hi Michael
Date: Sat, 15 Aug 2015 23:48:48 -0400
Message-Id: <1B9E36BA-2B65-4256-81CD-C08A269A69A3_at_gmail.com>
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_at_gmail.com> wrote:
>
> Is there a way to check whether a query is being hard or soft parsed?
-- http://www.freelists.org/webpage/oracle-lReceived on Sun Aug 16 2015 - 05:48:48 CEST