Skip to Main Content

Breadcrumb

Dev Live Dev Intro

This month we are celebrating Developers at AskTOM. We welcome Developers of all levels of experience to join us at our FREE Developer Live events coming in August. Just click on the left to register today! If you are brand new to Database Technology, then we also have got you covered. Just click on the right for your comprehensive FREE training program to kick start your Oracle Database Development journey!

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: 10.1.0.5

Viewed 10K+ times! This question is

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.

Bruce

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

Reviews

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

Followup  

January 14, 2020 - 2:33 am UTC

We've updated the link

More to Explore

Administration

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