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
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
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
View keybase.md

Keybase proof

I hereby claim:

  • I am jkstill on github.
  • I am jkstill (https://keybase.io/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:

View HAVING
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 ora112304a.jks.com - jkstill@js02 SQL> /
having id between 5 and 8
*
ERROR at line 6:
@jkstill
jkstill / proc_net_tcp_decode
Last active Oct 31, 2019
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.
View find_oracle_homes.sh
:
function usage {
echo $0
echo
echo -m info:oratab
echo
echo Get a report on missing oratab entries
echo $0 -m info
echo
@jkstill
jkstill / clear_for_spool.sql
Created Dec 9, 2010
clear sqlplus settings for spooled output
View clear_for_spool.sql
@@clears
set pages 0 lines 200 term on feed off
@jkstill
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
@clears
set pagesize 50000
set linesize 120
col source_user new_value source_user noprint
You can’t perform that action at this time.