Re: Why is this SQL not shared ?

On 12 Nov 2001 11:09:07 -0800, bchorng_at_yahoo.com (Bass Chorng) wrote:

>I have seen many cases where the same SQL (hash_value) has multiple
>entries
>in v$sql although they are all parsed by the same user, with each
>entry only
>executed 2 or 3 times. I am wondering why the SQL is not shared. In
>the following example, why don't I see only one entry with, say 120+
>of executions?
>
>SQL> select count(*) from v$sql where hash_value = 460964395 and
>parsing_user_id = 248;
>
> COUNT(*)
>----------
> 53
>
>What would cause the same SQL to be not shared by the same parsing
>user ?
>
>-Bass Chorng

Because you are looking at v$sql instead of v$sqlarea, where the number of executions is tracked.
Your result show you have 53 sessions sharing the same statement.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Mon Nov 12 2001 - 15:25:29 CST