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 >
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 >
Jared Still, Pythian Principle Consultant and Oracle ACE, writes an update on Oracle Timestamp Math.Read More >
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 >
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 >
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 >
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 >
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 >
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, 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 >
© Copyright 2019 Pythian Group Inc. ® ALL RIGHTS RESERVED.
PYTHIAN®, LOVE YOUR DATA®, and ADMINISCOPE® are trademarks and registered trademarks owned by Pythian in North America and certain other countries, and are valuable assets of our company. Other brands, product and company names on this website may be trademarks or registered trademarks of Pythian or of third parties. Use of trademarks without permission is strictly prohibited.