About Oracle 11gR2 RAC One Node and RAC Patching
Oracle RAC One Node represents an Oracle RAC database that runs only one active Oracle database and can be managed using Server Control Utility (SVRCTL) as any Oracle RAC database.
Read MoreMost Popular Oracle
About Ready-Only Tables in Oracle 11g
Oracle Database 11g now allows you to make a single table read-only without affecting the other tables in the tablespace, and change it back to read-write to allow inserts and updates when needed.
Read MoreAbout Oracle 11g REF Partitioning
Oracle 11g REF partitioning enables partitioning a table based on the foreign key parent-child relationship; in this case, the partitioning key of the child table is inherited from the parent table.
Read MoreAbout Oracle 11gR2 Automatic SQL Tuning
Oracle 11g runs the SQL Tuning Advisor against SQL statements determined to be of high impact based on statistics from the Automatic Workload Repository (AWR).
Read MoreAbout Oracle 11gR2 Advanced Compression
Oracle 11g Advanced Compression offers the promise of tables that take up less space, and lower cost for disk storage for databases. Learn more.
Read MoreBest Practices for Getting the Most from Oracle Exadata
Learn best practices for getting the most from Oracle Exadata for your Oracle 11gR2 database instances.
Read MoreWhat Makes Oracle Exadata So Great
Oracle Exadata hardware combines the power of the database with features Oracle added at the hardware level that other hardware providers can’t replicate easily. Learn more.
Read MoreAbout Oracle RAC Global Cache CR Request Wait Event
Learn how to diganose and tune for Oracle RAC global cache cr request or gc cache cr request wait events.
Read MoreAbout Lock Mastering and Resource Affinity in Oracle RAC
Understand how, in Oracle RAC, the Global Resource Directory (GRD) dynamically remasters resources based on resource affinity, which enhances the performance.
Read MoreUnderstanding Oracle Write Complete Waits
If a session spends a lot of time waiting on the Oracle write complete waits event, it is usually due to a slow I/O subsystem, the MTTR is too short or the DBWR write batch size is too large.
Read MoreUnderstanding Oracle Free Buffer Wait Events
Oracle free buffer waits are caused by inefficient SQL statements, not enough DBWR processes, slow I/O subsystems, delayed block cleanouts and/or small buffer caches.
Read MoreUnderstanding Oracle Log Buffer Space Wait Events
The Oracle log buffer space wait event can indicate that the log buffer in the SGA is too small or the LGWR process is too slow.
Read More