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: APPLSYS.FND_TS_SIZING

Object Details

Object Name:	FND_TS_SIZING
Object Type:	TABLE
Owner:	APPLSYS
FND Design Data:	FND.FND_TS_SIZING
Subobject Name:
Status:	VALID

This table contains sizing estimates for Objects/schemas, these estimates can be
used in the creation of the new tablespaces accordingly. Also if the PARALLEL
clause with 'alter table move' degrades the performance for very small tables,
this table can indicate cases where it should not be used.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FND_TS_SIZING_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OWNER OBJECT_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
OWNER	VARCHAR2	(30)	Yes	schema name of the database object to be analyzed
OBJECT_TYPE	VARCHAR2	(30)	Yes	Type of the database object to be analyzed (TABLE, INDEX, or CLUSTER)
OBJECT_NAME	VARCHAR2	(30)	Yes	Name of the object name to be analyzed
NEW_TABLESPACE	VARCHAR2	(30)	Yes	Name of the new tablespace where object will resides
OLD_TABLESPACE	VARCHAR2	(30)		Name of the tablespace from where table was moved
PARENT_OBJECT_NAME	VARCHAR2	(30)		Parent of the object (table name for indexes)
CURRENT_EXTENTS	NUMBER			Total number of extents in the object
CURRENT_BYTES	NUMBER			Total number of extents in the object,expressed in bytes
FREE_BYTES	NUMBER			No. of free btyes in object
USED_BYTES	NUMBER			No. of used bytes in object
UNIFORM_EXTENT_SIZE	NUMBER			Extent size for a given tablespace
NUMBER_OF_EXTENTS	NUMBER			Total number of extents required for the object after migrating to new tablespace
TOTAL_BYTES_REQUIRED	NUMBER			Total number of bytes required for the obejct after migrating to new tablespace
SIZING_ERROR_STATUS	VARCHAR2	(30)		Error given by procedure dbms_space.unused_space(error/null)
ERROR_CODE	VARCHAR2	(4000)		Error message given by procedure dbms_space.unused_space
CLASSIFIED	VARCHAR2	(3)		If Object classification available
PARTITIONED	VARCHAR2	(3)		If object has partitions(yes/No)
CREATION_DATE	DATE			generation date of the sizing
ALLOCATION_TYPE	VARCHAR2	(1)		Stores the allocation type for extents

Query Text

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


SELECT OWNER
,      OBJECT_TYPE
,      OBJECT_NAME
,      NEW_TABLESPACE
,      OLD_TABLESPACE
,      PARENT_OBJECT_NAME
,      CURRENT_EXTENTS
,      CURRENT_BYTES
,      FREE_BYTES
,      USED_BYTES
,      UNIFORM_EXTENT_SIZE
,      NUMBER_OF_EXTENTS
,      TOTAL_BYTES_REQUIRED
,      SIZING_ERROR_STATUS
,      ERROR_CODE
,      CLASSIFIED
,      PARTITIONED
,      CREATION_DATE
,      ALLOCATION_TYPE
FROM APPLSYS.FND_TS_SIZING;

Dependencies

[top of page]

APPLSYS.FND_TS_SIZING does not reference any database object

APPLSYS.FND_TS_SIZING is referenced by following:

APPS: FND_TS_SIZING