eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: BIS.EDW_SIZE_OUTPUT

Object Details

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

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

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).

Query Text

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;

Dependencies

[top of page]

BIS.EDW_SIZE_OUTPUT does not reference any database object

BIS.EDW_SIZE_OUTPUT is referenced by following:

APPS: EDW_SIZE_OUTPUT