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: View DB Jobs
Oracle Tips by Burleson
 

To see the jobs that have been scheduled, the DBA Management Server provides the View DB Jobs page.  The View DB Jobs page displays all currently defined jobs across all of the databases being managed by this instance of the DBA Management Server.

As you can see from Figure 6.15, the page displays the database where the job is running, the text of the code that was scheduled, the last time it ran, the next time it will run and two buttons.

Figure 6.15: View Scheduled Jobs

You can disable the schedule by pressing the Disable button.  You will then be able to re-enable the schedule.  You can remove the job by pressing the Delete button. 

It is not currently possible to reschedule a job.  You need to delete it and recreate it.

View Snapshot Jobs

Snapshot jobs are the regularly scheduled snapshots that migrate objects and/or data from Oracle to EnterpriseDB.  The jobs are configured via Developer Studio.  I provided an example of that in Chapter 5.

Figure 6.16 displays the job scheduled in Chapter 5.  It is a schedule snapshot of the EMPLOYEES table for HR@ORA92 which is being copied to HR@EDB.

Figure 6.16: View Migration Jobs

You can disable or delete snapshot jobs.  To reschedule a snapshot job, you can delete it here and use Developer Studio to create the snapshot.

DB Job Logs

The Job Log is a log file that captures DBMS_OUTPUT output from your scheduled jobs.  You should always put some kind of output message so that you can check the success of your job.  I also prefer to keep the job itself minimal and have it call packaged procedures.

Figure 6.17 provides a display of the Job Logs page.  You can select the log to view from the drop down and press the refresh button.  You can also press the refresh button at any time to see any new log records.

Figure 6.17: View Job Log

Messaging

Currently, the only messaging supported is a simple interface to JBoss using JMS.

JMS Destinations

On the JMS Destination page, Figure 6.18, you can create new destinations (queues or topics) and you can delete existing topics.  To create a new destination, enter the destination name and press the Create button.

Figure 6.18: JMS Queue Definition

The EnterpriseDB support group can provide a simple client and instructions for using the JMS destinations.  As this is really an interface to JBoss, it is outside the scope of this book.

Reporting

The EnterpriseDB DBA Management Server provides several useful reports for monitoring what is happing in your database.  The Reporting feature offers four types of reports: statistics, meta data, procedural logic and security.

Statistics

The statistic reports help you understand how your database is being used.  You can find the "HOT" tables, those that have the heaviest load.  You can also find indexes that are not being used and remove them.

Table IO Detail

For the Table IO report (Figure 6.19), you will need to choose both a database and a schema to view.  The report will show you a list of tables and information about how those tables are being used.

Figure 6.19: Table IO Report

A good thing to look for would be active tables (disk reads) with a high mem reads number.  You want the actual data in the table to be read as infrequently as possible and you want to read that data from memory as often as possible. 

It is also good to know the update, insert and delete activity of your tables.  Hot tables may need to be moved to their own tablespace on a different drive.

Index IO Detail

The Index IO report (Figure 6.20) is to indexes what the Table IO report is to tables.  Index IO takes time and CPU.   If you monitor this report over time and see an index that is never being used (or is only used lightly in a heavily transaction oriented system), you may want to remove the index and see who screams.

Figure 6.20: Index IO Report

Column Statistics

The Column Statistics report (Figure 6.21) gives you detailed columnar information including common values, average width and a numeric ratio of distinct values.

Figure 6.21: Column Statistics Report


     

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