ER/Studio Model Repository Database Sizing Guide for Oracle

Posted by on in Data Modeling & Architecture

Howdy! 

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]

https://docs.oracle.com/cd/B28359_01/server.111/b28310/tables007.htm

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.



Comments

Check out more tips and tricks in this development video: