jkstill

set trimspool on
ttitle off
set linesize 150
set pagesize 60
column command format a15
column osuser heading 'OS|Username' format a7 truncate
column process heading 'OS|Process' format a7 truncate
column machine heading 'OS|Machine' format a10 truncate
column program heading 'OS|Program' format a18 truncate
column object heading 'Database|Object' format a25 truncate

jkstill

-- connect_by_isleaf with standard connect by

select lpad(' ',2*(level-1)) || last_name last_name, connect_by_isleaf
from hr.employees
start with manager_id is null
connect by prior employee_id = manager_id;

/*

jkstill

set pause off
set echo off
set timing off
set trimspool on
set feed on term on echo off verify off
set line 80
set pages 24 head on

clear col
clear break

jkstill

-- 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

jkstill

@@clears

set pages 0 lines 200 term on feed off

jkstill

:

function usage {
    echo $0
    echo
    echo -m info:oratab
    echo
    echo Get a report on missing oratab entries
    echo $0 -m info
    echo

jkstill

-- 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.

jkstill

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]

jkstill

  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

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: