Skip to content

Instantly share code, notes, and snippets.

Working from home

Jared jkstill

Working from home
Block or report user

Report or block jkstill

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
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 Jan 9, 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.