slide1 n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
<Insert Picture Here> PowerPoint Presentation
Download Presentation
<Insert Picture Here>

Loading in 2 Seconds...

play fullscreen
1 / 15

<Insert Picture Here> - PowerPoint PPT Presentation


  • 82 Views
  • Uploaded on

&lt;Insert Picture Here&gt;. Oracle Database 11g Advanced Compression Option. Challenges. Explosion in data volume managed by Enterprises Government regulations (Sarbanes-Oxley, HIPPA, etc) User generated content (Web 2.0)

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about '<Insert Picture Here>' - clarke


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
slide1

<Insert Picture Here>

Oracle Database 11g

Advanced Compression Option

challenges
Challenges
  • Explosion in data volume managed by Enterprises
    • Government regulations (Sarbanes-Oxley, HIPPA, etc)
    • User generated content (Web 2.0)
  • IT managers must support larger volumes of data with limited technology budgets
    • Need to optimize storage consumption
    • Also maintain acceptable application performance
  • Intelligent and efficient compression technology can help address these challenges
introducing advanced compression option

Redo logs

Standby

Backups

Introducing Advanced Compression Option
  • Oracle Database 11g introduces a comprehensive set of compression capabilities
    • Structured/Relational data compression
    • Unstructured data compression
    • Compression for backup data
    • Network transport compression
  • Reduces resource requirements and costs
    • Storage System
    • Network Bandwidth
    • Memory Usage
table compression
Table Compression
  • Introduced in Oracle9i Release 2
    • Supports compression during bulk load operations (Direct Load, CTAS)
    • Data modified using conventional DML not compressed
  • Optimized compression algorithm for relational data
  • Improved performance for queries accessing large amounts of data
    • Fewer IOs
    • Buffer Cache efficiency
  • Data is compressed at the database block level
    • Each block contains own compression metadata – improves IO efficiency
    • Local symbol table dynamically adapts to data changes
  • Compression can be specified at either the table or partition levels
  • Completely transparent to applications
  • Noticeable impact on write performance
oltp table compression
OLTP Table Compression
  • Oracle Database 11g extends compression for OLTP data
    • Support for conventional DML Operations

(INSERT, UPDATE, DELETE)

  • New algorithm significantly reduces write overhead
    • Batched compression ensures no impact for most OLTP transactions
  • No impact on reads
    • Reads may actually see improved performance due to fewer IOs and enhanced memory efficiency
oltp table compression1

Overhead

Free Space

Uncompressed

Compressed

OLTP Table Compression

Inserts are again uncompressed

Block usage reaches PCTFREE – triggers Compression

Inserts are uncompressed

Block usage reaches PCTFREE – triggers Compression

  • Adaptable, continuous compression
  • Compression automatically triggered when block usage reaches PCTFREE
  • Compression eliminates holes created due to deletions and maximizes contiguous free space in block
oltp table compression2

ID

FIRST_NAME

LAST_NAME

1

John

Doe

2

Jane

Doe

3

John

Smith

4

Jane

Doe

OLTP Table Compression

Initially Uncompressed Block

Employee Table

Header

1•John•Doe 2•Jane• Doe 3•John•Smith4• Jane • Doe

Free Space

INSERT INTO EMPLOYEE

VALUES (5, ‘Jack’, ‘Smith’);

COMMIT;

oltp table compression3

Compressed Block

John=|Doe=|Jane=|Smith=

ID

FIRST_NAME

LAST_NAME

1•• 2•• 3•• 4 •  •  5•Jack•

Free Space

1•John•Doe 2•Jane• Doe 3•John•Smith4• Jane • Doe

Free Space

1

John

Doe

2

Jane

Doe

3

John

Smith

4

Jane

Doe

5

Jack

Smith

OLTP Table Compression

Employee Table

Block

Header

Local

Symbol Table

oltp table compression4

Compressed Block

John=|Doe=|Jane=|Smith=

1•• 2•• 3•• 4 •  •  5•Jack•

Free Space

1•John•Doe 2•Jane• Doe 3•John•Smith4• Jane • Doe

Free Space

OLTP Table Compression

Uncompressed Block

Header

Header

1•John•Doe 2•Jane• Doe 3•John•Smith4• Jane • Doe 5•Jack •Smith Free Space

Local

Symbol Table

More Data

Per Block

using oltp table compression
Using OLTP Table Compression
  • Requires database compatibility level at 11.1 or greater
  • New Syntax extends the ‘COMPRESS’ keyword
    • COMPRESS [FOR {ALL | DIRECT_LOAD} OPERATIONS]
    • DIRECT_LOAD (DEFAULT)
      • Refers to Bulk load operations from 10g and prior releases
    • ALL
      • OLTP + Direct loads
  • Enable OLTP compression for new table t1

CREATE TABLE t1 COMPRESS FOR ALL OPERATIONS

  • Enable only direct load compression on existing table

ALTER TABLE t2 COMPRESS

    • Only new rows are compressed, existing rows are uncompressed
securefiles deduplication
SecureFiles - Deduplication
  • Enables storage of a single physical image for duplicate data
  • Significantly reduces space consumption
  • Dramatically improves writes and copy operations
  • No adverse impact on read operations
    • May actually improve read performance for cache data
  • Duplicate detection happens within a table, partition or sub-partition
  • Specially useful for content management, email applications and data archival applications

Secure hash

securefiles compression
SecureFiles - Compression
  • Huge storage savings
    • Industry standard compression algorithms
    • 2-3x compression for typical files (doc, pdf, xml)
    • Minimal CPU overhead during compression
  • Automatically detects if SecureFile data is compressible
    • Skips compression for already compressed data
    • Auto-turn off compression when space savings are minimal or zero
  • Two levels of compression provide different compression ratios
    • Compression Levels:MEDIUM (default), HIGH
    • Higher the degree of compression, higher the latency and CPU overhead incurred
  • SecureFiles Compression is independent of table or index compression
  • Server-side compression
    • Allows for random reads and writes to SecureFile data
    • Can be specified at a partition level
data pump compression
Data Pump Compression
  • Metadata compression available since Oracle Database 10g
  • Oracle Database 11g extends compression to table data during exports
    • No need to decompress before import
  • Single step compression of both data and metadata
    • Compressed data directly hits disk resulting in reduced disk space requirements
    • 75% reduction in dump file size on export of sample OE and SH schemas
  • Compression factor comparable to GNU gzip utility
  • Application transparent
    • Complete Data Pump functionality available on compressed files
backup data and network transport compression
Backup data and Network transport Compression
  • Fast RMAN Compression
    • Compresses the backup set contents before writing them to disk or tape
    • No extra decompression steps are required during recovery when you use RMAN compression.
    • High performance, industry standard compression algorithm
      • 40% faster backup compression versus Oracle Database 10g
    • Suitable for fast, incremental daily backups
    • Reduces network usage
  • Data Guard Network Compression
    • Compression of redo traffic over the network during redo gap resolution
      • Improves redo transport performance
      • Gap resolution is up to 2x faster
summary
Summary
  • Advanced Compression Option contains comprehensive data compression capabilities for all types of data
    • Structured, Unstructured, Backup, Network Transport
  • Reduces storage consumption by 2 to 3 times
  • Improves read performance
  • Enhances memory, buffer cache utilization
  • Complete application transparency
  • Benefits diverse application workloads