Re: Jobs submitted under OEM start but do not finish

davepashby.google_at_solmanoz.freeserve.co.uk (pashda) wrote in message news:<334c7316.0306030145.4c0ffd91_at_posting.google.com>...
> We are trying to track down the source of a problem and would
> appreciate any pointers on where to start looking.
>
> Oracle 9i ( 9.2.0.1.0 ) runing on Windows 2000 Advanced Server.
> Compaq Hardware, 2GB RAM, SANS disk storage.
>
> We have a number of jobs that have been started are still showing as
> "started" through OEM long after they should have finished. These are
> jobs that should only take seconds to run, but are still not finished
> after several days.
>
> Q2. Are there any other tools that could be used to monitor the
> progress and state of any submitted jobs to see why they might have
> stalled?

You are asking for monitoring software to monitor ... monitoring software.

This is exactly why I stopped using OEM.

I wouldn't go that route if you decided to use OEM then make it work - open a TAR with Oracle Support and get them to fix the problem. Did it ever work? Adding another bolt-on APP on top of OEM is just going to add one more weak link to the chain that's already falling apart.

Regards,

Vitaliy
DBAToolZ.com (free sql scripts + SQLDIR parser) Aspeda.com (free Oracle monitoring tool) Received on Wed Jun 04 2003 - 01:11:43 CDT