EnterpriseDB: Meta Data Reports
Oracle Tips by
Data reports are probably the least useful of the supplied reports.
In the real world, you will probably use Developer Studio to see this
kind of meta data.
Tables Meta Data report (Figure 6.22) provides information about the
tables in the database and schema selected.
6.22: Table Meta Data Report
Indexes Meta Data report (Figure 6.23) provides information about the
Indexes in the database and schema selected.
6.23: Index Meta Data Report
Views Meta Data report (Figure 6.24) provides information about the
views in the database and schema selected.
6.24: View Meta Data Report
Sequences Meta Data report (Figure 6.25) provides information about
the sequences in the database and schema selected.
reports are probably the least useful of all the reports provided.
The procedural reports contain a source code listing for each of the
following: Packages, Procedures, Functions, and Triggers.
These reports can be very large.
Figure 6.26, the Package report is listed. As the data in each
of these reports is basically the same (just a source code listing), I
will only display the one example.
security reports provide basic information useful for protecting your
database and ensuring its integrity.
Column Privileges report (Figure 6.27) is a basic report showing the
selected role's column permissions to the objects in the selected
database and schema. I think it would make sense to have a table
report with the same type of information, but you can infer the table
information from the column information.
6.27: Column Privileges Report
I am not
entirely sure why this report is listed under a security heading.
I guess if we say that security includes data integrity, then it makes
Constraints report (Figure 6.28) is a listing of all constraints in
the selected database and schema.
6.28: Constraints Report
Settings report (Figure 6.29) is probably my favorite report out of
all the provided reports. This report gives you a single place
to view all of your EnterpriseDB Advanced Server settings. Even
though it is included in the Security reports, it contains settings
for everything. I save off the PDF file whenever I make system
changes. That way I have a history of changes made.
6.29: Show System Settings Report
about the EnterpriseDB Network in great detail in Chapter 2. The
EnterpriseDB Network is the place where customers can get support,
documentation and software.
Management Server EnterpriseDB Network menu options help you track
what you have and help you ensure you stay current with your database
first option in the EnterpriseDB Network options is the installed
products page (Figure 6.30). This is a simple listing of all
installed products and their versions.
6.30: EnterpriseDB Network Installed Products
Logs page (Figure 6.31) allows you to view Automatic Update log files.
You should periodically check this log to ensure that you do not have
any network errors preventing your software from updating.
6.31: View Database Log
Automatically Check Updates
Automatically Check Updates page (Figure 6.32) allows you to configure
the frequency that you would like to check for updates and allows you
to define your EnterpriseDB Network user id and password.
6.32: Configure Automatic Update
Check Updates Now
Check Updates Now page (Figure 6.33) will immediately connect to the
EnterpriseDB Network and inform you of any available updates. If
any updates are available, you can click on the link provided and
download the update. Follow update instructions to install.
6.33: Check for Updates
Online Help option will launch your default browser and navigate to
the online documentation at the EnterpriseDB web site.
chapter provided detailed information on the DBA Management Server,
which was introduced in Chapter 2. The DBA Management Server is
a robust, enterprise-class database management tool provided with the
EnterpriseDB Advanced Server.
Management Server includes everything a DBA needs to monitor and
troubleshoot an EnterpriseDB cluster. Some of the features
provided by the EnterpriseDB DBA Management Server are:
Consolidated Monitoring of Multiple Servers and Databases
and System Monitoring
Definition of JMS Destinations
Statistical and Options reporting
Automated Software Updates
chapter will detail the other major DBA tool, the EnterpriseDB
Replication Console for Oracle.
is an excerpt from the book "EnterpriseDB:
The Definitive Reference" by Rampant TechPress.