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: CZ.CZ_DB_SIZES

Object Details

Object Name:	CZ_DB_SIZES
Object Type:	TABLE
Owner:	CZ
FND Design Data:	CZ.CZ_DB_SIZES
Subobject Name:
Status:	VALID

This table is used to hold record counts in the Oracle Configurator tables in order to record and assess dataset sizes.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CZ_DB_SIZE_PK	NORMAL	UNIQUE	APPS_TS_SUMMARY	RUN_ID TABLE_NAME METRIC_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
RUN_ID	NUMBER	(9)	Yes	Run in which this count was recorded
TABLE_NAME	VARCHAR2	(50)	Yes	Name of the table for which this record provides a count
SET_ID	NUMBER	(9)		Identifies to which partitioning of table records this record-count applies
METRIC_NAME	VARCHAR2	(50)	Yes	PK. Identifies the type of entity that is being counted
REC_STATUS	VARCHAR2	(4)	Yes	Coded description of the import status of this record; 'OK' indicates success
RECORD_COUNT	NUMBER	(9)	Yes	Reports the number of records counted with the given characteristics
DATE_CREATED	DATE		Yes	Date on which this record was created
METRIC_DESC	VARCHAR2	(255)		More detail on this metric

Query Text

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


SELECT RUN_ID
,      TABLE_NAME
,      SET_ID
,      METRIC_NAME
,      REC_STATUS
,      RECORD_COUNT
,      DATE_CREATED
,      METRIC_DESC
FROM CZ.CZ_DB_SIZES;

Dependencies

[top of page]

CZ.CZ_DB_SIZES does not reference any database object

CZ.CZ_DB_SIZES is referenced by following:

APPS: CZ_DB_SIZES