검색 결과가 없습니다

검색어와 일치하는 결과가 없습니다

원하시는 정보를 찾는 데 도움이 되도록 다음을 시도해 보십시오.

  • 검색에 사용하신 키워드의 철자가 올바른지 확인하십시오.
  • 입력한 키워드에 동의어를 사용하십시오. 예를 들어 “소프트웨어” 대신 “애플리케이션”을 사용해 보십시오.
  • 아래에 표시된 인기 검색어 중 하나를 사용해 보십시오.
  • 새로운 검색을 시작하십시오.

 

인기 질문

Oracle Advanced Compression

Oracle Advanced Compression

Provides a comprehensive set of compression capabilities to help improve database performance and reduce storage costs. It allows organizations to reduce their overall database storage footprint by enabling compression for all types of data: relational (table), unstructured (file), index, network, Data Guard Redo and backup data. While query performance, storage cost savings and data optimization are often seen as the most tangible benefits, additional innovative technologies can help reduce CapEx and OpEx costs for all components of an IT infrastructure, including memory and network bandwidth as well as heating, cooling and floor-space.

Get the Details

 

 

Reduces Database Storage

The compression ratio achieved in a given environment depends on the data being compressed, specifically the cardinality of the data. In general, organizations can expect to reduce their storage space consumption by a factor of 2x to 4x by using Advanced Row Compression. That is, the amount of space consumed by uncompressed data will be two to four times larger than that of the compressed data.

Improved Query Performance

Advanced Row Compression has no adverse impact on read operations. There is additional work performed while writing data, making it impossible to eliminate performance overhead for write operations. However, Oracle has put in a significant amount of work to minimize this overhead for Advanced Row Compression.

Data Compressed in Memory

The benefits of Advanced Row Compression go beyond just on-disk storage savings. One significant advantage is Oracle’s ability to read compressed blocks directly without uncompressing the blocks. This helps improve performance due to the reduction in I/O, and the reduction in system calls related to the I/O operations. Further, the buffer cache becomes more efficient by storing more data without having to add memory.

Faster RMAN Backup and Recovery

Due to RMAN’s tight integration with Oracle Database, backup data that is already compressed by Advanced Compression remains compressed when it is written to disk or tape and doesn’t need to be uncompressed before recovery – providing an enormous reduction in storage and a potentially large reduction in backup and restore times.

100% Application Transparency

No application changes are required to implement data compression with Advanced Compression.