1. Database Reference
  2. Static Data Dictionary Views
  3. Static Data Dictionary Views: DBA_STREAMS_ADD_COLUMN to USER_ZONEMAPS
  4. DBA_WI_OBJECTS

6.109 DBA_WI_OBJECTS

Each row in DBA_WI_OBJECTS represents a database object (table) that is accessed by the given template in the given Workload Intelligence job.

Column Datatype NULL Description

JOB_ID

NUMBER

NOT NULL

The identifier of the job in the workload of which the given object has been accessed

TEMPLATE_ID

NUMBER

NOT NULL

The identifier of the template in the given job by which the current object has been accessed

OBJECT_ID

NUMBER

NOT NULL

The identifier of the current object

ACCESS_TYPE

VARCHAR2(2)

NOT NULL

Possible values:

  • R - Indicates that the current object has been accessed for reading by the given template

  • W - Indicates that the current object has been accessed for writing by the given template

  • RW - Indicates that the current object has been accessed for both reading and writing by the given template