davidhooey

select
    snap_id,
    sql_id,
    name,
    position,
    datatype_string,
    to_char(last_captured,'YYYY-MM-DD HH24:MI:SS') last_captured,
    value_string
from
    dba_hist_sqlbind

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

//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

select
    *
from
(
    select
        module,
        sql_id,
        child_number,
        plan_hash_value,
        executions,

davidhooey

select
    *
from
(
    select
        ss.module,
        ss.snap_id,
        ss.sql_id,
        ss.plan_hash_value,
        ss.executions_total,

davidhooey

select distinct
    -- Snapshot ID
    min(blocked.snap_id)      as first_snap_id,
    max(blocked.snap_id)      as last_snap_id,

    -- Sample ID and Time
    min(blocked.sample_id)    as first_sample_id,
    min(blocked.sample_id)    as last_sample_id,
    to_char(
        min(blocked.sample_time),

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

# Installation
#
# 1. Install Xvfb 
#
#     sudo apt-get install xvfb
#
# 2. Add this file to /etc/init.d/xvfb
#
# 3. Make the script execuable.
#

davidhooey

--
-- Create SQL Tuning Set
--
begin
    dbms_sqltune.create_sqlset
    (
        sqlset_name  => 'AppName_STS_01',
        description  => 'SQL Tuning Set for AppName',
        sqlset_owner => 'SYS'
    );

davidhooey

select
    -- Session causing the block
    blockers.blocker_instance_id as blocker_instance_id,
    blocker.sid                  as blocker_sid,
    blocker.serial#              as blocker_serial#,
    blocker.username             as blocker_username,
    blocker.status               as blocker_status,
    blocker.machine              as blocker_machine,
    blocker.program              as blocker_program,
    blocker.sql_id               as blocker_sql_id,