DBA Data[Home] [Help] [Dependency Information]

TABLE: SYS.WRP$_REPORTS

Object Details
Object Name: WRP$_REPORTS
Object Type: TABLE
Owner: SYS
Subobject Name:
Status: VALID

Storage Details
Tablespace: Tablespace
PCT Free:
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
WRP$_REPORTS_IDX01 NORMAL NONUNIQUE Tablespace ColumnKEY1
ColumnKEY2
ColumnKEY3
WRP$_REPORTS_IDX02 NORMAL NONUNIQUE Tablespace ColumnGENERATION_TIME
ColumnDBID
ColumnCOMPONENT_NAME
ColumnREPORT_ID
Columns
Name Datatype Length Mandatory Comments
SNAP_ID NUMBER

DBID NUMBER

INSTANCE_NUMBER NUMBER

REPORT_ID NUMBER

CON_DBID NUMBER

COMPONENT_ID NUMBER

SESSION_ID NUMBER

SESSION_SERIAL# NUMBER

PERIOD_START_TIME DATE

PERIOD_END_TIME DATE

GENERATION_TIME DATE

COMPONENT_NAME VARCHAR2 (128)
REPORT_NAME VARCHAR2 (128)
REPORT_PARAMS VARCHAR2 (1024)
KEY1 VARCHAR2 (128)
KEY2 VARCHAR2 (128)
KEY3 VARCHAR2 (128)
KEY4 VARCHAR2 (256)
GENERATION_COST NUMBER

REPORT_SUMMARY VARCHAR2 (4000)
SPARE1 NUMBER

SPARE2 NUMBER

SPARE3 NUMBER

SPARE4 VARCHAR2 (4000)
SPARE5 VARCHAR2 (4000)
SPARE6 VARCHAR2 (4000)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SNAP_ID
,      DBID
,      INSTANCE_NUMBER
,      REPORT_ID
,      CON_DBID
,      COMPONENT_ID
,      SESSION_ID
,      SESSION_SERIAL#
,      PERIOD_START_TIME
,      PERIOD_END_TIME
,      GENERATION_TIME
,      COMPONENT_NAME
,      REPORT_NAME
,      REPORT_PARAMS
,      KEY1
,      KEY2
,      KEY3
,      KEY4
,      GENERATION_COST
,      REPORT_SUMMARY
,      SPARE1
,      SPARE2
,      SPARE3
,      SPARE4
,      SPARE5
,      SPARE6
FROM SYS.WRP$_REPORTS;

Dependencies

[top of page]

SYS.WRP$_REPORTS does not reference any database object

SYS.WRP$_REPORTS is referenced by following:

SchemaSYS
Package BodyDBMS_AUTO_REPORT_INTERNAL - show dependent code
ViewINT$DBA_HIST_REPORTS