Category Archives: Best Practices

Database Consolidation at Dell IT

A little more than a month and a quarter ago, in parallel with the daily production support routine, I had the pleasure to join the team running the database consolidation project in Dell IT. I was assigned as technical team … Continue reading

Posted in Best Practices, Oracle, Personal | Tagged , , , | Leave a comment

DBA best practices: Configuring SQL*Plus

SQL*Plus is a powerful tool with lots of options, but out-of-the-box it’s a little clumsy. Gladly, there is the login.sql file which you can edit and will run automatically whenever you connect to a database. To edit the file, just type … Continue reading

Posted in Best Practices, Oracle | Tagged , | 1 Comment

DBA best practices: Logging by default in Putty

The same way I like to keep a spool of all SQL*Plus output, I like it when I SSH into a server. Putty can do this, and it’s easy to have it by default. On the stored sessions section, click … Continue reading

Posted in Best Practices, Oracle | Tagged , | Leave a comment

DBA best practices: Logging by default in SQL*Plus

Several times I asked myself (or others asked me) what statements I executed or what results I had gotten from many days before. Of course I didn’t remember them anymore. Here’s where one of my favorite SQL*Plus features comes in handy: spooling. … Continue reading

Posted in Best Practices, Oracle | Tagged , | Leave a comment