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 More
Bitmap indexes in Oracle are most helpful in a data warehouse environment because they are generally great (fast) when you are only selecting data. Learn more.
Read More
The bitmap join index in Oracle is a lot like building a single index across two tables. You must build a primary key or unique constraint on one of the tables. Learn more.
Read More
The author shares his list of the top 13 undocumented initialization parameters for Oracle (use with extreme caution). Learn more.
Read More
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 More
A low Oracle library cache hit ratio is a symptom of one of several problems. Learn some queries to help you investigate further.
Read More
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 More
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 More
There are some misconceptions about the X$ tables in Oracle, ánd it’s important to understand how they work. Learn more.
Read More
The Oracle X$ tables contain instance-specific information spanning a variety of areas. Learn why interested DBAs keep and use a toolkit of practical X$ table queries that supplement their V$ view queries.
Read More
Parallel operations that can be performed in any scale-up or single-system SMP image environment can also be performed in the scale-out Oracle RAC cluster environment. Learn more.
Read More
Reviewthe performance difference between a nonparallel operation and a parallel operation in Oracle in the example tests in this article.
Read More