question related to v$sqlarea ?

From: <tedchyn_at_yahoo.com>
Date: Thu, 06 May 1999 01:58:10 GMT
Message-ID: <7gqsvh$obk$1@nnrp1.deja.com>

Sir: when I ran following query

select sql_text, loaded_versions, version_count, sharable_mem

   from v$sqlarea where loaded_versions > 3    order by sharable_mem;

SQL_TEXT

---

• LOADED_VERSIONS VERSION_COUNT SHARABLE_MEM --------------- ------------- ------------ SELECT USER FROM SYS.DUAL 4 4 21836

version_count:
number of differnt versions of this cursor. the same sql text might be used by different users, each on their own version of a table.

question:
if this definition is corrected, how do you explain version_count = 4 for sys.dual table ?

Thanks (please respond to tedchyn_at_yahoo.com).

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed May 05 1999 - 20:58:10 CDT