List Database Tables in Agile Product Lifecycle Management (PLM) System (Doc ID 2954757.1)

Scope

This document applies to the following products and versions:

·         Oracle Agile PLM version 9.3.6

·         Oracle Agile PLM version 9.3.1.x, 9.3.2, 9.3.3, 9.3.4, and 9.3.5 with limited support.

 

Note: Agile PLM version 9.3.1.x, 9.3.2, 9.3.3, 9.3.4, and 9.3.5 are in Sustaining Support.  Any issue rising from the execution of the scripts attached to this Knowledge Management (KM) article cannot involve Oracle Development on these versions of the product.  Sustaining Support policy details can be obtained at https://www.oracle.com/us/support/library/057419.pdf 

 

Purpose

Tables are the basic unit of data storage in an Oracle database and they contain all persistent data in the Agile application.  Persistent data includes configuration settings and business specific data making the implementation self-contained.  This allows the database to be replicated in other environments like Development or Quality Assurance (QA) for development and testing purposes.  Metadata associated with these tables are stored in the data dictionary and are essential in determining the size and health of the database.  The script attached to this KM article will list tables in the Agile schema by grouping them in various ways to emphasize usage.  The information gathered by this script will determine if mitigation steps are needed to improve performance and manage storage more efficiently.

 

Note: The script attached to this KM article will not gather any sensitive business data. The information gathered by this script should come from a production system. It will gather only diagnostic information and it is completely safe to run on a production system while the system is in use.