jkstill

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

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

// Use Gists to store code you would like to remember later on
console.log(window); // log the "window" object to the console

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:

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

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

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

:

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

jkstill

@@clears

set pages 0 lines 200 term on feed off

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