Skip to content

Instantly share code, notes, and snippets.

View krisrice's full-sized avatar

Kris Rice krisrice

91 followers · 14 following
View GitHub Profile
@krisrice
krisrice / rest_sql_batch_insert.js
Created November 5, 2022 01:14
var fetch = require('node-fetch');
//
// generate random string
//
/*
Sample output
inserting :50000 rows
Rows:244,652
http: 7.429s
@krisrice
krisrice / ADB_list_buckets_with_RESOURCE_PRINCIPAL.sql
Created October 31, 2022 15:46
DECLARE
l_comp_ocid varchar2(200);
l_tenant_ocid varchar2(200);
all_buckets DBMS_CLOUD_OCI_IDENTITY_COMPARTMENT_TBL;
function lsComp(p_tenant_ocid varchar2,
p_region varchar2,
p_cred varchar2 default 'OCI$RESOURCE_PRINCIPAL',
p_page varchar2 default null) return DBMS_CLOUD_OCI_IDENTITY_COMPARTMENT_TBL
as
@krisrice
krisrice / kill.js
Created October 19, 2022 13:18
// SQLCL's Command Registry
var CommandRegistry = Java.type("oracle.dbtools.raptor.newscriptrunner.CommandRegistry");
// CommandListener for creating any new command
var CommandListener = Java.type("oracle.dbtools.raptor.newscriptrunner.CommandListener")
// Broke the .js out from the Java.extend to be easier to read
var cmd = {};
// Called to attempt to handle any command
@krisrice
krisrice / sqlcl-Dockerfile
Created March 15, 2017 16:08
FROM ubuntu:latest
# Install Java.
RUN apt-get update && \
apt-get upgrade -y && \
apt-get install -y software-properties-common && \
add-apt-repository ppa:webupd8team/java -y && \
apt-get update && \
echo oracle-java7-installer shared/accepted-oracle-license-v1-1 select true | /usr/bin/debconf-set-selections && \
@krisrice
krisrice / sql-replay.html
Created October 3, 2022 19:27
<html>
<head>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/hack-font/3.3.0/web/hack.min.css" integrity="sha512-XgCw4Srl8lC1ECwcaHwAU0WnxQwHkqmInzg9wJLtGB7DRuMaXPuK2k9WJ2AwRDGdrgK9eJpZl2hUlLi2WQssmw==" crossorigin="anonymous" referrerpolicy="no-referrer" />
<script
src="https://code.jquery.com/jquery-2.2.4.min.js"
integrity="sha256-BbhdlvQf/xTY9gja0Dq3HiwQF8LaCRTXxZKRutelT44="
crossorigin="anonymous"></script>
<script src="https://mattboldt.com/demos/typed-js/js/typed.custom.js"></script>
<script>$( document ).ready(function() {
var data = [
@krisrice
krisrice / addMyIpWhiteList.sh
Last active June 14, 2022 21:09
#!/bin/bash
OCIPROFILE="MYPROFILE"
DBOCID="ocid1.autonomousdatabase.oc1.phx.anyhqljrcsc5xxqnxxxxxxxxxxxxxxxxxxxxxxxxkulv5ipmbqiq"
REGION="us-phoenix-1"
#
# GET my IP Address
#
# Example : "1.2.3.4"
CURRENT_IP=$(oci raw-request --profile $OCIPROFILE --target-uri https://database.${REGION}.oraclecloud.com/20160918/autonomousDatabases/capabilities --http-method GET | jq ".data.clientIpAddress")
@krisrice
krisrice / dbms_cloud_metric_sql_pkg.sql
Created May 20, 2022 15:26
create or replace package oci_metrics as
--
-- ╔═╗┌─┐┌┬┐┬ ┬┌─┐ ╔═╗┌┬┐┌─┐┌─┐┌─┐
-- ╚═╗├┤ │ │ │├─┘ ╚═╗ │ ├┤ ├─┘└─┐
-- ╚═╝└─┘ ┴ └─┘┴ ╚═╝ ┴ └─┘┴ └─┘
--
-- Current PDB's OCID
-- select json_value(cloud_identity , '$.DATABASE_OCID') from v$pdbs
--
-- Crate Dynamic Group "klrice-testing"
@krisrice
krisrice / sql_oci_metrics.sql
Last active May 18, 2022 20:08
set serveroutput on
DECLARE
credential_name varchar2(200) := 'OCI$RESOURCE_PRINCIPAL';
region varchar2(200) := 'us-phoenix-1';
base_uri varchar2(200) := 'https://telemetry-ingestion.' || region|| '.oraclecloud.com/20180401/metrics';
resp dbms_cloud_types.RESP;
BEGIN
-- Current PDB's OCID
-- select json_value(cloud_identity , '$.DATABASE_OCID') from v$pdbs
@krisrice
krisrice / load_strava.sql
Created March 2, 2022 15:08
set load scan_rows 10000
drop table strava_activities;
drop table strava_applications;
drop table strava_bikes;
drop table strava_blocks;
drop table strava_clubs;
drop table strava_comments;
drop table strava_components;
drop table strava_connected_apps;
drop table strava_contacts;
@krisrice
krisrice / node-select.js
Created December 6, 2021 19:09
const common = require("oci-common");
const databasetools = require("oci-databasetools");
const secrets = require("oci-secrets");
const core = require("oci-core");
const fs = require("fs");
const oracledb = require('oracledb');
//
// Configure Instant Client
//