• About
  • All Posts
  • The Podcast!
  • Playlists
  • Golden Oldies
Skip to content

Learning is not a spectator sport

  • 30 second guide to India
  • About
  • Archives
  • Golden Oldies
    • First match
    • Smart DBA
  • Playlists
  • The Podcast!

Tag: compression

October 2, 2020 Uncategorized

Compression default settings

If you are loading a data warehouse or similar environment where your default approach would probably be to compress all

Continue reading

May 1, 2020 Uncategorized

Free In-memory in Oracle Database 19c

There has always been a bit of a Catch-22 with some of the really cool options in the Oracle Database.

Continue reading

October 17, 2018 Uncategorized

Compressed LOB–my table got bigger?

We had an interesting question on AskTOM the other day about LOB compression. Someone was very concerned that after applying

Continue reading

October 13, 2018 Uncategorized

LOBs vs Data – when compression occurs

Just a quick tip for SECUREFILE lobs. You may be familiar with basic compression on data in tables. It is

Continue reading

January 8, 2018 Uncategorized

Licensed for Advanced Compression? Don’t forget the network

We often think of Advanced Compression being exclusively about compressing data “at rest”, ie, on some sort of storage device. 

Continue reading

June 2, 2017 Uncategorized

Index compression–quick tip

If you’re appropriately licensed and want to use advanced index compression, you can take advantage of the setting a tablespace

Continue reading

August 5, 2015 Uncategorized

Index compression–working out the compression number

Richard Foote did a series of informative posts on Index Compression which concludes that there is whole lot of positives

Continue reading

August 26, 2013 Uncategorized

Compressed partitions are not compressed tables

So…you have got a big table and you’re lucky enough to have a partitioning license. So far, so good. Then

Continue reading

Over 500 posts …

Let’s connect

  • View connor_mc_d’s profile on Twitter
  • View connor_mc_d’s profile on Instagram
  • View connor-mcdonald-australia’s profile on LinkedIn
  • View UCVN7PnJnuKQ65QLmWjFvhiw’s profile on YouTube

Hi I'm Connor McDonald. I love playing with and exploring the Oracle database. But most of all I like seeing people succeed with the technology.
 
Subscribe for new posts by email.

Top Posts & Pages

  • How to do a GRANT on an entire schema
  • Why you keep getting "ORA-01653: unable to extend table"
  • Extending in-lists past the 1000 item barrier
  • Connection shortcuts with a wallet
  • No more stale statistics in 19c
  • How to TREAT data in a CLOB as JSON
  • Automatically generate audit capture for tables
  • Generating INSERT scripts that run fast!
  • Free In-memory in Oracle Database 19c
  • Comparing two database objects for differences
Blog at WordPress.com.
  • Follow Following
    • Learning is not a spectator sport
    • Join 814 other followers
    • Already have a WordPress.com account? Log in now.
    • Learning is not a spectator sport
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar