Home » Server Options » Text & interMedia » where to check context index sync status (oracle 12c)
where to check context index sync status [message #666505] Thu, 09 November 2017 04:29 Go to previous message
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?

 
Read Message
Read Message
Read Message
Previous Topic: Matching query
Next Topic: Need to get the one specific record with 's
Goto Forum:
  


Current Time: Thu Mar 28 17:23:47 CDT 2024