In the old days, when I started messing around with computers for fun as a young geek guy, computer security was pretty simple. In those times we were using 8 or 16-bit PC’s with MS-DOS (for the poor guys) or,…
Duplexing Oracle Redo logs?
A customer asked me recently what EMC’s advice is regarding duplexing Oracle redo logs. There is a thought behind this – Oracle redo logs are sensitive to data corruption – if redo logs are corrupt, there is no way to…
Pinpointing I/O bottlenecks on Linux
Does this story sound familiar? The end users of a database application start complaining about poor system response and long running batch jobs. The DBA team starts investigating the problem. DBA’s look at their database tools such as Enterprise Manager,…
How to set disk alignment in Linux
As you might know, if disk partitions containing Oracle datafiles are not aligned with the underlying storage system, then some I/O’s can suffer from some overhead as they are effectively translated in two I/O’s. If you want more info, google…
How does Oracle keep data consistent on filesystems?
Sometimes there is questioning on how EMC can provide consistent snapshots on storage systems, given the fact that file systems like ext3, ufs and the like may keep write data in file system (server) cache.