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


 

HTML Text

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.

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.

  
 

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