Author: Jared Still

No arguments here – use xargs for file management performance

Jared Still, Pythian Principle Consultant and Oracle ACE, explains how using xargs with find can greatly speed up maintenance scripts and reduce system resource usage.

Read More >

Optimizer Stew – parsing the ingredients to control execution plans

Jared Still, Pythian Principle Consultant and Oracle ACE, explains how to keep track of the different methods used to control Oracle Optimizer execution plans.

Read More >

More fun with oracle timestamp math

Jared Still, Pythian Principle Consultant and Oracle ACE, writes an update on Oracle Timestamp Math.

Read More >

Expert insights: Oracle NET troubleshooting for DBAs

Jared Still, Pythian Principle Consultant and Oracle ACE, outlines the difficulties associated with troubleshooting connectivity issues when dealing with Oracle and provides tips on how to overcome them.

Read More >

How to decipher oracle Internal datatype storage

Jared Still, Principal Consultant and Oracle ACE explains why Oracle doesn’t always provide all the information you need as a DBA. Here’s one example and how to work around it with Oracle data type storage.

Read More >

Oracle ASM rebalance – Turn it up. To 11?

  If you’ve ever seen or heard of the movie This is Spinal Tap then you have likely heard the phrase Turn it up to 11. Why bring this up? When ASM was introduced as a method for configuring storage for Oracle,…

Read More >

RMAN full backup vs. level 0 incremental

Perhaps you’ve wondered about this. What is the difference between taking an RMAN full backup and a level 0 incremental backup? If you read the documentation the following explanation will be found here: Incremental Backups The only difference between a…

Read More >

Patching fun: GI and database patches

So, it has been some time since I have patched a database. Patching seemed necessary in a 12c database used for testing, as it was having some crashing issues. As the database and GI home were both un-patched, it seemed worthwhile to…

Read More >

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…

Read More >

Git for beginners

git, simplified Perhaps you’ve come across a great cache of publicly available SQL scripts that would be very useful in monitoring your databases, and these scripts are hosted on github.  Getting those scripts is as simple as clicking the Download…

Read More >
Page 3 of 41234