DBA Kevlar

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

January 11th, 2010

When PGA Size is Not Enough

I’ve come to realize that most folks don’t really understand the limitations in the allocation of PGA memory to hashing and sorting. They truly believe that if they set their PGA high enough, the database will just allocate as much memory as they have in the setting towards any hash or sort process, when in […]

 

Cool 11g New Features

I’m preparing to build our new 11g environment and as I “study up” on all that is new in 11g, there are a few features that stand out over the rest, (at least in my book!) I/O Calibration I’m am challenging the upper most limits of my hardware with how much I/O I can produce. […]

 

  • Facebook
  • Google+
  • LinkedIn
  • Twitter