Skip to content

Instantly share code, notes, and snippets.

Working from home

Jared jkstill

Working from home
View GitHub Profile
View showlock.sql
-- showlock.sql - show all user locks
-- see ML Note 1020008.6 for fully decoded locking script
-- parts of the that script to not work correctly, but the
-- lock types are current
-- (script doesn't find object that is locked )
-- speeded up greatly by changing order of where clause,
-- jks 04/09/1997 - show lock addresses and lockwait
jkstill / c2.sql
Created Mar 26, 2016
Test table for Timestamp Math Blog
View c2.sql
col c1_dump format a70
col c1 format a35
col funcname format a15
set linesize 200 trimspool on
set pagesize 60
drop table timestamp_test purge;
jkstill / 0_reuse_code.js
Created Mar 26, 2016
Here are some things you can do with Gists in GistBox.
View 0_reuse_code.js
// Use Gists to store code you would like to remember later on
console.log(window); // log the "window" object to the console

Keybase proof

I hereby claim:

  • I am jkstill on github.
  • I am jkstill ( on keybase.
  • I have a public key whose fingerprint is D2D8 E718 7020 EDB6 B4F6 1277 B515 2F65 4FFC 2016

To claim this, I am signing this object:

1 with mydata as (
2 select level id
3 from dual connect by level <= 10
4 )
5 select id from mydata
6* having id between 5 and 8
09:27:05 - jkstill@js02 SQL> /
having id between 5 and 8
ERROR at line 6:
jkstill / proc_net_tcp_decode
Last active Oct 8, 2020
decode entries in /proc/net/tcp
View proc_net_tcp_decode
Decoding the data in /proc/net/tcp:
Linux 5.x /proc/net/tcp
Linux 6.x /proc/PID/net/tcp
Given a socket:
$ ls -l /proc/24784/fd/11
lrwx------ 1 jkstill dba 64 Dec 4 16:22 /proc/24784/fd/11 -> socket:[15907701]
View showdf.sql
-- showdf.sql
-- get from dba_data_files and dba_temp_files rather that v$ views
-- jkstill - 10/29/2008 - changed method of getting free TEMP space
-- it was incorrect. currently still a compromise, but more correct
-- added pct_capacity
-- jkstill - 10/29/2008
-- 2 calculations had '/' on a line by itself
-- works in 9i, but not in 10g.
function usage {
echo $0
echo -m info:oratab
echo Get a report on missing oratab entries
echo $0 -m info
jkstill / clear_for_spool.sql
Created Dec 9, 2010
clear sqlplus settings for spooled output
View clear_for_spool.sql
set pages 0 lines 200 term on feed off
jkstill / get_all_privs.sql
Created Dec 9, 2010
Find all privileges granted to a user
View get_all_privs.sql
-- get_all_privs.sql
-- for a user, find all privileges
-- even if assigned recursively through a role
set pagesize 50000
set linesize 120
col source_user new_value source_user noprint
You can’t perform that action at this time.