Best Setting for Oracle DB_BLOCK_SIZE
The Oracle DB_BLOCK_SIZE is the default data block size when the database is created. A separate cache memory allocation must be made for each different database block size, and choose wisely.
Read MoreMost Popular Oracle 11g
How to Identify Crucial Initialization Parameters in Oracle
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 MoreHow to Determine If the Oracle Redo Log File Size Is a Problem
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 MoreSpeed Oracle by Increasing the Log File Size
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 MoreAvoid Chaining in Oracle by Setting PCTFREE Correctly
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 MoreFragmentation in Oracle 11gR2–Myths and Realities
If you need to deal with reorganization because of fragmentation in Oracle, there are several ways to do so while minimizing downtime.
Read MoreAbout Index Partitioning in Oracle 11gR2
Partitioned indexes in Oracle have the same advantages as partitioned tables: Improved performance. Learn more.
Read MoreAbout Interval Partitioning in Oracle 11gR2
Oracle 11g interval partitioning extends the functionality of range partitioning so you can define equal-sized (future) partitions using an interval definition.
Read MoreAvoiding Oracle Disk Contention by Using Partitions
Partitioning can increase performance related to large tables in Oracle. Learn how by considering several examples.
Read MoreOracle ASM and Database Deployment Best Practices
Learn about best pracitces for Oracle Automatic Storage Manager (ASM) to improve performance and/or increase availability.
Read MoreWhy Use Oracle Bigfile Tablespaces?
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 MoreAvoiding I/O Disk Contention in Oracle 11gR2
Disk contention occurs when multiple processes try to access the same physical disk simultaneously. Learn how to avoid disk contention.
Read More