Oracle RAC Cache Fusion Reads and Writes
Cache fusion reads occur when a user on one Oracle system queries a block and then a user on another system queries the same block. Learn how to identify causes of this.
Read MoreMost Popular Databases
Exadata Storage Expansion Rack Briefly
Get a quick overview of the Oracle Exadata Storage Expansion Rack added in July, 2011, especially useful for storing petabytes of information.
Read MoreAbout Oracle Hybrid Columnar Compression (11.2)
Oracle hybrid columnar compression can make operations faster because the query runs without decompression. Learn why.
Read MoreTwo Important Oracle Exadata Initialization Parameters
Oracle has two very important parameters to use to test major features of Exadata: CELL_OFFLOAD_PROCESSING and _KCFIS_STORAGEIDX_DISABLED. Learn more.
Read MoreUse Oracle ipcs Command to Determine Shared Memory
The Oracle memory command ipcs command displays the size of each shared memory segment for the SGA. Learn more.
Read MoreInvestigate Oracle Mutex/Latch Waits and/or Sleeps
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 MoreMonitor Activity for SQL Server Integration Services (SSIS)
Performance monitoring for SQL Server Integration Services service (SSIS) includes configuring logging of performance counters. Learn more.
Read MoreSQL Server Integration Services Service (SSIS): An Overview
SQL Server Integration Services (SSIS): An Overview
Read MoreUnderstanding Oracle Bitmap Indexes
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 MoreUnderstanding Oracle Bitmap Join Indexes
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 MoreTop 13 Undocumented Oracle Initialization Parameters
The author shares his list of the top 13 undocumented initialization parameters for Oracle (use with extreme caution). Learn more.
Read MoreInvestigate High Number of Hard Parses in Oracle
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