Implementing Oracle Advanced Compression in Windchill Schema
Oracle Advanced Compression provides comprehensive data compression capabilities to compress all types of data, backups, and network traffic in an application transparent manner. With Advanced Compression, Oracle includes table compression targeted at OLTP workloads, resulting in reduced storage consumption and improved query performance while incurring minimal write performance overhead.
Using the Oracle Advanced Compression Option (ACO) requires a separate license on top of the Enterprise Edition database license. It is not included as part of the core database product. Consult with an Oracle sales representative to verify the required licensing information.
You can enable Oracle Advanced Compression on all Windchill schema tables by executing the following script as a Windchill database user at any time after a successful Windchill installation:
<Windchill>/db/sql/oracle/activate_oracle_adv_compression.sql
where <Windchill> is the installed location of your Windchill solution.
You can also selectively activate this feature on specific tables by using the following statement:
ALTER TABLE <TABLE_NAME> MOVE COMPRESS FOR OLTP;
ALTER TABLE MOVE invalidates any indexes on the partition or table; those indexes must be rebuilt using the following statement after executing ALTER TABLE MOVE:
ALTER INDEX <INDEX_NAME> REBUILD;
The following links provide more information on Oracle Advanced Compression: