Any DBA worth the time of day knows how important having solid statistics is to a database. This is how the cost based optimizer is able to make solid decisions about the best path to take when performing a table scan, choosing an index, the amount of resources required to perform a task and so on and so forth. In any database that is built, post 10g, release 2 and on, there are maintenance jobs that are created by default, one of them, to collect statistics automatically, with it’s goal to ensure that the database has the newest, most updated…
-
-
After a very tearful goodbye at my previous company, (even received a big ol’ hug from the “lone wolf”- after working with the guy for four years, never thought I’d see that! :)) After they had a great time at my expense- two or three days of throwing paper airplanes over the cubicle walls at me, (to which I would response with screeches of “my eye!” or “my tibia!” and a demand for workman’s comp.. :)) The unix admin sending me bogus system messages to see if I was actually still working, “exporting partition P_33497 Oracle has experienced poopy pants the…
-
My Mother used to write poems and rhymes. She had so much fun at it that we kids used to have the most elaborate rhyming clues to finding Easter treats and small toys each year, Easter started to get a little out of hand just so my Mom could practice her poetic skills, (not that we kids minded! :)) I thought I would have some fun with rhyming, but I think I’m closer to Cat in the Hat than Keats or Byron… 🙂 If there were no developers, I would be so bored, Just ask them, they say DBA’s appreciate…