Re: V$SQLAREA Executions Error?

This is a multi-part message in MIME format.
--------------DA73B3C6AE2537EDD3EB47C8

Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit

I haven't seen this post yet (it's been over 7 hours!), but I have additional info.

V$SQLAREA.Executions is also not reporting the correct count in Oracle8i 8.1.6.0.0 on Win2000. It seems that whenever I run four sessions of the PL/SQL block that loops through 1000 Inserts, one or two of the other Update, Full Table Scan, and/or Index Scan sessions don't get counted in V$SQLAREA.Executions correctly - grossly undercounted.

I'm baffled.

Jack

--------------DA73B3C6AE2537EDD3EB47C8

Content-Type: message/rfc822
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Message-ID: <3A2FB410.DB67B135_at_sbti.com> Date: Thu, 07 Dec 2000 10:00:16 -0600
From: "Jack C. Applewhite" <Jack.Applewhite_at_sbti.com> Organization: Stonebridge Technologies, Inc. X-Mailer: Mozilla 4.06 [en] (WinNT; I)
MIME-Version: 1.0
To: ORACLE-L_at_fatcity.com
Subject: V$SQLAREA Executions Error?
References: <052569AE.0047AC18.00_at_ho-smtp1.amre.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit

Hi,

Is anyone aware of any problem with V$SQLAREA not showing an accurate count of Executions? I ran several concurrent scripts to stress test 8.1.6 on Solaris 8 Intel. Each script looped for 1000 or 10,000 times, either inserting, updating or selecting from a 100,000 row table.

V$SQLAREA.Executions incremented for one of the SQL Select statements only about 19,000 times when it should have been 40,000. When I ran 4 of those very same scripts without all the others, Executions showed the correct 40,000.

Under load, does V$SQLAREA not get updated sometimes?

Thanks.

Jack

--
Jack C. Applewhite
Senior Consultant, OCP Oracle8 DBA
Stonebridge Technologies, Inc.
...The Fast Track to e-Business.
  (visit us at www.sbti.com)
Austin, Texas
1.512.502.3337