| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: V$SQLAREA Executions Error? SOLVED
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C06159.63B5B410
Content-Type: text/plain;
charset="iso-8859-1"
Jack,
Absolutely fascinating test.
What are the file systems and disk arrays for each OS?
Great thing you're doing!
Ross
-----Original Message-----
From: Jack C. Applewhite [mailto:Jack.Applewhite_at_sbti.com]
Sent: Friday, December 08, 2000 2:07 PM
To: Multiple recipients of list ORACLE-L
Subject: 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. (visit us at www.sbti.com) Austin, Texas 1.512.502.3337 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: Jack.Applewhite_at_sbti.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ------_=_NextPart_001_01C06159.63B5B410 Content-Type: text/html; charset="iso-8859-1" <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> <META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2653.12"> <TITLE>RE: V$SQLAREA Executions Error? SOLVED</TITLE> </HEAD> <BODY> <P><FONT SIZE=2>Jack, </FONT> </P> <P><FONT SIZE=2>Absolutely fascinating test. </FONT> </P> <P><FONT SIZE=2>What are the file systems and disk arrays for each OS?</FONT> </P> <P><FONT SIZE=2>Great thing you're doing!</FONT> </P> <P><FONT SIZE=2>Ross</FONT> </P> <P><FONT SIZE=2>-----Original Message-----</FONT> <BR><FONT SIZE=2>From: Jack C. Applewhite [<A HREF="mailto:Jack.Applewhite_at_sbti.com">mailto:Jack.Applewhite_at_sbti.com</A>]</FONT> <BR><FONT SIZE=2>Sent: Friday, December 08, 2000 2:07 PM</FONT> <BR><FONT SIZE=2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=2>Subject: Re: V$SQLAREA Executions Error? SOLVED</FONT> </P> <BR> <P><FONT SIZE=2>I'm no longer baffled, I'm mortified.</FONT> </P> <P><FONT SIZE=2>When I commented out the EXIT statements in my scripts, I discovered I was getting</FONT> <BR><FONT SIZE=2>ORA-01555 (Rollback Segment too small). I'd thought my scripts were executing, then</FONT> <BR><FONT SIZE=2>exiting normally - hence my dismay to see V$SQLAREA.Executions too low. Well, it</FONT> <BR><FONT SIZE=2>wasn't - it was my dumb oversight.</FONT> </P> <P><FONT SIZE=2>After increasing the size of my RB Segs, I'm proceeding with comparitive stress</FONT> <BR><FONT SIZE=2>testing of Ora8.1.6 on Win2000 and Solaris 8 Intel. BTW, so far Solaris 8 lets</FONT> <BR><FONT SIZE=2>Ora8.1.6 perform significantly better than Win2k on the same CPU-bound PC. I'll post</FONT> <BR><FONT SIZE=2>the results of my tests when completed.</FONT> </P> <P><FONT SIZE=2>Jack</FONT> </P> <BR> <P><FONT SIZE=2>Jack C. Applewhite wrote:</FONT> </P> <P><FONT SIZE=2>> I haven't seen this post yet (it's been over 7 hours!), but</FONT> <BR><FONT SIZE=2>> I have additional info.</FONT> <BR><FONT SIZE=2>></FONT> <BR><FONT SIZE=2>> V$SQLAREA.Executions is also not reporting the correct count</FONT> <BR><FONT SIZE=2>> in Oracle8i 8.1.6.0.0 on Win2000. It seems that whenever I</FONT> <BR><FONT SIZE=2>> run four sessions of the PL/SQL block that loops through</FONT> <BR><FONT SIZE=2>> 1000 Inserts, one or two of the other Update, Full Table</FONT> <BR><FONT SIZE=2>> Scan, and/or Index Scan sessions don't get counted in</FONT> <BR><FONT SIZE=2>> V$SQLAREA.Executions correctly - grossly undercounted.</FONT> <BR><FONT SIZE=2>></FONT> <BR><FONT SIZE=2>> I'm baffled.</FONT> <BR><FONT SIZE=2>></FONT> <BR><FONT SIZE=2>> Jack</FONT> <BR><FONT SIZE=2>></FONT> <BR><FONT SIZE=2>> ------------------------------------------------------------</FONT> <BR><FONT SIZE=2>></FONT> <BR><FONT SIZE=2>> Subject:</FONT> <BR><FONT SIZE=2>> Date: Thu, 07 Dec 2000 10:00:16 -0600</FONT> <BR><FONT SIZE=2>> Organization: Stonebridge Technologies, Inc.</FONT> <BR><FONT SIZE=2>> To: ORACLE-L_at_fatcity.com</FONT> <BR><FONT SIZE=2>> References: <052569AE.0047AC18.00_at_ho-smtp1.amre.com></FONT> <BR><FONT SIZE=2>></FONT> <BR><FONT SIZE=2>> Hi,</FONT> <BR><FONT SIZE=2>></FONT> <BR><FONT SIZE=2>> Is anyone aware of any problem with V$SQLAREA not showing an accurate count of</FONT> <BR><FONT SIZE=2>> Executions? I ran several concurrent scripts to stress test 8.1.6 on Solaris 8</FONT> <BR><FONT SIZE=2>> Intel. Each script looped for 1000 or 10,000 times, either inserting, updating or</FONT> <BR><FONT SIZE=2>> selecting from a 100,000 row table.</FONT> <BR><FONT SIZE=2>></FONT> <BR><FONT SIZE=2>> V$SQLAREA.Executions incremented for one of the SQL Select statements only about</FONT> <BR><FONT SIZE=2>> 19,000 times when it should have been 40,000. When I ran 4 of those very same</FONT> <BR><FONT SIZE=2>> scripts without all the others, Executions showed the correct 40,000.</FONT> <BR><FONT SIZE=2>></FONT> <BR><FONT SIZE=2>> Under load, does V$SQLAREA not get updated sometimes?</FONT> <BR><FONT SIZE=2>></FONT> <BR><FONT SIZE=2>> Thanks.</FONT> <BR><FONT SIZE=2>></FONT> <BR><FONT SIZE=2>> Jack</FONT> <BR><FONT SIZE=2>></FONT> <BR><FONT SIZE=2>> --</FONT> <BR><FONT SIZE=2>> Jack C. Applewhite</FONT> <BR><FONT SIZE=2>> Senior Consultant, OCP Oracle8 DBA</FONT> <BR><FONT SIZE=2>> Stonebridge Technologies, Inc.</FONT> <BR><FONT SIZE=2>> ...The Fast Track to e-Business.</FONT> <BR><FONT SIZE=2>> (visit us at www.sbti.com)</FONT> <BR><FONT SIZE=2>> Austin, Texas</FONT> <BR><FONT SIZE=2>> 1.512.502.3337</FONT> </P> <P><FONT SIZE=2>--</FONT> <BR><FONT SIZE=2>Jack C. Applewhite</FONT> <BR><FONT SIZE=2>Senior Consultant, OCP Oracle8 DBA</FONT> <BR><FONT SIZE=2>Stonebridge Technologies, Inc.</FONT> <BR><FONT SIZE=2>...The Fast Track to e-Business.</FONT> <BR><FONT SIZE=2> (visit us at www.sbti.com)</FONT> <BR><FONT SIZE=2>Austin, Texas</FONT> <BR><FONT SIZE=2>1.512.502.3337</FONT> </P> <BR> <P><FONT SIZE=2>-- </FONT> <BR><FONT SIZE=2>Please see the official ORACLE-L FAQ: http://www.orafaq.com</FONT> <BR><FONT SIZE=2>-- </FONT> <BR><FONT SIZE=2>Author: Jack C. Applewhite</FONT> <BR><FONT SIZE=2> INET: Jack.Applewhite_at_sbti.com</FONT> </P> <P><FONT SIZE=2>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=2>San Diego, California -- Public Internet access / Mailing Lists</FONT> <BR><FONT SIZE=2>--------------------------------------------------------------------</FONT> <BR><FONT SIZE=2>To REMOVE yourself from this mailing list, send an E-Mail message</FONT> <BR><FONT SIZE=2>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in</FONT> <BR><FONT SIZE=2>the message BODY, include a line containing: UNSUB ORACLE-L</FONT> <BR><FONT SIZE=2>(or the name of mailing list you want to be removed from). You may</FONT>Received on Fri Dec 08 2000 - 14:56:51 CST
 |
 |