David Tripp

89 Flips | 6 Magazines | 3 Likes | 8 Following | 22 Followers | @david_tripp | Keep up with David Tripp on Flipboard, a place to see the stories, photos, and updates that matter to you. Flipboard creates a personalized magazine full of everything, from world news to life’s great moments. Download Flipboard for free and search for “David Tripp”

Bison Bag

The Bison Bag can be used as a hammock, a sleeping bag or a combination of both. It weights just 2.6lb. but has been tested to support up to 300lb. …

Comment on sql_trace by Investigating Indexes – 2 – All Things Oracle

[…] SQL trace globally is probably not a viable strategy – but 11g allows you to enable tracing for a specified SQL ID whenever it runs, and that …

On Promotion, Restriction, and Data Loading

Our technologist provides missing links, custom sizes, and external table tips.<p><i>By Tom Kyte</i><p>January/February 2013<p><i>Steven Feuerstein posted a URL that</i> …

Oracle Blogs | Oracle Optimizer Blog

Understanding I/O: Random vs Sequential

<b>Storage for DBAs:</b> Ever been to one of those sushi restaurants where the food comes round in dishes on a conveyor belt? As each dish travels around …

Monitoring Performance

By: | Consulting Technical Director<p>Oracle Operating System Watcher Black Box (OSWbb) 5 is available<br>(as a free download from Oracle Support, see …

Blackbox

Retrieve and visualize wait events metrics from AWR with R

In this post I will provide a way to retrieve wait events metrics from AWR and to display graphically those metrics thanks to R over a period of time.<p>…

Understanding SQLTXPLAIN Health-Checks

SQLTXPLAIN (SQLT) collects diagnostics details about a SQL statement that either performs poorly or it produces unexpected results (also known as …

Bind variable peeking: Retrieve peeked and passed values per execution in oracle 11.2

To understand this blog post you have to know what bind variable peeking is. You can found a very good explanation into this Kerry Osborne’s blog …

SLOB2: Essential for Every DBA Toolkit

A couple of weeks ago, Kevin released the second version of SLOB – the Silly Little Oracle Benchmark. Readers will know that I was already a big fan …

What Are the Best Oracle Database Load Testing Tools?

At Pythian’s internal forum, someone just asked the following question: <i>“The team here is evaluating DB load testing tools (Hammerdb, Orion, SLOB, and</i> …

Partitioning a table online with DBMS_REDEFINITION

If there is a requirement to change the structure of a table that is already in use productively, it may be impossible to get a maintenance downtime …

Upgrade Grid Infrastructure Cluster 11203 to 12101 Rolling

This is an out-of-place upgrade, which will create a new GI home and leave old home untouched for us to rollback/downgrade easily.<p>My Setup<p>2 node RAC …

25 Twitter Feeds Every Oracle User Should Follow

Everybody talks about Twitter, but few of us have arranged our “following” list so that it’s #justright. The purpose of this post is to tell you that it’s OK to drop @ladygaga (39,518,575 followers) and @KimKardashian (sadly, only 18,293,384) and instead load up on the technically astute epigrams …

Creating Chart Reports and Generating to HTML with SQL Developer 4.0

This tutorial shows you how to create a user defined chart with Oracle SQL Developer 4.0.<p>Duration: <b>25 minutes</b><p>This content is intended for the …

YASTS: Yet Another SQL Tuning Script

Having SQLTXPLAIN and SQLHC available, WHY do I need yet another way to display execution plans?<p>New script planx.sql reports execution plans for one …

amdu - ASM Metadata Dump Utility

The <b>ASM Metadata Dump Utility</b> - better knows as <b>amdu</b> - is used by Oracle Support and Oracle Development to diagnose and sometimes resolve ASM issues. …

Clustering_factor

The <i>clustering_factor</i> is one of the most important numbers (if not the most important number) affecting the optimizer’s choice of execution plan – …

Wait Metrics vs Wait Events

Here is a quick table comparison of different types of metrics views<p>The first line of the table is the classic wait event and statistic views. The …

Oracle CPU Time

Image from Bertrand Drouvot<p>UPDATE: thanks to a discussion in the comments it’s come to my attention that there should be some more clarification on …

Diagnosing buffer busy waits with the ash_wait_chains.sql script (v0.2)

In my previous post ( Advanced Oracle Troubleshooting Guide – Part 11: Complex Wait Chain Signature Analysis with ash_wait_chains.sql ) I introduced …

High Performance Tuning Tools

Obligatory Melodrama<p>No matter how much time goes by I still remember it. The day my database was crippled beyond reckoning. That moment when I saw my …

Mining the AWR to Identify Performance Trends

Sometimes it’s useful to check how performance of a SQL statement changes over time. The diagnostic pack features provide some really useful …

Updated Heat Map Report

During my preparation for a visualization presentation at East Coast Oracle Users Group I realized I had an opportunity for a teaching moment on …

Warp Speed with Temp Tablespace Groups

The introduction of the temp tablespace was a crucial step in the RDBMS to separating the “work area” for sorting and specific join operations from …

Tool to Add Range Partitions Automatically to a Table

Continuing on my earlier posts on partitioning, here are is another tool on this topic. If you have been using partitioned tables, you might have …

Command Line Attachment to Oracle Support Service Request

For those who haven’t looked at this in awhile: these days, it’s dirt simple to attach a file to your SR directly from the server command line.Or to …

Oracle AWR Reports: Understanding I/O Statistics

One consequence of my job is that I spend a lot of time looking at Oracle Automatic Workload Repository reports, specifically at information about …