Always Update: The Importance of Updating Sybase Statistics
Out-of-date statistics can cause unexplained poor database performance. Learn why this happens, and how to keep your statistics current.
Read MoreMost Popular Performance Tuning
Understanding How the SQL Server Resource Governor Works
The SQL Server Resource Governor enables DBAs to define resource limits and priorities for different workloads to help make performance consistent. Learn more.
Read MoreFast and Accurate Oracle Root Cause Analysis
Learn about the kind of information and tools you need to effectively perform root cause analyses of Oracle database performance problems, and why Trace Event 10046 and Oracle Statspak aren’t sufficient.
Read MoreInvestigate Oracle Mutex/Latch Waits and/or Sleeps
If Oracle mutex or latch waits are high but shared and Java pool freespace is also high, it could indicate that sessions are spending time scanning the unnecessarily large list of free shared pool chunks. Learn more.
Read MoreInvestigate High Number of Hard Parses in Oracle
A high ratio of hard parses in Oracle may mean that the shared pool itself is too small or a SQL statement is nudging other code out of the precious shared pool or Java pool cache space. Learn more.
Read MoreInvestigate the Oracle Library Cache Hit Ratio
A low Oracle library cache hit ratio is a symptom of one of several problems. Learn some queries to help you investigate further.
Read MoreChecking for Shared Pool Fragmentation in Oracle
If you suspect the Oracle shared pool may be fragmented you can take a closer look at the shared pool using the queries in this article.
Read MoreChecking for ORA-04031 Errors in Oracle
ORA-04031 errors may indicate that SHARED_POOL_SIZE and/or JAVA_POOL_SIZE are too small, the shared pool is fragmented, or application code may not be being shared optimally. Learn more.
Read MoreManage Oracle Parallel Server Resources and Statement Queueing
In Oracle, you configure the allocation of parallel server resources for a consumer group with the PARALLEL_TARGET_PERCENTAGE directive. Learn more.
Read MoreBasic Concepts of Parallel Operations in Oracle
Although there are some overhead costs and administrative requirements, using parallel operations in Oracle can improve the performance of many queries. Learn more.
Read MoreImprove Oracle Performance by Reducing Calls to SYSDATE
Calls to the Oracle variable SYSDATE, though convenient, involve some overhead, and should be reduced where possible. Learn more.
Read MoreReduce PL/SQL Program Unit Iterations in Oracle
Any Oracle PL/SQL program unit involving looping logic is a strong candidate for performance improvements, and there are several ways to accomplish this. Learn more.
Read More