davidhooey

## Selenium Cheat Sheet.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                davidhooey
                / Selenium Cheat Sheet.md
            
            
              Last active
              August 29, 2015 14:07
                — forked from kenrett/Selenium Cheat Sheet.md
            
          
    #Getting Started
##Webpage:
<html>
<head>
    <title>Testing with Ruby and Selenium WebDriver</title>
</head>
 
<body bgcolor="antiquewhite">


## oracle_which_sql_caused_wait_event.sql
select
    event,
    sql_id,
    snap_id,
    dbid,
    instance_number,
    sample_time,
    session_id,
    session_serial#,
    user_id,

## oracle_awrsqrpt_sql.sql
-- Find the dbid, instance_number and begin and end snap_id to be used.

select
    snap_id,
    dbid,
    instance_number,
    begin_interval_time,
    end_interval_time
from
    dba_hist_snapshot

## oracle_awrrpt_sql.sql

-- Find the dbid, instance_number and begin and end snap_id to be used.

select
    snap_id,
    dbid,
    instance_number,
    begin_interval_time,
    end_interval_time
from

## oracle_wait_events_for_sql_id_within_time_period.sql
-- V$ACTIVE_SESSION_HISTORY
select
    event,
    sum(time_waited) time_waited
from
    v$active_session_history
where
    sql_id = 'SQL_ID'
and
    sample_time between

## tiny_png.rb
require "net/https"
require "uri"

# Ensure we have two parameters.
if ARGV.length != 2
    puts "Usage: #{$0} input_directory output_directory"
    exit 1
end

key = "PLACE_TINY_PNG_KEY_HERE"

## sql_server_delete_duplicate_rows.sql
delete from tableName
where %%physloc%% not in
(
    select
        max(%%physloc%%)
    from
        tableName
    group by
        column1,
        column2,

## bdd.rb
class Fifo
  EmptyError = Class.new(Exception)
  Node = Struct.new(:value, :next)

  attr_accessor :size, :top
  private :size=, :top=


  def initialize
    self.size = 0

## oracle_tablespace_usage.sql
select
    d.tablespace_name tn,
    d.block_size bs,
    d.extent_management lm,
    d.segment_space_management assm,
    d.status st,
    to_char(f.bytes/1024,'999,999,999')||'K' bts,
    to_char((f.bytes-s.free_bytes)/1024,'999,999,999')||'K' used,
    to_char(round((f.bytes-s.free_bytes)/f.bytes*100),'990.9')||'%' pct,
    case trunc(33*(f.bytes-s.free_bytes)/f.bytes)

## oracle_lock_mon.sql
Rem oracle_lock_mon.sql
Rem
Rem    NAME
Rem      oracle_lock_mon.sql
Rem
Rem    DESCRIPTION
Rem	     SQL*Plus command file to log transaction locks.
Rem      This script is based on the
Rem      /rdbms/admin/utllockt.sql script.
Rem
	select
	event,
	sql_id,
	snap_id,
	dbid,
	instance_number,
	sample_time,
	session_id,
	session_serial#,
	user_id,
	-- Find the dbid, instance_number and begin and end snap_id to be used.

	select
	snap_id,
	dbid,
	instance_number,
	begin_interval_time,
	end_interval_time
	from
	dba_hist_snapshot
	-- V$ACTIVE_SESSION_HISTORY
	select
	event,
	sum(time_waited) time_waited
	from
	v$active_session_history
	where
	sql_id = 'SQL_ID'
	and
	sample_time between
	require "net/https"
	require "uri"

	# Ensure we have two parameters.
	if ARGV.length != 2
	puts "Usage: #{$0} input_directory output_directory"
	exit 1
	end

	key = "PLACE_TINY_PNG_KEY_HERE"
	delete from tableName
	where %%physloc%% not in
	(
	select
	max(%%physloc%%)
	from
	tableName
	group by
	column1,
	column2,
	class Fifo
	EmptyError = Class.new(Exception)
	Node = Struct.new(:value, :next)

	attr_accessor :size, :top
	private :size=, :top=


	def initialize
	self.size = 0
	select
	d.tablespace_name tn,
	d.block_size bs,
	d.extent_management lm,
	d.segment_space_management assm,
	d.status st,
	to_char(f.bytes/1024,'999,999,999')\|\|'K' bts,
	to_char((f.bytes-s.free_bytes)/1024,'999,999,999')\|\|'K' used,
	to_char(round((f.bytes-s.free_bytes)/f.bytes*100),'990.9')\|\|'%' pct,
	case trunc(33*(f.bytes-s.free_bytes)/f.bytes)
	Rem oracle_lock_mon.sql
	Rem
	Rem NAME
	Rem oracle_lock_mon.sql
	Rem
	Rem DESCRIPTION
	Rem SQL*Plus command file to log transaction locks.
	Rem This script is based on the
	Rem /rdbms/admin/utllockt.sql script.
	Rem