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.