Oracle

amcmd> a better “du”

I discovered ASM with a 10.1.0.3 RAC running on Linux Itanium and that was a big adventure. At this time there was no asmcmd. In 2005, Oracle released Oracle 10gR2 and asmcmd came into the place and we figured out how to make it work with a 10gR1 ASM. We were very excited to have a…

Simplify Oracle Tracing with Creative Scripting

Running a SQL trace is something that all DBAs do to varying degrees. Let’s say you are working on optimizing a SQL statement, and experimenting with some different hints for indexes and optimizer directives. This kind of effort typically goes something like this: modify the SQL statement enable tracing run the statement disable tracing disconnect…

RMAN 11g : How to Restore / Duplicate to a More Recent Patchset

In an Oracle DBA’s life, you’ll be regularly asked to work on applying a new patchset on a database and then you will apply it starting from the development database to the production database and this process can be quite long depending on the organization you are working for. In an Oracle DBA’s life, you’ll be regularly asked…

Pillars of PowerShell: SQL Server – Part 1

Introduction This is the sixth and final post in the series on the Pillars of PowerShell, at least part one of the final post. The previous posts in the series are: Interacting Commanding Debugging Profiling Windows OS PowerShell + SQL Server is just cool! You will see folks talk about the ability to perform a task…

Page 1 of 14112345...10...Last Page »