#Getting Started
##Webpage:
<html>
<head>
<title>Testing with Ruby and Selenium WebDriver</title>
</head>
<body bgcolor="antiquewhite">
davidhooey
davidhooey
/ oracle_which_sql_caused_wait_event.sql
Created
September 24, 2014 15:42
Oracle Which SQL_ID Caused A Particular Wait Event
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| select | |
| event, | |
| sql_id, | |
| snap_id, | |
| dbid, | |
| instance_number, | |
| sample_time, | |
| session_id, | |
| session_serial#, | |
| user_id, |
davidhooey
/ Selenium Cheat Sheet.md
Last active
August 29, 2015 14:07
— forked from kenrett/Selenium Cheat Sheet.md
davidhooey
/ oracle_blocker_blocked_sessions.sql
Last active
July 21, 2020 17:24
Oracle blocker and blocked session information.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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, |
davidhooey
/ oracle_create_sts_from_application_sql.sql
Created
May 19, 2015 22:49
Create Oracle SQL Tuning Set for an application's cached statements.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- | |
| -- Create SQL Tuning Set | |
| -- | |
| begin | |
| dbms_sqltune.create_sqlset | |
| ( | |
| sqlset_name => 'AppName_STS_01', | |
| description => 'SQL Tuning Set for AppName', | |
| sqlset_owner => 'SYS' | |
| ); |
davidhooey
/ xvfb
Last active
August 29, 2015 14:21
— forked from jterrace/xvfb
Xfvb init script for ubuntu
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # Installation | |
| # | |
| # 1. Install Xvfb | |
| # | |
| # sudo apt-get install xvfb | |
| # | |
| # 2. Add this file to /etc/init.d/xvfb | |
| # | |
| # 3. Make the script execuable. | |
| # |
davidhooey
/ protips.js
Created
January 3, 2016 23:49
— forked from nolanlawson/protips.js
Promise protips - stuff I wish I had known when I started with Promises
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // 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
/ oracle_blocker_blocked_sess_history.sql
Last active
November 26, 2024 22:57
Oracle blocker and blocked session information from history.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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
/ oracle_top_sql_history.sql
Last active
January 14, 2020 23:45
Oracle top historical SQL
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| select | |
| * | |
| from | |
| ( | |
| select | |
| ss.module, | |
| ss.snap_id, | |
| ss.sql_id, | |
| ss.plan_hash_value, | |
| ss.executions_total, |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| select | |
| * | |
| from | |
| ( | |
| select | |
| module, | |
| sql_id, | |
| child_number, | |
| plan_hash_value, | |
| executions, |
davidhooey
/ promisedRequest.js
Created
October 19, 2016 14:03
— forked from anandsunderraman/promisedRequest.js
Node.js request with Q promises
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| //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' |