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

TABLE: AMS.AMS_ACT_SIZES

Object Details
Object Name: AMS_ACT_SIZES
Object Type: TABLE
Owner: AMS
FND Design Data: TableAMS.AMS_ACT_SIZES
Subobject Name:
Status: VALID


This table maintains the history of segments size.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AMS_ACT_SIZES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnACTIVITY_SIZE_ID
Columns
Name Datatype Length Mandatory Comments
ACTIVITY_SIZE_ID NUMBER
Yes Activity size identifier
LAST_UPDATE_DATE DATE
Yes Standard WHO Column
LAST_UPDATED_BY NUMBER
Yes Standard WHO Column
CREATION_DATE DATE
Yes Standard WHO Column
CREATED_BY NUMBER

Standard WHO Column
LAST_UPDATE_LOGIN NUMBER

Standard WHO Column
ACT_SIZE_USED_BY_ID NUMBER
Yes Act size used by identifier
ARC_ACT_SIZE_USED_BY VARCHAR2 (30) Yes Column records the kind of object
ACT_SIZE NUMBER
Yes Activity size
DESCRIPTION VARCHAR2 (2000)
Activity description
SECURITY_GROUP_ID NUMBER

Used in hosted environments
SIZE_DELTA NUMBER

Segment refresh program stores segment size delta each time when it is refreshed in this column
Query Text

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


SELECT ACTIVITY_SIZE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ACT_SIZE_USED_BY_ID
,      ARC_ACT_SIZE_USED_BY
,      ACT_SIZE
,      DESCRIPTION
,      SECURITY_GROUP_ID
,      SIZE_DELTA
FROM AMS.AMS_ACT_SIZES;

Dependencies

[top of page]

AMS.AMS_ACT_SIZES does not reference any database object

AMS.AMS_ACT_SIZES is referenced by following:

SchemaAPPS
SynonymAMS_ACT_SIZES