allthingsoracle.com/compression-in-oracle-part-2-read-only-data

Preview meta tags from the allthingsoracle.com website.

Linked Hostnames

8

Thumbnail

Search Engine Appearance

Google

https://allthingsoracle.com/compression-in-oracle-part-2-read-only-data

Compression in Oracle – Part 2: Read-Only Data

In part one of this series we saw that the mechanics of basic table compression came in to play only for direct path inserts, CTAS, and “alter table move”. We also saw that Oracle would, by default, set the free space percentage (pctfree) for a table to zero if the table were defined as compressed – giving us a hint



Bing

Compression in Oracle – Part 2: Read-Only Data

https://allthingsoracle.com/compression-in-oracle-part-2-read-only-data

In part one of this series we saw that the mechanics of basic table compression came in to play only for direct path inserts, CTAS, and “alter table move”. We also saw that Oracle would, by default, set the free space percentage (pctfree) for a table to zero if the table were defined as compressed – giving us a hint



DuckDuckGo

https://allthingsoracle.com/compression-in-oracle-part-2-read-only-data

Compression in Oracle – Part 2: Read-Only Data

In part one of this series we saw that the mechanics of basic table compression came in to play only for direct path inserts, CTAS, and “alter table move”. We also saw that Oracle would, by default, set the free space percentage (pctfree) for a table to zero if the table were defined as compressed – giving us a hint

  • General Meta Tags

    11
    • title
      Compression in Oracle – Part 2: Read-Only Data - Simple Talk
    • charset
      UTF-8
    • viewport
      width=device-width, initial-scale=1
    • google-site-verification
      v4FeIuwXgEi2SrU3GYFHMTLZhMn2CEi1Tk4MT7LN_lc
    • robots
      index, follow, max-image-preview:large, max-snippet:-1, max-video-preview:-1

  • Open Graph Meta Tags

    10
    • US country flagog:locale
      en_US
    • og:type
      article
    • og:title
      Compression in Oracle – Part 2: Read-Only Data
    • og:description
      In part one of this series we saw that the mechanics of basic table compression came in to play only for direct path inserts, CTAS, and “alter table move”. We also saw that Oracle would, by default, set the free space percentage (pctfree) for a table to zero if the table were defined as compressed – giving us a hint
    • og:url
      https://www.red-gate.com/simple-talk/databases/oracle-databases/compression-in-oracle-part-2-read-only-data/

  • Twitter Meta Tags

    3
    • twitter:card
      summary_large_image
    • twitter:creator
      @simple_talk
    • twitter:site
      @simple_talk

  • Link Tags

    39
    • EditURI
      https://www.red-gate.com/simple-talk/xmlrpc.php?rsd
    • alternate
      https://www.red-gate.com/simple-talk/feed/
    • alternate
      https://www.red-gate.com/simple-talk/comments/feed/
    • alternate
      https://www.red-gate.com/simple-talk/databases/oracle-databases/compression-in-oracle-part-2-read-only-data/feed/
    • alternate
      https://www.red-gate.com/simple-talk/wp-json/wp/v2/posts/73262

Emails

1
  • [email protected]?subject=Comment%20on%20Simple%20Talk%20Post&body=%0A%0A%E2%80%94%E2%80%94%E2%80%94%E2%80%94%E2%80%94%E2%80%94%E2%80%94%0AEnter%20your%20comment%20above%20the%20line%20about%20this%20post.%20Including%20more%20details%20will%20help%20us%20fix%20the%20issues.%0APost%20Name%3A%20Compression%20in%20Oracle%20%E2%80%93%20Part%202%3A%20Read-Only%20Data%0APost%20Author%3A%20Jonathan%20Lewis%0APost%20URL%3A%20https%3A%2F%2Fwww.red-gate.com%2Fsimple-talk%2Fdatabases%2Foracle-databases%2Fcompression-in-oracle-part-2-read-only-data%2F

Links

38