| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 Auto-statistics size from sysindexes.sql | SQL Server 7.0 | Intermediate /
Umachandar | 10799 since
7/18/2000 8:37:26 AM |
By 1 Users
|
| |
How to determine the size taken by the auto-statistics in a database. |
| |
| |
| |
 |
 build control and real-time statistics into your PL/SQL loops | Oracle | Beginner /
Andy Archer | 8922 since
5/2/2006 2:26:25 AM |
By 4 Users
|
| |
Code examples, with narrative, that illustrate how to build control and real-time statistic
gathering into PL/SQL loops. |
| |
| |
| |
|
Data File IO Control | Oracle | Advanced /
Jony Safi | 8657 since
9/23/2003 5:10:04 PM |
By 1 Users
|
| |
To view the IO per data file in the database. |
| |
| |
| |
|
Example of using user-defined counters.sql | SQL Server 7.0 | Intermediate /
Umachandar | 10337 since
7/18/2000 8:38:16 AM | Unrated
|
| |
How to set user-defined counters |
| |
| |
| |
|
Find processes over time limit | Informix
| Intermediate /
Steven Hauser | 9439 since
7/11/2000 10:56:38 PM |
By 1 Users
|
| |
By Steven.Hauser-1@tc.umn.edu Find non root processes with more than TLIMIT minutes of CPU time. For machine Sun Solaris 2.6
|
| |
| |
| |
|
find the SQL and PL/SQL executing for active sessions | Oracle | Advanced /
Andy Archer | 5646 since
4/17/2009 9:13:55 AM |
By 1 Users
|
| |
This SQL*Plus script executes a PL/SQL block to find the SQL and PL/SQL that is executing for active sessions. Also shows execution duration in seconds and pertinent session info. Good for tracking progress. (ScreenShot) |
| |
| |
| |
|
Forecefully disconnect users from a DB | SQL Server 7.0, SQL Server 6.5 and earlier | Intermediate /
Umachandar | 16768 since
7/27/2000 9:18:29 PM |
By 2 Users
2 Excellent Ratings
|
| |
How to forcefully disconnect users from a DB. This script also contains some timing features so that it doesn't run forever. |
| |
| |
| |
|
How to Use Log Miner DBMS PACKAGE | Oracle | Advanced /
Eli Leiba | 10245 since
1/12/2003 3:17:56 AM | Unrated
|
| |
Explains the usage of DBMS_LOGMNR in details |
| |
| |
| |
|
Log Record Changes | SQL Server 7.0 | Beginner /
Lewis E. Moten III | 10849 since
5/14/2002 4:28:15 PM |
By 1 Users
|
| |
Make a copy of records within a table each time it is updated or a new record is created. This is very basic stuff. I'll be working on an update to handle primary keys and such. |
| |
| |
| |
|
Monitor blocking in SQL70 | SQL Server 7.0 | Advanced /
Umachandar | 10196 since
7/23/2000 2:23:43 PM |
By 2 Users
|
| |
This utility SP was taken from a KB article on how to monitor blocking in SQL70. You can find the KB article at http://support.microsoft.com/view/dev.asp?kb=251004 |
| |
(ScreenShot)
