wew

[Yustus]

3.3.2. Indexing data in daily tablespaces

You can perform context search over the text of intercepted objects, only if the database indexes the incoming date regularly. Reindexing starts every 10 minutes by default.

Note:

You can stop or launch the job manually, if necessary (see i. on page 19).

Correctness of the data indexing job (the absence of deadlocks) can be verified by running the following query on behalf of the owner of the database schema:

23

select t.REQ_START_DATE, t.actual_start_date, t.RUN_DURATION

from sys.user_scheduler_job_run_details t

where t.job_name='IWTM_SYNC_INDEXES' and t.LOG_DATE > sysdate - 3/24

According to the results of this query the information on the data indexing job for the last 3 hours is displayed. If the interval of indexing did not change, then the task should run every 10 minutes and be performed in less than 10 minutes. At heavy load of the database this verification should be performed periodically, at intervals of sev-eral hours.

The change of indexing interval

Note:

The context search by incoming objects is available only after the objects are indexed. You must take this feature into account when changing the interval between the reindexing procedures.

To change the interval of indexing, run the script:

DECLARE

v_start_date date;

v_repeat_interval VARCHAR2(100);

BEGIN

v_start_date := SYSDATE;

v_repeat_interval := 'FREQ=MINUTELY; INTERVAL=10';

dbms_scheduler.set_attribute('IWTM_SYNC_INDEXES','START_DATE', v_start_date);

dbms_scheduler.set_attribute('IWTM_SYNC_INDEXES','REPEAT_INTERVAL', v_repeat_interval);

COMMIT;

END;

where:

 v_start_date – date and time of launching the job. Specified in any date format, supported by the Ora-cle DBMS.

 v_repeat_interval – frequency of job starting. Is defined by the settings:

FREQ. The dimension of job run frequency. The following values are allowed: DAILY, WEEKLY, MONTHLY, HOURLY, MINUTELY.

INTERVAL. Value of the frequency with the selected dimension. Integer values from 1 to 99 are al-lowed.

Some examples of using the script are provided below.

Example 1. Reindexing starts once a minute

DECLARE

v_start_date date;

v_repeat_interval VARCHAR2(100);

BEGIN

v_start_date := SYSDATE;

v_repeat_interval := 'FREQ=MINUTELY; INTERVAL=1';

dbms_scheduler.set_attribute('IWTM_SYNC_INDEXES','START_DATE', v_start_date);

dbms_scheduler.set_attribute('IWTM_SYNC_INDEXES','REPEAT_INTERVAL', v_repeat_interval);

COMMIT;

END;

Example 2. Reindexing starts once every two hours

DECLARE

v_start_date DATE;

v_repeat_interval VARCHAR2(100);

BEGIN

v_start_date := SYSDATE;

v_repeat_interval := 'FREQ= HOURLY; INTERVAL=2';

dbms_scheduler.set_attribute('IWTM_SYNC_INDEXES','START_DATE', v_start_date);

dbms_scheduler.set_attribute('IWTM_SYNC_INDEXES','REPEAT_INTERVAL', v_repeat_interval);

COMMIT;

END;