Archive for April, 2009

Oracle: Change (default) TEMP and UNDO tablespace to bigfile tablespaces

That’s how to change the Oracle Database’s TEMP and UNDO tablespaces to bigfile (as possible in 10g and above). It’s something I usually do for every DB I install.

create bigfile temporary tablespace TEMP1 tempfile \
     size 10G autoextend on next 1G maxsize 20G;
create bigfile undo tablespace UNDO1 datafile \
     size 10G autoextend on next 1G maxsize 20G;
alter system set undo_tablespace=UNDO1 scope=both sid='*';
alter database default temporary tablespace TEMP1;
drop tablespace UNDOTBS1;
drop tablespace TEMP;

Be careful,

By Martin Klier in Oracle  .::. Read Comments (2)

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

By Martin Klier in Oracle  .::. Read Comment (1)

You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.