spool all_oco_pend_txn.rslt 

set linesize 120;
set pagesize 1000;
set long 50;
set echo on;
set timing on;

break on "TABLE";

/* ****************************************************** */
/*                                                        */
/*  - Specify the PENDING Trxns of the product.           */
/*     - for use with CONTEXT CARTRIDGES                  */
/*                                                        */
/* ****************************************************** */

set echo on;

/* ******************************* */
/* Tables for Context Services     */
/* ******************************* */

select count(*) from ctxsys.drq_pending;
select count(*) from ctxsys.drq_batches;
select count(*) from ctxsys.drq_waiting;

/* ******************************* */
/* Views for Context Services      */
/* ******************************* */

select count(*) from ctxsys.drq_inprog;

/* ******************************* */
/* Should periodically reorg       */
/*   these tables (ie. truncate)   */
/* ******************************* */

/* truncate table ctxsys.drq_pending; */
/* truncate table ctxsys.drq_batches; */
/* truncate table ctxsys.drq_waiting; */

set echo off;
spool off;
set long 80;
commit;
set timing off;









