Why LOADS > EXECUTIONS

From: Feng, Jun <jfeng_at_verisign.com>
Date: Wed, 13 Mar 2002 11:53:44 -0800
Message-ID: <F001.00427C65.20020313115344@fatcity.com>

Hi,

I found that there are some SQL statements in the v$sqlarea. The LOADS is much high than EXECUTIONS. Could anyone give some explanation?

Thanks,

Jun

Here are some examples:

SQL                                           			LOADS

COUNT(*) TotExecs

---------------------------------------- ---------- ---------- ----------
INSERT INTO PERSON_ORG_STATE_HIS ( STATE    	9948398
1     639075
INSERT INTO PERSON_ORG_STATE_HIS ( STATE    	8844933
1     359875
INSERT INTO PERSON_ORG_PROD_INST_XREF (          15
1          7
INSERT INTO PERSON_ORG_ACCOUNT_XREF ( PE    	9200815
1     272364

--

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

Author: Feng, Jun
  INET: jfeng_at_verisign.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). Received on Wed Mar 13 2002 - 13:53:44 CST