Skip to Main Content



Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

Question and Answer

Tom Kyte

Thanks for the question, Bruce.

Asked: March 04, 2010 - 12:27 am UTC

Answered by: Tom Kyte - Last updated: January 14, 2020 - 2:33 am UTC

Category: Database - Version:

Viewed 10K+ times! This question is

Whilst you are here, check out some content from the AskTom team: Correcting datatypes with minimal downtime

You Asked

Hi Tom:

I want to know who Joh History works.

I have 2 jobs that need to run very frequently, about every 5 minutes. The Jobs are scheduled and are running without any problems. When I view the job history through the Dbconsole I see all of the runs and their status etc.

My concern is that this is a lot of data being stored for the job history. I am concerned about the amount of unneeded data over time.

Here are my questions:

1. In what table(s) are the job history records stored?
2. Does this table automatically purge old records or must I be concerned?

Thanks very much.


and we said...

and you rated our response

  (1 rating)

Is this answer out of date? If it is, please let us know via a Review


URL does not work

January 13, 2020 - 7:41 am UTC

Reviewer: A reader from Stockholm, Sweden

URL in answer does not work any longer.
Connor McDonald


January 14, 2020 - 2:33 am UTC

We've updated the link

More to Explore


Need more information on Administration? Check out the Administrators guide for the Oracle Database