Search Results sys_lob

Overview

FND_TS_SIZE is an Oracle E-Business Suite database package owned by the APPS schema that supports tablespace sizing and capacity planning within the EBS environment. Its primary business function is to compute storage requirements for database objects—tables, indexes, and their partitions—and to record the resulting sizing information for administrative analysis. The package body constructs sizing projections based on current segment statistics and object attributes, then persists those figures into the FND_TS_SIZING repository. Within EBS 12.1.1 and 12.2.2, this capability underpins the tablespace management and space-planning features used by system administrators and database administrators responsible for maintaining the APPLSYSPUB, APPS_TS_TX_DATA, APPS_TS_QUEUES, and related tablespaces.

Key Procedures and Functions

The documented package exposes four primary routines, plus supporting internal logic.

• GEN_TAB_SIZING — Generates sizing estimates for a designated table, evaluating its storage attributes and segment characteristics to project space consumption.
• GEN_IND_SIZING — Produces sizing estimates for a designated index, accounting for its partitions where applicable.
• GEN_ALL_TAB_SIZING — Iterates across the registered set of tables to produce comprehensive sizing projections for all qualifying table objects.
• GEN_ALL_IND_SIZING — Iterates across indexes to produce comprehensive sizing projections for all qualifying index objects.

The body also includes internal helpers such as get_tsp_name, which resolves a tablespace name from FND_TABLESPACES given a tablespace type, and ins_fnd_ts_sizing, which inserts computed sizing rows into the FND_TS_SIZING table. A private record type captures owner, table name, tablespace name, object classification, partitioning status, and related object attributes. Notably, the source contains explicit handling for SYS_IL segment names. The code inspects the prefix of the object name to differentiate LOB segments (SYS_LOB) from LOB indexes (SYS_IL), and where the object is partitioned, assigns an object type of "LOB INDEX PARTITION"; otherwise it classifies the object as a LOB index. This matters because a search for "sys_il" in the EBS schema typically surfaces internal LOB index segments created by Oracle for LOB columns, and FND_TS_SIZE is one of the few EBS packages that deliberately recognizes and sizes these segments rather than ignoring them.

Tables Accessed

The package reads and writes several APPS synonyms and data dictionary views. FND_TABLESPACES supplies the tablespace-to-type mapping used by get_tsp_name. FND_OBJECT_TABLESPACES and FND_TS_SIZING store sizing configuration and results respectively, with FND_TS_SIZING receiving the output of ins_fnd_ts_sizing. FND_ORACLE_USERID identifies Oracle user accounts associated with the environment. Source segment and object facts are drawn from DBA_SEGMENTS, DBA_TABLES, DBA_TAB_PARTITIONS, DBA_INDEXES, DBA_IND_PARTITIONS, DBA_LOBS, DBA_LOB_PARTITIONS, DBA_EXTERNAL_TABLES, DBA_QUEUE_TABLES, DBA_SNAPSHOTS, and DBA_SNAPSHOT_LOGS. These views classify objects—including LOB indexes such as SYS_IL segments—and provide the byte and extent figures on which the sizing calculations depend.

Usage Notes

FND_TS_SIZE is typically invoked from concurrent programs and administrative utilities rather than interactive forms. Administrators run tablespace sizing programs to refresh the FND_TS_SIZING data before reviewing growth reports or planning tablespace expansion. Custom code may call the individual GEN_* routines for targeted analysis of a single table or index. Because the package relies on DBA_* dictionary views, the executing user requires elevated privileges, which is why the package is owned by APPS and marked with an API classification of OTHER rather than exposed as a public API. No other packages in the documented metadata reference FND_TS_SIZE, indicating it is a leaf-level utility invoked directly rather than through a dependency chain.