Call (800) 766-1884 for Oracle support & training
Free Oracle Tips

Oracle Consulting Support
Oracle Upgrades
Use New Oracle Features
Oracle Replication Support
Oracle Training
Remote Oracle DBA
System Documentation
Oracle Tips
Oracle Performance

Free Oracle Tips



BC Oracle tuning

Oracle training

Oracle support

Remote Oracle




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.


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


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


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


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


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


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.


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.


Oracle performance tuning software 

Oracle performance tuning book


Oracle performance Tuning 10g reference poster
Oracle training in Linux commands
Oracle training Excel
Oracle training & performance tuning books



Copyright © 1996 -  2014 by Burleson. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation. 

Hit Counter