EnterpriseDB: View DB Jobs
Oracle Tips by
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.
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.
6.15: View Scheduled Jobs
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.
not currently possible to reschedule a job. You need to delete
it and recreate it.
View Snapshot Jobs
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.
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
6.16: View Migration Jobs
disable or delete snapshot jobs. To reschedule a snapshot job,
you can delete it here and use Developer Studio to create the
DB Job Logs
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.
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
6.17: View Job Log
Currently, the only messaging supported is a simple interface to JBoss
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
6.18: JMS Queue Definition
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.
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.
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
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.
6.19: Table IO Report
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.
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
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.
6.20: Index IO Report
Column Statistics report (Figure 6.21) gives you detailed columnar
information including common values, average width and a numeric ratio
of distinct values.
6.21: Column Statistics Report
is an excerpt from the book "EnterpriseDB:
The Definitive Reference" by Rampant TechPress.