orapub.com
Home
View Cart
My Account
Help
Training
Register Now!
Schedule
About OraPub Training
Class Pics & Video
Quick Links
Craig's Blog
Technical Papers/Books
Tools / Products
Consulting
Speaker Request
About OraPub
Corporate Giving (for real)
Search OraPub:
Home
>
Technical Papers/Books
>
Oracle Table Compression (Sept-2005)
Our Price:
Free
Availability:
Available for download now
Product Code:
TBLCOMPRESS
Description
It took Oracle more than 20 years to finally develop a compression mechanism to their table structure. The first signs were introduced in version 9, and now in Version 10 it has the minimum functionally to allow us to really consider it.
Using table compression may significantly reduce not only your storage usage but also you memory and CPU usage. Although this feature is best used in Data Warehouse environments, you may want to consider it in your OLTP databases as well. Oracle recommends that you do not use this on a highly changed table or at least do thorough testing.
As with any other option or dilemma that you may encounter during application development, the compression method should be tested in its true environment. My conclusions should never be implemented without thorough testing and you should never assume that someone else knows about your systems more than you do.
Browse for more products in the same category as this item:
Technical Papers/Books
Forecasting data collection script for Oracle and OS (v1.2 03-Sept-2008)
Free
Advanced CPU Forecasting Excel Workbook (1d, 30-July-2008)
Free
Intro to Oracle Performance Diagnosis - Desktop Conf Presentation (Feb 2006)
Free
Hash Text Perl Script (14-Jul-2009)
Free
All About Oracle's In-Memory Undo (06-May-2009) PRESENTATION
Free
Forecasting Oracle Performance Book (Apress)
$25.95