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