Investigate 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 MoreMost Popular Databases
Checking 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 MoreMisconceptions about the X$ Tables in Oracle 11gR2
There are some misconceptions about the X$ tables in Oracle, ánd it’s important to understand how they work. Learn more.
Read MoreAbout the X$ Tables in Oracle 11gR2
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 MoreOptimizing Parallel Operations in Oracle RAC
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 MoreOracle Performance Comparisons and Monitoring Parallel Operations
Reviewthe performance difference between a nonparallel operation and a parallel operation in Oracle in the example tests in this article.
Read MoreCreate Oracle Table and Index Examples with Parallel Operations
The implementations of parallel operations for table and index creation in Oracle illustrate the application of parallel operations in SQL statements. 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 MoreInternal Workings of the Oracle RAC Systems
With Oracle RAC instances, there are some special processes spawned to coordinate interinstance communication and facilitate resource sharing. Learn more.
Read MoreImplications of PL/SQL Object Location in Oracle
While there is ongoing debate as to where to store Oracle PL/SQL code, generally, the server side is the preferred place. Learn more.
Read More