Oracle Developer Jr - READY TO HIRE! Next Step Systems US-CA-Thousand Oaks Post A Job | Post A Resume

• Active SQL Statements in the database - Displays the user and the text of the statement the user is executing pop (Added: 29-Aug-1999 Hits: 12699 Rating: 4.93 Votes: 14) Rate It

• Display Lock Information - This script will query the V$LOCK table and display a decoded output to show the user and lock information pop (Added: 21-Aug-1999 Hits: 10919 Rating: 6.00 Votes: 4) Rate It

• FIND OUT TOP 20 MOST ACTIVE USERS - IT WIll gives you the User Name, System Id, Rating. pop (Added: 29-Dec-1999 Hits: 9645 Rating: 2.87 Votes: 8) Rate It

• User Activity Monitor Script - Script to monitor user activity on the database pop (Added: 12-Oct-1999 Hits: 11251 Rating: 8.43 Votes: 7) Rate It

• Find Blocking Sessions - Sometimes, lock occurs and we need to identify the user that is causing the
  lock.Usually, its a user that used "CTRL+ALT+DEL" and the process is still running in the database.
  Sometimes, its not a lock, its just the database that is running slow because of a heavy load. If no locks are returned, it indicates that no locks are present.
  
  You need to run the %ORACLE_HOME%\rdbms\admin\Catblock.sql file if you
  dont have the DBA_BLOCKERS table. (Added: 26-Feb-2001 Hits: 8254 Rating: 7.67 Votes: 3) Rate It

• Find your own TRACE File - Question: How will you find your own TRACE File (say
  ORA_5310.trc),
  while, multiple Trace files are generated
  simultaneously
  using Same USERNAMEs with Multiple SESSIONs in Oracle? (Added: 17-Jan-2003 Hits: 3262 Rating: 9.09 Votes: 11) Rate It

• find_criminal - This script provides details of users session. (Added: 27-Sep-2005 Hits: 4442 Rating: 0 Votes: 0) Rate It

• Finding your trace file from SQL*PLUS - You must set TRACE_DIR and ORACLE_SID in
  this script Put trace in < $HOME/bin > make it executable
  and run it from sqlplus session
  Example: SQL> ! trace
  Critics, Comment and suggestion are welcome nomiak@yahoo.com
  Note:You Must Run this script from your sqlplus session (Added: 1-Jan-2005 Hits: 2731 Rating: 0 Votes: 0) Rate It

• How will you find your own TRACE File even when session identifier is set - To set the session identifier and correctly get trace file name (Added: 24-Mar-2006 Hits: 2469 Rating: 10.00 Votes: 1) Rate It

• Killing locked users automatically - You can use this script to temporarily solve the locking issues in development. First create the procedure kill_locked_usr and then, submit a job with an argument that indicates the amount in seconds you will not permit a row exclusive lock. (Added: 7-May-2000 Hits: 7890 Rating: 7.33 Votes: 3) Rate It

Next 10