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

#!/usr/bin/env bash

set -eu

echo
echo Pulling latest Steven Black hosts file
echo

# curl and openssl built
# openssl /usr/local/ssl

jkstill

/*
 * Copyright 2019 Carter Yagemann <yagemann@gatech.edu>
 *
 * Permission is hereby granted, free of charge, to any person obtaining a copy
 * of this software and associated documentation files (the "Software"), to
 * deal in the Software without restriction, including without limitation the
 * rights to use, copy, modify, merge, publish, distribute, sublicense, and/or
 * sell copies of the Software, and to permit persons to whom the Software is
 * furnished to do so, subject to the following conditions:
 *

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

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