davidhooey

-- Shared Pool
select * from table(dbms_xplan.display_cursor('SQL_ID',null,'ALL'));

-- AWR
select * from table(dbms_xplan.display_awr('SQL_ID',null,null,'ALL'));
select * from table(dbms_xplan.display_awr('SQL_ID',null,DBID,'ALL'));

davidhooey

Download and install p4merge

• Download the perforce visual tool suite from here: http://www.perforce.com/perforce/downloads/index.html
• Copy only the p4merge.app file into your /Applications/ directory

Setup p4merge as a visual mergetool

davidhooey

set -g prefix C-a
set -sg escape-time 1
set -sg base-index 1
setw -g pane-base-index 1

setw -g mode-keys vi

set -g mouse on

bind r source-file ~/.tmux.conf \; display "Reloaded!"

davidhooey

-- Shared Pool
select *
from
    (
        select
            case when executions = 0 then 0
            else round(elapsed_time/executions, 3)
            end "ElapsedPerExec(ms)",
            elapsed_time "ElapsedTime (ms)",
            executions "Executions",

davidhooey

//import the http library
var http = require('http'),
//npm install q before requiring it
	Q = require('q');

//a js object with options
var googleNewsOptions = {
  hostname: 'ajax.googleapis.com',
  path: '/ajax/services/search/news?v=1.0&q=nodejs',
  method: 'GET'

davidhooey

#! /bin/bash

# GemInABox
# Maintainer: David Hooey

### BEGIN INIT INFO
# Provides:          geminabox
# Default-Start:     2 3 4 5
# Default-Stop:      0 1 6
# Description:       Gem in a Box

davidhooey

--
-- Segment Advisor for Individual Segments
--

-- 1. Replace all occurances of [OWNER] with the owner of the segments.
-- 2. Replace [TABLE_NAME] or [INDEX_NAME] with the segment to be analyzed.

set echo off
set feedback off
set verify off

davidhooey

// Promise.all is good for executing many promises at once
Promise.all([
  promise1,
  promise2
]);

// Promise.resolve is good for wrapping synchronous code
Promise.resolve().then(function () {
  if (somethingIsNotRight()) {
    throw new Error("I will be rejected asynchronously!");

davidhooey

select 
    holders.*,
    ' IS BLOCKING ' is_blocking,
    waiters.*
from
    (
        select 
            dw.holding_session,
            hs.username, 
            do.object_name, 

davidhooey

select 
    'alter table ' || table_name || ' modify ( ' || column_name || ' varchar(' || char_length || ' char) );'
from 
    user_tab_columns 
where 
    data_type = 'VARCHAR2'
and
    char_used = 'B' 
order by 
    table_name,