DBA Kevlar

Tips, tricks, (and maybe a few rants) so more DBAs become bulletproof!

August 2nd, 2011

Warp Speed with Temp Tablespace Groups

The introduction of the temp tablespace was a crucial step in the RDBMS to separating  the “work area” for sorting and specific join operations from permanent segments.   To eliminate the performance challenges of sorts and hash against the I/O threshold involved with performing this word in the temp tablespace, Oracle 9i introduced the Program Global […]

 

  • Facebook
  • Google+
  • LinkedIn
  • Twitter