Review of Hotsos Symposium 2007

I enjoyed the event and the venue very much. The presentations very generally very good, and to my surprise some of them were somewhat lighter than I would expect. However, that might actually play positively in extending the audience — there are only so many freaks interested only in hardcore performance and internals.

Working as an Onsite DBA Together with Pythian

I was reading a couple of items on gapingvoid which inspired me to use our blog for a conversation with our customers (and with potential Pythian DBAs) about what it’s like to work with Pythian. What exactly does an on-site DBA get from working with Pythian Remote DBAs? Find out here.

Tips for the New DBA

Pythian has been a rapidly expanding company over the ten months I’ve been here. About a dozen new employees have come on during that time, making the total 40. I have a few observations on habits and qualities new DBAs can bring to their jobs.

RMAN Recipes: How to Switch Oracle Logs Automatically

So you have swallowed the standby bait. You have used RMAN duplicate to create a sparkling new standby and things are looking rosy. Then, when you check the lag between the primary and standby (in MAXIMUM PERFORMANCE mode), you discover the standby is miles behind. Oracle (at least from 9iG) rides to the rescue again. The parameter ARCHIVE_LAG_TARGET tells Oracle to make sure to switch a log every n seconds.

DBMS_SCHEDULER and Implicit Commits

As usual, Oracle introduces new features, and we read the documentation about how they work and we start using them… but what about what is not in the documentation? That we find out by practice, experience, or accident. And that is exactly what happened to me today.

Page 226 of 257« First...102030...224225226227228...240250...Last »