C Oracle Ultra Search Views

This appendix lists all of the views provided by Oracle Ultra Search. The system provides the following views:

C.1 OUS_INSTANCES

This view displays all instance information. Any user can query it.

Column Name	Type	Description
`INS_ID`	`NUMBER`	Instance ID
`INS_NAME`	`VARCHAR2(100)`	Instance name
`INS_SCHEMA`	`VARCHAR2(30)`	Instance owner
`INS_MODE` `ONLY`	`VARCHAR2(30)`	Instance mode; `UPDATABLE`/`READ`

This view displays schedule data for the current instance.

Column Name	Type	Description
`SCH_ID`	`NUMBER`	Schedule ID
`SCH_NAME`	`VARCHAR2(100)`	Schedule name
`SCH_INTERVAL`	`VARCHAR2(30)`	Schedule interval
`SCH_LAST_RUN`	`DATE`	Time stamp of last run
`SCH_NEXT`	`DATE`	Next scheduled execution
`SCH_STATUS`	`VARCHAR2(100)`	Schedule status
`SCH_ERROR`	`VARCHAR2(4000)`	Schedule error if failed
`SCH_CRAWLER_LOG_NAME`	`VARCHAR2(100)`	Log file name of current running crawler
`SCH_CRAWLER_ID`	`NUMBER`	ID of the crawler to execute this schedule
`SCH_FORCE_RECRAWL`	`NUMBER`	Force recrawl of the data source
`SCH_CRAWL_HOME`	`VARCHAR2(30)`	Schedule crawling mode

This view shows default crawler settings like crawling depth and log file directory.

Column Name	Type	Description
`DCS_NAME`	`VARCHAR2(30)`	Crawler setting name
`DCS_VALUE`	`VARCHAR2(4000)`	Crawler setting value

This view shows crawler setting at the data source level for the current instance.