[Home] [Help] [Dependency Information]
Object Name: | EDW_SIZE_OUTPUT |
---|---|
Object Type: | TABLE |
Owner: | BIS |
FND Design Data: | BIS.EDW_SIZE_OUTPUT |
Subobject Name: | |
Status: | VALID |
Table for EDW size output
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TABLE_NAME | VARCHAR2 | (70) | Yes | comment |
OWNER | VARCHAR2 | (30) | Yes | comment |
TABLE_TYPE | VARCHAR2 | (30) | Yes | comment |
TABLE_LOGICAL_NAME | VARCHAR2 | (240) | Yes | comment |
AVG_ROW_LEN_STAGE | NUMBER | comment | ||
AVG_ROW_LEN_LEVEL | NUMBER | comment | ||
AVG_ROW_LEN | NUMBER | average row length of the table | ||
AVG_ROW_LEN_IND_S | NUMBER | average row length of indexes of staging tables | ||
AVG_ROW_LEN_IND_L | NUMBER | average row length of indexes of level tables | ||
AVG_ROW_LEN_IND | NUMBER | Average row length of indexes of the table | ||
NUM_ROWS | NUMBER | comment | ||
TABLE_SIZE_STAGE | NUMBER | size of the staging tables | ||
INDEX_SIZE_STAGE | NUMBER | size of indexes of staging tables | ||
TABLE_SIZE_LEVEL | NUMBER | size of level tables | ||
INDEX_SIZE_LEVEL | NUMBER | size of indexes of level tables | ||
TABLE_SIZE | NUMBER | size of the tables | ||
INDEX_SIZE | NUMBER | Size of indexes of the table | ||
TEMP_SIZE | NUMBER | Temporary processing size | ||
RB_SIZE | NUMBER | Size of rollback segments | ||
TEMP_TABLE_SIZE | NUMBER | size of temporary operation tables | ||
TEMP_SIZE_SOURCE | NUMBER | Temporary size needed on source side for processing and tables | ||
TOTAL_PEM_SPACE | NUMBER | Total size needed to store tables and indexes | ||
TOTAL_TMP_SPACE | NUMBER | Total temporary space involved in warehouse side | ||
PCT_FREE_S | NUMBER | Percent free for staging tables | ||
PCT_FREE_L | NUMBER | Percent free for level tables | ||
PCT_FREE | NUMBER | Percent free for table itself | ||
FROM_DATE | DATE | beginning date range to estimate the row count and average row length | ||
TO_DATE | DATE | ending date range to estimate the row count and average row length | ||
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
Cut, paste (and edit) the following text to query this object:
SELECT TABLE_NAME
, OWNER
, TABLE_TYPE
, TABLE_LOGICAL_NAME
, AVG_ROW_LEN_STAGE
, AVG_ROW_LEN_LEVEL
, AVG_ROW_LEN
, AVG_ROW_LEN_IND_S
, AVG_ROW_LEN_IND_L
, AVG_ROW_LEN_IND
, NUM_ROWS
, TABLE_SIZE_STAGE
, INDEX_SIZE_STAGE
, TABLE_SIZE_LEVEL
, INDEX_SIZE_LEVEL
, TABLE_SIZE
, INDEX_SIZE
, TEMP_SIZE
, RB_SIZE
, TEMP_TABLE_SIZE
, TEMP_SIZE_SOURCE
, TOTAL_PEM_SPACE
, TOTAL_TMP_SPACE
, PCT_FREE_S
, PCT_FREE_L
, PCT_FREE
, FROM_DATE
, TO_DATE
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
FROM BIS.EDW_SIZE_OUTPUT;
BIS.EDW_SIZE_OUTPUT does not reference any database object
BIS.EDW_SIZE_OUTPUT is referenced by following:
|
|
|