Historical SQL Queries

[code language=”sql”] — This will find the user id select user_id from dba_users where username = ‘USERNAME’; — here is an example I use select username, user_id from dba_users where username not like ‘NB%’ and username not like ‘ZK%’; — Change the user_id to whatever user ID you found before col event format a30 col […]

Start Session Trace Function

[code language=”sql”] /************************************************************************** * Description: *      SQL*Plus script to start the SQL Trace for another session.  This *      script displays the trace file name and location.  This script will *      display the user sessions and prompt for information it needs. * **************************************************************************/ SET TERMOUT OFF SET FEEDBACK OFF SET VERIFY OFF SET ECHO OFF column […]