Martin Klier


Oracle 11g look-at’s

That’s a personal, quite unsorted list of (new or older) features I recently collected. All of them are things, I’d consider valuable or at least important to care about as soon as 11g is involved. It might be for system architecture knowledge, concept tasks, DBA hands-on, good-to-know or any other thing that my happen in a DBA life.

  • Password profile (user pw expires after 180 days by default!)
  • (Client) Result cache
  • (DB_KEEP_CACHE / DB_RECYCLE_CACHE plus corresponding segment configuration)
  • the adrci command line tool, for the least example to view an alert log tail-like in windows
  • direct NFS supported
  • fast mirror resync in ASM
  • preferred read mirror in ASM
  • Optimizer simulation capabilities
  • Index invisible after creation
  • Statistics inactive after creation
  • DB replay feature with 10g partially possible (patch apply necessary)
  • I/O-calibration + I/O statistics
  • Adaptive cursor sharing
  • Resource manager with I/O quotas
  • Interval partitioning (auto-create addition to range partitioning)
  • PL/SQL native code

Look them up in Oracle Docs, and consider using them someday/somehow/somewhere.

Good, bugfree luck

Oracle: Convert a partitioned table into an unpartitioned one
Oracle: Change (default) TEMP and UNDO tablespace to bigfile tablespaces

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.