obivan keniby

14 Flips | 4 Magazines | @djeday84 | Keep up with obivan keniby 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 “obivan keniby”

SQLTXPLAIN and the AWR Warehouse, Part I

Yeah, so I did it- I installed SQLTXPLAIN, (SQLT) on the AWR Warehouse! From previous experience with this fantastic tool, I was pretty sure I’d have …

Ash architecture and advanced usage rmoug2014

This is the presentation on ASH that I did with Graham Wood at RMOUG 2014 and that represents the final best effort to capture essential and advanced ASH content as started in a presentation Uri Shaft and I gave at a small conference in Denmark sometime in 2012 perhaps. The presentation is also …

Oracle

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 …

Review of Big Data Warehousing at OpenWorld 2017 - Now Available

This is a continuation of a series of posts that cover Oracle's SQL extensions for reporting and analysis. As reviewed in earlier blog posts (Part 1 …

Removing passwords from Oracle scripts: Wallets and Proxy Users | DBA survival BLOG

Very often I encounter customers that include Oracle account passwords in their scripts in order to connect to the database.<br>For DBAs, sometimes …

RAC in KVM is possible without iSCSI

(This post is for Jerry. He will know when he reads it)<p>I have been a great supporter of many flavours of virtualisation and my earliest experience …

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 …

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 …

Delete one billion row

To delete large number of rows, for instance rows with date until 2010, you can issue this simple statement.<p>This is perfectly fine. The table remains …

Cloning Your Oracle Installation

If there is one thing a DBA hates it is to waste time. Particularly on boring and tedious tasks. One such task is installing Oracle on a new system …

Comment on Oracle Troubleshooting with Snapper – detecting who’s causing excessive redo generation by Dird

This example is broken in the latest version?<br>@snapper out,gather=s,sinclude=%redo_size% 10 90 “select sid from v$session”/* inst_filter */ …

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 …