16 Using Result Set Interface

The CTX_QUERY.RESULT_SET procedure executes an XML or JSON query and generates a result set in XML or JSON.

Note:

• The Oracle Text Result Set Interface queries are not supported on shard catalog instances.

• Complex RSI queries, especially those involving large SDATA, can be long-running. The longer a query runs, the more UNDO data is generated to support consistent read operations. This is because Oracle needs to preserve the data as it was at the start of the query to ensure the query's consistency. On Windows systems, additional factors such as memory management and resource allocation can influence how Oracle manages UNDO. While the exact mechanisms can vary, it's observed that RSI operations on Windows tend to have higher UNDO requirements. This increased demand can lead to ORA-08176 errors if the UNDO configuration is not adequately sized. To mitigate ORA-08176 errors in RSI query workloads on Windows, adjust UNDO Settings. Increase the UNDO_TABLESPACE size or optimize UNDO_MANAGEMENT parameter to accommodate the higher demands from larger SDATA processing.

• Overview of the XML Query Result Set Interface

• Using the XML Query Result Set Interface

• Creating XML-Only Applications with Oracle Text

• Example of a Result Set Descriptor

• Identifying Collocates

• Overview of the JSON Result Set Interface

• Using the JSON Result Set Interface