Re: V$SQLAREA Executions Error? SOLVED

I'm no longer baffled, I'm mortified.

When I commented out the EXIT statements in my scripts, I discovered I was getting ORA-01555 (Rollback Segment too small). I'd thought my scripts were executing, then exiting normally - hence my dismay to see V$SQLAREA.Executions too low. Well, it wasn't - it was my dumb oversight.

After increasing the size of my RB Segs, I'm proceeding with comparitive stress testing of Ora8.1.6 on Win2000 and Solaris 8 Intel. BTW, so far Solaris 8 lets Ora8.1.6 perform significantly better than Win2k on the same CPU-bound PC. I'll post the results of my tests when completed.

Jack

Jack C. Applewhite wrote:

> 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
>
> ------------------------------------------------------------
>
> Subject:
> Date: Thu, 07 Dec 2000 10:00:16 -0600
> Organization: Stonebridge Technologies, Inc.
> To: ORACLE-L_at_fatcity.com
> References: <052569AE.0047AC18.00_at_ho-smtp1.amre.com>
>
> 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

--
Jack C. Applewhite
Senior Consultant, OCP Oracle8 DBA
Stonebridge Technologies, Inc.
...The Fast Track to e-Business.