 |
|
EnterpriseDB: Meta Data Reports
Oracle Tips by
Burleson
|
The Meta
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
The
Tables Meta Data report (Figure 6.22) provides information about the
tables in the database and schema selected.
Figure
6.22: Table Meta Data Report
Indexes
The
Indexes Meta Data report (Figure 6.23) provides information about the
Indexes in the database and schema selected.
Figure
6.23: Index Meta Data Report
Views
The
Views Meta Data report (Figure 6.24) provides information about the
views in the database and schema selected.
Figure
6.24: View Meta Data Report
Sequences
The
Sequences Meta Data report (Figure 6.25) provides information about
the sequences in the database and schema selected.
Figure
6.25: Sequence
Meta
Data Report
Procedural Logic
These
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.
In
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.
Figure
6.26: Procedural
Meta
Data Report
Security
The
security reports provide basic information useful for protecting your
database and ensuring its integrity.
Column Privileges
The
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.
Figure
6.27: Column Privileges Report
Constraints
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
some sense.
The
Constraints report (Figure 6.28) is a listing of all constraints in
the selected database and schema.
Figure
6.28: Constraints Report
Show Settings
The Show
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.
Figure
6.29: Show System Settings Report
EnterpriseDB Network
I wrote
about the EnterpriseDB Network in great detail in Chapter 2. The
EnterpriseDB Network is the place where customers can get support,
documentation and software.
The DBA
Management Server EnterpriseDB Network menu options help you track
what you have and help you ensure you stay current with your database
and tools.
Installed Products
The
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.
Figure
6.30: EnterpriseDB Network Installed Products
View Logs
The View
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.
Figure
6.31: View Database Log
Automatically Check Updates
The
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.
Figure
6.32: Configure Automatic Update
Check Updates Now
The
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.
Figure
6.33: Check for Updates
Online Help
The
Online Help option will launch your default browser and navigate to
the online documentation at the EnterpriseDB web site.
Conclusion
This
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.
The DBA
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
*
Graphical Dashboard
* User
and System Monitoring
* Log
File Monitors
* SQL
Profiling
* Job
Scheduler
*
Definition of JMS Destinations
*
Statistical and Options reporting
*
Automated Software Updates
* Online
Documentation
The next
chapter will detail the other major DBA tool, the EnterpriseDB
Replication Console for Oracle.
This
is an excerpt from the book "EnterpriseDB:
The Definitive Reference" by Rampant TechPress.
|
