High Version count in V$SQLAREA

From: srivenu <srivenu_at_hotmail.com>
Date: 7 Jul 2003 05:50:58 -0700
Message-ID: <1a68177.0307070450.410a4be1@posting.google.com>

Hi,
I would appreciate if someone could explain the following to me. I run Oracle 8.1.7.4 on Sun Solaris 5.8
I was just looking at the V$SQLAREA of the instance and saw the following.

  1 select sql_text,first_load_time,parsing_user_id,version_count,   2 loaded_versions,open_versions,kept_versions,users_opening,   3 users_executing,loads,executions,parse_calls   4 from v$sqlarea
  5* where version_count>100
sys_at_OMPROD> /

                                                   Loa                
Users
                          First              Vers  ded Open Kept Users
  Exe
                          Load       Parse    ion Vers Vers Vers   Ope
  cut       Execu Parse
SQL_TEXT                  Time        User  Count ions ions ions  ning

  ing Loads tions Calls

------------------------- ---------- ----- ------ ---- ---- ---- -----
----- ----- ----- -----
INSERT INTO ASAP.SERV_ITE 2003-06-21     0    110    2    1    0    16

   16 245 ##### 1003
M ( SERV_ITEM_ID,STATUS,F /01:57:19
ROM_EFFECTIVE_DATE,TO_EFF
_DT,ITEM_ALIAS,SERV_ITEM_

TYPE_CD,SPEC_GRP_ID,TRUNK
_SEG,TRUNK_GROUP_DESIGN_I

D,LAST_MODIFIED_DATE,LAST
_MODIFIED_USERID,CREATE_U

SERID,CREATE_DATE,SRC_VER
IFIED_IND,ITEM_ALIAS_SUF,
ACTIVE_IND,CUST_ACCT_ID,I
NT_EXT_CD,CUR_TRBL_IND )
 VALUES ( :b1,1,:b2, NULL
 ,:b3,:b4,:b5,:b6,:b7,:b2
,:b9,:b9,:b2,'Y',:b12,'N'
,:b13,'I','N' )

INSERT INTO ASAP.SERV_REQ 2003-06-21 0 161 2 1 0 16    16 357 ##### 994
_SI ( DOCUMENT_NUMBER,SER /01:57:19

V_ITEM_ID,ITEM_ALIAS,SPEC
_GRP_ID,ACTIVITY_CD,STATU

S,TRUNK_SEG,LAST_MODIFIED
_DATE,LAST_MODIFIED_USERI

D,ITEM_ALIAS_SUF ) VALUE
S ( :b1,ASAP.SQ_SERV_ITEM
.CURRVAL,:b2,:b3,'N',1,:b
4,:b5,:b6,:b7 )

2 rows selected.

The following statements are coming from a client application. Now my question is why are the version counts high for the above statements even though they are using bind variables and no synonyms. thanks in advance
regards
Srivenu Received on Mon Jul 07 2003 - 07:50:58 CDT