My Oracle Support Banner

High Version Counts In Shared_Pool of Text Queries With CONTAINS Operator (Doc ID 956698.1)

Last updated on MARCH 13, 2019

Applies to:

Oracle Text - Version to [Release 10.2 to 11.1]
Information in this document applies to any platform.
Checked for relevance on 27-Apr-2011


A high version count 2,159 for Text contains() queries is observed from below query or in AWR (SQL Id 079z7y04jyswn in "SQL ordered by Version Count"):

SQL> select inst_id, sql_id, sql_text, version_count,
    loaded_versions, loads, invalidations from gv$sqlarea
    where parsing_schema_name like upper('gs')
    and version_count > 50
    order by sql_id, inst_id ;

 -------- -------------
 ------------- --------------- ---------- -------------
       1 079z7y04jyswn
select *
from gallery
where domain_id = :"SYS_B_0" and launched=:"SYS_B_1"
and ((contains (gallery_name,:"SYS_B_2", :"SYS_B_3") > :"SYS_B_4")
OR (contains (gallery_description,:"SYS_B_5", :"SYS_B_6") > :"SYS_B_7"))
order by published DESC
         2159            2159        2162            27


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.