Find Full Table Scans
- The output of this script will display all sql statements in the shared pool that are doing full table scans.
pop
(Added: 19-Jun-2000 Hits: 11557 Rating: 5.81 Votes: 10) Rate It
Identify top 20 Oracle Processes in Unix
- Find the top 20 longest running processes in unix. Useful for high CPU bound systems with large number of users. Script also identifies processes without a oracle session.
pop
(Added: 29-Aug-1999 Hits: 9019 Rating: 5.38 Votes: 13) Rate It
SGA Sizing
- An interesting script submitted by one of our readers to size the SGA
pop
(Added: 19-Sep-1999 Hits: 10607 Rating: 4.79 Votes: 14) Rate It
DB Block Efficiency Script
- This script uses the new way of calculating DB_Block Buffer Efficiency. Logical Read: consistent gets + db block gets Hit-Ratio: (logical reads - physical reads) / (logical reads) Our Aim: OLTP >= 95%, DSS/Batch >= 85% Solution: enlarge block buffers, tune SQL, check appropriateness of indexes
(Added: 30-Apr-2000 Hits: 6912 Rating: 4.80 Votes: 5) Rate It
EXPLAIN and get some statistics on your SQL
- Haven't you ever thought there should be an easier way to do the EXPLAIN PLAN and TKPROF statistics than to edit your queries to add the commands (like EXPLAIN PLAN SET...), or to have to find or write a script that automates this? It should be an automatic part of SQL*Plus. Well, as of SQL*Plus 3.3 it is!! The command is called 'SET AUTOTRACE ON'!
(Added: 18-Nov-1999 Hits: 7713 Rating: 6.78 Votes: 9) Rate It
Health Check
- Look at the statistics of your Database
(Added: 6-Jul-2004 Hits: 5774 Rating: 10.00 Votes: 4) Rate It
See How Far Sorts Have Progressed
- This script will display the estimated work and time remaining for long operations (i.e. over 10 minutes).
(Added: 30-Nov-2001 Hits: 4031 Rating: 6.00 Votes: 2) Rate It
Types of Contention a Database Instance is (or is not) Experiencing
- This is possibly one of the most useful tuning scripts available. The V$SYSTEM_EVENT dynamic performance view is the highest-level view of the "Session Wait Interface". Information in this view is cumulative since the database instance was started, and one can get a very good idea of what types of contention a database instance is (or is not) experiencing by monitoring this view.
(Added: 30-Nov-2001 Hits: 5639 Rating: 6.60 Votes: 5) Rate It
Wait Sessions
- The Script lists the Session ID,Event Name,Time Waited on the Database. This Script is useful in identifying the resource intensive Queries. Can Be used on oracle 8i & 9i Databases.
(Added: 21-Sep-2005 Hits: 3223 Rating: 7.00 Votes: 1) Rate It
