VirtaThon 2011

VirtaThon 2011 is the first Oracle online/virtual conference and is hosted by BrainSurface.com. The conference will feature many well known and respected Oracle experts and speakers and a few unknown ones (including yours truly). This will mark my debut as a public speaker and I am grateful for the opportunity after having only aspirations for some time now.

You can sign up and register for VirtaThon here and the session schedule can be found here.

Comments

Post a Comment

Popular posts from this blog

How to Get More Time to Play Golf or Faster Data Delivery with Delphix

Image
The Delphix Data Virtualization Engine allows DBAs to spend less time cloning and refreshing databases and focus on other import tasks - like golf or your favorite activity. In full disclosure, I tried golf once and was ' turrible ' at it. In all seriousness, having the ability to spin up a virtual database (VDB) in a matter of minutes shaves hours or days off of manual, mundane and error prone work. This makes customers (developers, analysts) happy too. Not only can you quickly and easily create full read/write copies of their production data, they also get the time machine-like ability to go backwards and forwards with their data, which opens up a world of possibilities. As a database administrator, I've spent way too many hours creating clones of databases for development, test and reporting purposes. Cloning or duplicating multi-terabyte databases can take a very long time. Oracle databases, in particular, can become complex depending on how the clone is being pe...
Read more

Oracle Home Cloning: Tools and Techniques

One of the many necessary and frequent tasks that a database administrator performs before creating a database is installing the Oracle database binaries. These binaries form what is known as an Oracle Home (referenced by the ORACLE_HOME environment variable on Linux and UNIX environments). Unfortunately, this is also one of the most mundane and uninteresting tasks a DBA can perform. So like all good DBAs know, the best way to deal with such repetitive task is to automate it. Automating installations of Oracle database binaries enables us to reliably repeat the process to enable faster installation as well as provide identical copies of the software in multiple environments. Fortunately, Oracle allows us to clone the Oracle database binaries from one environment to another. Cloning your Oracle binaries from a source copy with all the necessary patches applied enables us to have gold images which can then be deployed to multiple environments. The procedure for cloning an Oracle home...
Read more

Using DML with ADRCI

Image
The Oracle Database has some useful debugging and diagnostics features. One such utility called the Automatic Diagnostics Repository Command Interpreter or ADRCI, enables database and system administrators to view and analyze information including trace and log files. In addition to the usual ADR commands, you can also issue DML-like statements. These statements are limited to the diagnostics information found in the ADR. Let's take a look at how to use ADRCI to issue DML. Please note: DML statement issued via ADRCI don't require a termination character such as the semicolon. Also, the statements have to be on a single line. The following DML commands are defined in ADRCI version 12.1.0.2.0 SELECT UPDATE* DELETE* INSERT* UPDATE* QUERY* To get a list of the commands, use the help  keyword in ADRCI. You may notice that only the SELECT statement is shown by default. To see the list of additional commands, type help extended . Note: Commands proceeded by a...
Read more