You can use the Oracle dbms_stats and export utilities to migrate schema statistics from your PROD instance to your TEST instance, so that your developers…
View More Export Import statistics with dbms_stats in Oracle
Tag: performance
Gather Schema Stats using DBMS_STATS.GATHER_SCHEMA_STATS
DBMS_STATS package was introduced in Oracle 8i and used to gather Database,table,Schema,dictionary and fixed object statistic in Oracle database. Statistic of objects should be up…
View More Gather Schema Stats using DBMS_STATS.GATHER_SCHEMA_STATS
Throughput, latency, concurrency
The difference between making a good and a bad decisions often comes down to the quality of the pre-defined metrics. If the metric is poor…
View More Throughput, latency, concurrency
CURSOR_SHARING(EXACT/FORCE/SIMILAR) In ORACLE
How CURSOR_SHARING works in ORACLE?CURSOR_SHARING determines what kind of SQL statements can share the same cursors. The possible values are EXACT which is the default value and…
View More CURSOR_SHARING(EXACT/FORCE/SIMILAR) In ORACLE
How a single PostgreSQL config change improved slow query performance by 50x
At Amplitude, our goal is to provide easy-to-use interactive product analytics, so everyone can find answers to their product questions. In order to provide a…
View More How a single PostgreSQL config change improved slow query performance by 50x
Query Performance in Postgres
What is Explain? EXPLAIN is a keyword that gets prepended to a query to show a user how the query planner plans to execute the…
View More Query Performance in Postgres
Statistics History restore table old stats in Oracle
Restore old table statistics in Oracle Check and Restore the old statistics of tables in OracleOracle Stats will help the optimizer to choose better execution…
View More Statistics History restore table old stats in Oracle