Oracle-L: Re: Number of SQL stmts.

From: Anjo Kolk <anjo_at_oraperf.com>
Date: Wed, 19 Feb 2003 10:58:54 -0800
Message-ID: <F001.00551AC5.20030219105854@fatcity.com>

MessageThere is a difference between the number of statements and the total number of executes. So you can have total statements 1 (unlikely) and total executes 1000000.

Anjo.

Original Message ----- From: Terrian, Tom To: Multiple recipients of list ORACLE-L Sent: Tuesday, August 20, 2002 5:38 PM Subject: Number of SQL stmts.

All,

I am trying to determine the number of sql statements issued against my databases. Does anyone know if the "execution count" in v$sysstat is the number of sql statements issued against the database? I know that this is a cumulative number from when the database was last bounce, but it still seems very high. Does this really show me the number of statements issued since the last bounce?

Thanks,
Tom

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Anjo Kolk
INET: anjo_at_oraperf.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

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). Received on Wed Feb 19 2003 - 12:58:54 CST