ER/Studio Model Repository Database Sizing Guide for Oracle

by Mar 16, 2016

ER/Studio Model Repository Database Sizing Guide for Oracle

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.