plmvalet

BEGIN
  SYS.DBMS_SCHEDULER.CREATE_JOB
    (
       job_name        => 'AGILE.OPTIMIZE_ACTIVITY_CTX_IDX'
      ,repeat_interval => 'FREQ = DAILY; BYHOUR = 1; BYMINUTE = 0; BYSECOND = 0'
      ,end_date        => NULL
      ,job_class       => 'DEFAULT_JOB_CLASS'
      ,job_type        => 'PLSQL_BLOCK'
      ,job_action      => 'CTX_DDL.OPTIMIZE_INDEX (IDX_NAME => ''ACTIVITY_CTX_IDX'', OPTLEVEL => ''FULL'', MAXTIME => 60, PARALLEL_DEGREE => 1);'
      ,comments        => 'OPTIMIZE DOMAIN INDEX'

plmvalet

SELECT b.ITEM_NUMBER,
       b.FIND_NUMBER,
	     b.QUANTITY,
       connect_by_root b.COMPONENT as root_item_id,
       CONNECT_BY_ISCYCLE "Cycle",
       level,
       SYS_CONNECT_BY_PATH(b.COMPONENT, '/') "PATH"
FROM BOM_CURRENT_MV b
CONNECT BY NOCYCLE PRIOR b.COMPONENT = b.ITEM and level <= 7
START WITH b.ITEM = (select x.id from agile.item x where x.item_number = 'yourpartnumber');

plmvalet

SELECT b.rowid bom_rowid
, c1.rowid c1_rowid
, c2.rowid c2_rowid
, i.rowid i_rowid
, b.ID
, b.ITEM
, b.ITEM_NUMBER
, b.FIND_NUMBER
, b.QUANTITY
, b.DESCRIPTION

plmvalet

-- How many files are indexed?
select count(*) from files where rowid in (select TEXTKEY from DR$FILES_CONTENT_IDX$K);

-- How many errors?
SELECT * FROM CTX_USER_INDEX_ERRORS WHERE ERR_INDEX_NAME = 'FILES_CONTENT_IDX';

-- Status of all indexes
select idx_name,idx_status from ctx_user_indexes;

-- Which files are indexed? 

plmvalet

-- The following job will run hourly for 55 minutes maximum
BEGIN
DBMS_SCHEDULER.CREATE_JOB ('SYNC_FTS_INDEX',
JOB_TYPE => 'PLSQL_BLOCK',
JOB_ACTION => 'CTX_DDL.SYNC_INDEX (IDX_NAME => ''FILES_CONTENT_IDX'', MEMORY => ''1G'', MAXTIME => 55, PARALLEL_DEGREE => 1);',
REPEAT_INTERVAL => 'FREQ=HOURLY; INTERVAL=1;',
COMMENTS => 'SYNCHRONIZE DOMAIN INDEX RELATING FTS TO ATTACHMENTS',
ENABLED => TRUE
);
END;

plmvalet

--How many files have yet to be indexed?
select count(*) from ctxsys.ctx_pending where pnd_index_name='FILES_CONTENT_IDX';

plmvalet

<appender name="JsonLog" class="org.apache.log4j.RollingFileAppender">
       <param name="File" value="${agile.log.dir}/log.json" />
       <param name="Append" value="true" />
       <param name="MaxFileSize" value="200MB" />
       <param name="MaxBackupIndex" value="5" />
       <layout class="net.logstash.log4j.JSONEventLayoutV1" />
</appender>
 
<category name="com.agile.util.exception" additivity="false">
       <!--  used for agile server logging to capture all unhandled agile exceptions -->