Tables to be monitered in ORABPEL schema
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'PC_TASKPAYLOAD';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'WFCOMMENTS';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'DLV_SUBSCRIPTION';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'ATTACHMENT_REF';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'TASK';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'PROCESS_DEFAULT';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'ACTIVITY_SENSOR_VALUES';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'PC_TASK';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'WFMESSAGEATTRIBUTE';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'WFATTACHMENT';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'CUBE_INSTANCE';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'SCOPE_ACTIVATION';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'SYNC_STORE';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'SUITCASE_BIN';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'ATTACHMENT';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'WFTASK';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'PC_TASKATTACHMENT';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'VERSION_SERVER';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'WFROUTINGSLIP';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'WFUSERVACATION';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'WFUSERTASKVIEWGRANT';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'WFUSERPREFERENCE';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'WFTASKTIMER';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'WFNOTIFICATIONMESSAGES';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'DOCUMENT_CI_REF';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'LOAN_CUSTOMER';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'WFNOTIFICATION';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'WI_EXCEPTION';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'NATIVE_CORRELATION';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'FAULT_SENSOR_VALUES';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'PC_OWF';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'PC_TASKASSIGNEE';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'WFATTRIBUTELABELMAP';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'WFUSERTASKVIEW';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'CI_INDEXES';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'SYNC_TRAIL';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'INVOKE_MESSAGE';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'VARIABLE_SENSOR_VALUES';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'BPELPM_ERRORS';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'CUBE_SCOPE';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'XML_DOCUMENT';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'BPELNOTIFICATION';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'ID_RANGE';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'DOMAIN_PROPERTIES';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'PC_TASKHISTORY';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'WFNOTIFICATIONSTATUS';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'WFTASKMETADATA';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'VERSION';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'AUDIT_TRAIL';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'PROCESS';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'TEST_DEFINITIONS';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'DOMAIN';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'PC_TASKASSIGNEEHISTORY';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'WORK_ITEM';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'DLV_MESSAGE';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'DOCUMENT_DLV_MSG_REF';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'PROCESS_DESCRIPTOR';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'PROCESS_LOG';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'SENSOR_SEQUENCE';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'WFTASKHISTORY';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'WFASSIGNEE';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'WFATTRIBUTELABELUSAGE';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'WFTASKDISPLAY';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'AUDIT_DETAILS';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'WFCOMMENTS';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'DLV_SUBSCRIPTION';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'ATTACHMENT_REF';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'TASK';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'PROCESS_DEFAULT';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'ACTIVITY_SENSOR_VALUES';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'PC_TASK';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'WFMESSAGEATTRIBUTE';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'WFATTACHMENT';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'CUBE_INSTANCE';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'SCOPE_ACTIVATION';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'SYNC_STORE';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'SUITCASE_BIN';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'ATTACHMENT';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'WFTASK';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'PC_TASKATTACHMENT';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'VERSION_SERVER';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'WFROUTINGSLIP';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'WFUSERVACATION';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'WFUSERTASKVIEWGRANT';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'WFUSERPREFERENCE';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'WFTASKTIMER';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'WFNOTIFICATIONMESSAGES';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'DOCUMENT_CI_REF';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'LOAN_CUSTOMER';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'WFNOTIFICATION';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'WI_EXCEPTION';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'NATIVE_CORRELATION';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'FAULT_SENSOR_VALUES';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'PC_OWF';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'PC_TASKASSIGNEE';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'WFATTRIBUTELABELMAP';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'WFUSERTASKVIEW';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'CI_INDEXES';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'SYNC_TRAIL';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'INVOKE_MESSAGE';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'VARIABLE_SENSOR_VALUES';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'BPELPM_ERRORS';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'CUBE_SCOPE';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'XML_DOCUMENT';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'BPELNOTIFICATION';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'ID_RANGE';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'DOMAIN_PROPERTIES';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'PC_TASKHISTORY';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'WFNOTIFICATIONSTATUS';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'WFTASKMETADATA';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'VERSION';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'AUDIT_TRAIL';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'PROCESS';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'TEST_DEFINITIONS';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'DOMAIN';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'PC_TASKASSIGNEEHISTORY';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'WORK_ITEM';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'DLV_MESSAGE';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'DOCUMENT_DLV_MSG_REF';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'PROCESS_DESCRIPTOR';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'PROCESS_LOG';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'SENSOR_SEQUENCE';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'WFTASKHISTORY';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'WFASSIGNEE';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'WFATTRIBUTELABELUSAGE';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'WFTASKDISPLAY';
select sum(bytes) from dba_extents where segment_type = 'TABLE' and segment_name = 'AUDIT_DETAILS';
Comments