ER/Studio Model Repository Database Sizing Guide for Oracle Database

by Oct 19, 2016



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.

[Tip 1]

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 – )

[Table ReOrg]

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.