ER/Studio Model Repository Database Sizing Guide for Oracle
In a previous article, I showcased on how to implement table statistics and Index Re-orgs in SQL Server for the Model Repository.
In today's blog post, I will be showing on how to update table statistics on the ERSRepo Schema for an Oracle database/schema.
It is highly recommended to create a schema for the ER/Studio Model Repository.
[Gather Statistics in Oracle]exec dbms_stats.gather_schema_stats( -ownname => 'SCOTT', -options => 'GATHER AUTO', -estimate_percent => dbms_stats.auto_sample_size, -method_opt => 'for all columns size repeat', -degree => 15 -)
The Oracle online table reorganization package, (dbms_redefinition) is used to reorganize tables while they are accepting updates.
Good Luck! In the next article, I will be showcasing how to perform Database optimization in IBM DB2.
Please login first in order for you to submit comments