Dec 132017
 
Oracle Database Adminstrative Utility SQL Scripts. Automates a lot of the daily BDA chores and has an exxcellent collection of DBA reports.
File UTIL91.ZIP from The Programmer’s Corner in
Category Databases and related files
Oracle Database Adminstrative Utility SQL Scripts. Automates a lot of the daily BDA chores and has an exxcellent collection of DBA reports.
File Name File Size Zip Size Zip Type
ACTSIZE.SQL 2751 1041 deflated
BDELDAT.SQL 846 422 deflated
BDROPINX.SQL 836 426 deflated
BDROPOBJ.SQL 1218 480 deflated
BDROPPUB.SQL 935 442 deflated
BDROPSYN.SQL 859 422 deflated
BDROPTAB.SQL 828 416 deflated
BDROPVW.SQL 820 417 deflated
BLDINS.SQL 1808 626 deflated
BLDOLD.SQL 996 472 deflated
BRENTABS.SQL 882 438 deflated
BTABDUMP.SQL 2178 738 deflated
COLREP.SQL 1794 740 deflated
COLUSED.SQL 1583 699 deflated
DBFRAG.SQL 3780 1116 deflated
DBREP.SQL 2787 912 deflated
DBSPACE.SQL 1857 659 deflated
GRANTS.SQL 1510 693 deflated
INDEXES.SQL 1524 708 deflated
INSTANCE.SQL 715 367 deflated
SYNONYMS.SQL 1310 582 deflated
TABLES.SQL 1046 531 deflated
TITLE132.SQL 860 444 deflated
TITLE80.SQL 855 443 deflated
USERS.SQL 1581 655 deflated
UTILS.DOC 7320 1207 deflated
VIEWS.SQL 1152 570 deflated

Download File UTIL91.ZIP Here

Contents of the UTILS.DOC file


This document describes the files found on this reports/utilities disk.
All files are SQL*Plus scripts created on a VAX/VMS platform running
Oracle version 6.0 with verion 3.0 of SQL*Plus.

Most of the files require DBA privilege to execute and rely on the
DBA synonyms created in the Oracle account.

ACTSIZE.SQL -This SQL*Plus script produces a report that displays
the variation between what Oracle has allocated to a
table and the number of blocks it actually is using.
You must have DBA privilege to run this report and
must have the DBA synonyms created in your account.

BDELDATA.SQL - This SQL*Plus script builds a SQL*Plus script
that may be run to delete all data from tables
in the specified account.
You must have DBA privilege to run this
script and have the DBA synonyms created in
your account.

BDROPINX.SQL - This SQL*Plus script builds a SQL*Plus script
that may be run to drop all indexes in the
specified account.
You must have DBA privilege to run this
script and have the DBA synonyms created in
your account.

BDROPOBJ.SQL - This SQL*Plus script builds a SQL*Plus script
that may be run to drop all objects in the
specified account.
You must have DBA privilege to run this
script and have the DBA synonyms created in
your account.

BDROPPUB.SQL - This SQL*Plus script builds a SQL*Plus
script that may be run to drop all
PUBLIC synonyms in specified account.
You must have DBA privilege to run this
script and have the DBA synonyms created in
your account.

BDROPSYN.SQL - This SQL*Plus script builds a SQL*Plus script
that may be run to drop all private synonyms in
the specified account.
You must have DBA privilege to run this
script and have the DBA synonyms created in
your account.

BDROPTAB.SQL - This SQL*Plus script builds a SQL*Plus script
that may be run to drop all tables in the
specified account.
You must have DBA privilege to run this
script and have the DBA synonyms created in
your account.

BDROPVW.SQL - This SQL*Plus script builds a SQL*Plus script
that may be run to drop all views in the
specified account.
You must have DBA privilege to run this
script and have the DBA synonyms created in
your account.

BLDINS.SQL - This SQL*Plus script builds a SQL*Plus script
that may be run to insert data from a table
into another copy of itself. This is used
when modifying a table structure and the old
data needs to be loaded into the new table.
You must have DBA privilege to run this
script and have the DBA synonyms created in
your account.

BLDOLD.SQL - This SQL*Plus script builds a SQL*Plus script
that may be run to create tables as another
table with the OLD prefix in the specified
account.
You must have DBA privilege to run this
script and have the DBA synonyms created in
your account.

BRENTABS.SQL - This SQL*Plus script builds a SQL*Plus script
that may be run to rename all tables in the
specified account with the prefix OLD.
You must have DBA privilege to run this
script and have the DBA synonyms created in
your account.

BTABDUMP.SQL - This SQL*Plus script builds a SQL*Plus script
that may be run to dump data from a table
into a 1 record per page report.
You must have DBA privilege to run this
script and have the DBA synonyms created in
your account.

COLREP.SQL - This SQL*Plus report shows all columns in the database
for the specified table.
You must have DBA privilege to run this report and
must have the DBA synonyms created in your account.

COLUSED.SQL - This SQL*Plus report shows all tables in the database
where a specific column is used.
You must have DBA privilege to run this report and
must have the DBA synonyms created in your account.

DBFRAG.SQL - This SQL*Plus script will generate a
report to show the level of
fragmentation within the database.
You must have DBA privilege to run
this report and must have the DBA
synonyms created in your account.

DBREP.SQL - This SQL*Plus report shows information about the
various components of the database
You must have DBA privilege to run this report and
must have the DBA synonyms created in your account.

DBSPACE.SQL - This SQL*Plus script creates a report that
shows the amount of space allocated to the
various objects in the database.
You must have DBA privilege to run this report
and must have the DBA synonyms created in your
account.

GRANTS.SQL - This SQL*Plus report shows all grants in the database.
You must have DBA privilege to run this report and
must have the DBA synonyms created in your account.

INDEXES.SQL - This SQL*Plus report shows all indexes in the database
for the specified table and owner.
You must have DBA privilege to run this report and
must have the DBA synonyms created in your account.

INSTANCE.SQL - This SQL*Plus script creates and loads a table named
INSTANCE to be used to indicate in reports which database
is being reported against in a multiple-instance
environment.
Grants are made to PUBLIC. A PUBLIC synonym should
be created to allow access by anyone.

SYNONYMS.SQL - This SQL*Plus report shows all synonyms in the
database for the specified owner.
You must have DBA privilege to run this report and
must have the DBA synonyms created in your account.

TABLES.SQL - This SQL*Plus report shows all tables in the database
for the specified owner.
You must have DBA privilege to run this report and
must have the DBA synonyms created in your account.

TITLE132.SQL - This SQL*Plus script builds a standard report
heading for database reports that are 132 columns

TITLE80.SQL - This SQL*Plus script builds a standard report
heading for database reports that are 80 columns

USERS.SQL - This SQL*Plus report shows all users in the database.
You must have DBA privilege to run this report and
must have the DBA synonyms created in your account.

VIEWS.SQL - This SQL*Plus report shows all views in the database.
You must have DBA privilege to run this report and
must have the DBA synonyms created in your account.


 December 13, 2017  Add comments

Leave a Reply