The RUN_INSPECTION procedure manually triggers a Root Service self-check for the current tenant to verify the internal metadata consistency. The self-check verifies the following information:
- Integrity of system statistics (sys_stat)
- Integrity of system parameters (sys_param)
- Consistency of system table schemas
- Correctness of data version (data_version)
Limitations and considerations
Both system tenants and user tenants can manually trigger a Root Service self-check for the current tenant.
Syntax
DBMS_SCHEMA.RUN_INSPECTION();
Considerations
The system has a built-in scheduled task SCHEDULED_RUN_INSPECTION that periodically triggers a Root Service self-check with a default interval of 1500 seconds. You can use the repeat_interval attribute of the DBMS_SCHEDULER.SET_ATTRIBUTE procedure to modify the interval. For example, to change the interval of the SCHEDULED_RUN_INSPECTION task to 30 minutes:
obclient(sys@oracle001)[SYS]> CALL DBMS_SCHEDULER.SET_ATTRIBUTE('SCHEDULED_RUN_INSPECTION', 'repeat_interval', 'FREQ=SECONDLY; INTERVAL=1800');
If the scheduled task has not reached its execution time, you can manually call the DBMS_SCHEMA.RUN_INSPECTION() procedure to quickly trigger a Root Service self-check.
Examples
A user tenant triggers a Root Service self-check for the current tenant.
obclient(sys@oracle001)[SYS]> CALL DBMS_SCHEMA.RUN_INSPECTION();