davidhooey

// ----------------------------------------------------------
// A short snippet for detecting versions of IE in JavaScript
// without resorting to user-agent sniffing
// ----------------------------------------------------------
// If you're not in IE (or IE version is less than 5) then:
//     ie === undefined
// If you're in IE (>=5) then you can determine which version:
//     ie === 7; // IE7
// Thus, to detect IE:
//     if (ie) {}

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

set timing on;
set linesize 120;


--
-- Bind Variable Setup
--
variable Bind1 number;
variable Bind2 varchar2(2000);

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

select dbms_sqltune_util0.sqltext_to_sqlid('SQL_TEXT_HERE'||chr(0)) sql_id from dual;

davidhooey

drop table million;
drop sequence million_sequence;

create table million
(
    id number,
    type varchar2(50),
    constraint million_id_pk primary key (id)
);

davidhooey

drop table skewed;
drop sequence skewed_sequence;

create table skewed
(
    id number,
    type varchar2(50),
    constraint skewed_id_pk primary key (id)
);

davidhooey

-- Shared Pool
select
    event,
    time_waited "time_waited(s)",
    case when time_waited = 0 then 
        0
    else
        round(time_waited*100 / sum(time_waited) Over(), 2)
    end "percentage"
from

davidhooey

select
    name,
    round(time_secs, 2) time_secs,
    case when time_secs = 0 then
        0
    else
        round(time_secs*100 / sum(time_secs) Over(), 2)
    end pct
from
    (

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'));