Category: Oracle Scripts

Oracle – Sessions Logged In »

Often it is nice to see who is logged in to a database.  This is a simple script I use. This script is called sid.sql set linesize 132 set pagesize 100 ttitle on ttitle center ‘*****  Connected Users  *****’ skip 2 clear breaks column sid                format 9999         heading ‘SID’ column serial#            format 99999        heading ‘Ser#’ [...]

Sql*Plus – Scripts and SQLPATH »

As oracle DBA’s I find that most of us are command line sadists more than GUI folk. Therefore we write and run lots of scripts and if we can store those scripts in a common location our lives are easier. Here is my method. Create a Common Directory Set the SQLPATH Environment Variable Create a [...]