oracle ctx_output logging

gistfile1.txt

drop table ctxtest;

create table ctxtest(stuff varchar2(30));

create index tm_cc_tc_item_txt_cat on ctxtest(stuff) indextype is ctxsys.ctxcat;

desc DR$TM_CC_TC_ITEM_TXT_CAT$I

insert into ctxtest(stuff) values (lpad('x', 30 ,'x'));

exec ctx_output.start_log(null)
exec ctx_output.add_event(ctx_output.event_index_print_rowid)

alter session set events 'sql_trace bind=true';
alter index tm_cc_tc_item_txt_cat rebuild;

exec ctx_output.end_log

select DR$TOKEN, length(dr$token) from dr$tm_cc_tc_item_txt_cat$i;

select rowid from ctxtest;

select ctx_report.create_index_script('TC.tm_cc_tc_item_txt_cat') from dual;

select
        payload
from
        v$diag_trace_file_contents
where
        (adr_home, trace_filename) = (
                (
                        (select value from v$diag_info where name = 'ADR Home'),
                        (select substr(value, instr(value,'trace') + 6) from v$diag_info where name = 'Default Trace File')
                )
        )
/