Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!enews.sgi.com!news-out.superfeed.net!propagator2-maxim!feed-maxim.newsfeeds.com!cyclone.bc.net!newsfeed.stanford.edu!postnews1.google.com!not-for-mail
From: srivenu@hotmail.com (srivenu)
Newsgroups: comp.databases.oracle.server
Subject: High Version count in V$SQLAREA
Date: 7 Jul 2003 05:50:58 -0700
Organization: http://groups.google.com/
Lines: 62
Message-ID: <1a68177.0307070450.410a4be1@posting.google.com>
NNTP-Posting-Host: 203.196.224.210
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1057582258 21569 127.0.0.1 (7 Jul 2003 12:50:58 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 7 Jul 2003 12:50:58 GMT
Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:237050

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@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