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 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.
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