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

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

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