where to check context index sync status [message #666505] |
Thu, 09 November 2017 04:29 |
|
mvrkr44
Messages: 132 Registered: December 2012
|
Senior Member |
|
|
On : 11.2.0.4 version, RDBMS
Need to get the last execution time and time to took for syncing the CONTEXT index
create table test1(names varchar2(1000));
create index idx_names on test1(names) indextype is ctxsys.context;
insert into test1 values('test record');
commit;
after inserting record i am running the below block.
begin
ctx_ddl.sync_index('idx_names');
end;
/
we are running the above index sync block every one hour .
Now we want to see the Context Index sync status & how much time took to execute the sync index and how many records also?Is there any table /view to check all these tables?
|
|
|
|
|