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
Read MoreI’ve come to realize that most folks don’t really understand the limitations in the allocation of PGA memory to hashing
Read MoreI’m preparing to build our new 11g environment and as I “study up” on all that is new in 11g,
Read MoreAfter a lovely week off, I came back into work and brought up the OEM console to take a quick
Read MoreTwo weeks ago, after a new mart had performed excellent for 24hrs, a sudden and detrimental decline in performance was
Read More…also known as follow up post on “dropping unused columns…” In my last post I discussed how to drop unused
Read MoreA developer needed to do some serious data changes to a partition. I thought I’d be a helpful DBA and
Read MoreAs I’ve spent two “tours of duty” as a Lead DBA in my career, I often keep in mind what
Read MoreA developer friend of mine sent me an email today frustrated that none of the DBA’s he worked with could
Read MoreThe Challenge: You want one process in your application to use a separate temp tablespace created on faster “ram disks”
Read MoreOK, Who else out there has a 3.8TB tablespace? Anyone, anyone? Bueller, Bueller?? I know, I know- Oracle can support
Read MoreThis is a subject that I see a lot of debate on, but as a DBA who works in mostly
Read MoreSo I’ve been accepted to present at the 2010 RMOUG Conference and I am understandably nervous. This is my first
Read MoreYou have a statement that somebody, without thinking about resources, requested 96 total parallel processes for. They have now come
Read MoreOEM Reports that a server load is critical and top confirms this- PID USER PR NI VIRT RES SHR S
Read Moremethod_opt=>’for all columns size 1′ This is the method option for DBMS_STATS.GATHER_TABLE_STATS that is commonly recommended- “Let Oracle look at
Read More