GreenLight Data Solutions, Inc. Technical Library 

Welcome to the technical library. This section includes white papers, technical specifications, network diagrams, and other information targeted at the technical members of your staff.

Oracle Scripts:

     Current Users - 04/30/2001 - Produce a report listing the users currently attached to the database.

     Database Mapping - 06/15/2000 - Produce a report showing the database datafiles, size, and location.

     Database Space - 06/05/2000 - Produce a report of the space used in the database.

     Oracle Parameters - 06/16/2000 - Produce a report of the Oracle initialization parameters and their current values.

     Oracle Tuning - 05/02/2000 - Produce a report showing memory and IO statistics.

     Database Check - 02/04/2002 - A combined report consisting of all the above reports (Current Users, database Mapping, Database Space, Oracle Parameters and Oracle Tuning).  This report executes all reports in a single sql statement.

     Oracle Stats Pack - 04/30/2001 - Collect performance data over time. Statspack was written for Oracle 8.1.6, however it can be installed and run in both Oracle 8.0 and Oracle 8.1.5 databases.

     http://otn.oracle.com - Oracle's technical support site.

Check back from time to time as we are continually updating this page