December 2011 archive

Dec 13

Brand New Production Database

Every once in a while, no matter which company I work for, I am asked to set up a new production database. I was working on this very task today when I started thinking about how much work it was to create a brand new database in that past, how much the DBCA handles for …

Continue reading »

Dec 12

Wait Event: asynch descriptor resize

In my recently upgraded production database, I am seeing a number of SQL statements that are now experiencing high waits on the “asynch descriptor resize” event. I recently upgraded from to and SQL statements that never waited on this event are now getting caught. Oracle 11.2 slightly changed the way the database and …

Continue reading »