Even with query tuning, Oracle will still be slow if the parameters for the initialization file aren’t set correctly, and there are a few parameters can lead to significant performance gains.
Read More
Two potential problems to consider when increasing the size of Oracle log files: batch jobs without enough total redo space and long-running jobs spending lots of time switching online redo logs.
Read More
To speed up large numbers of INSERTs, UPDATEs, and DELETEs, increase the sizes of your log files but there are some critical points to consider before you do.
Read More
Row chaining can occur in Oracle when there isn’t enough room in the data blocks to store a single row or the most recent changes to a row, and can impact performance.
Read More
If you need to deal with reorganization because of fragmentation in Oracle, there are several ways to do so while minimizing downtime.
Read More
Partitioned indexes in Oracle have the same advantages as partitioned tables: Improved performance. Learn more.
Read More
Oracle 11g interval partitioning extends the functionality of range partitioning so you can define equal-sized (future) partitions using an interval definition.
Read More
Partitioning can increase performance related to large tables in Oracle. Learn how by considering several examples.
Read More
Learn about best pracitces for Oracle Automatic Storage Manager (ASM) to improve performance and/or increase availability.
Read More
When implemented with Oracle Managed Files or Automatic Storage Management (ASM), Oracle bigfile tablespaces can improve database performance and simplify management of the storage system.
Read More
Disk contention occurs when multiple processes try to access the same physical disk simultaneously. Learn how to avoid disk contention.
Read More
In Oracle 11g, rebuilding indexes online is much faster, and now is also faster than a DROP and CREATE index. Learn more.
Read More