소소한 일상에서 책읽기 중

Updating tables with Oracle 11g compression Oracle 11g compression has been heralded as a great Oracle tuning tool that does far more than reduce disk usage. It also packs the rows more tightly on the data blocks, making it faster for SQL. See my important notes here on 11g table compression. Some unknown issues (as of September 2007) with implementing Oracle11g data compression include the amou..

source: dba-oracle.com Column oriented data storage for Oracle In traditional relational theory, the internal representation of the data on the physical blocks is not supposed to matter, but in the real world, the placement of the data on blocks is critical. Oracle provides tools like sorted hash clusters to group related rows together and row-sequencing can dramatically improve the performance ..

11g Data Compression - too much overhead? Oracle 11g data compression promises some amazing saving in disk storage as well as important performance improvements. Please read my notes on the benefits of Oracle 11g data compression: - Oracle 11g Data Compression Tips Tests show that 11g compression result is slower transaction throughput but creates less writes because of higher row density on the..

Oracle 11g Data Compression Tips for the Database Administrator Oracle 11g Tips by Burleson Consulting These is an excerpt from the book "Oracle 11g New Features". Tests show that 11g compression result is slower transaction throughput but creates less writes because of higher row density on the data block. See this benchmark of transparent data encryption. While it is true that data storage pri..