We recently upgraded our Oracle DB from 8i to 10g. Since that time running session ttaad4461m000 (Print Range of Audit Files) is taking too much time. I started a search on one table for one company over a 5 month time frame and 14 hours later it is still running.

Hi zelman,

at least in BaanIV the audit is based on binary audit fuiles usually lying in $BSE/audit. This is completely independent of the database ind performance of "print audit files" is not effected from an oracle migration.

Looks like you are using Baan5. Can soembody confirm this for this verson of Baan?

Regards

Markus

Check for the number of records in ttaud110 - Audit Transaction Notifications.

There might be millions of records if you are not purging the Audits periodically and try the Oracle analyze to update the stats.

NP i know the table i s there in baan5 , but i also believe that baan stores all the audit info back there in form of text file at O/S Level, is this table having just a header information or key information ?

Just trying to understand what sort of data this table contains ..... ?

Regards

Learner

The table contains the basic Audit Transaction Information and the flat files in $BSE/audit/a[package][module] directories and the files under there contain the actual audited table field data.

We recently upgraded our Oracle DB from 8i to 10g. Since that time running session ttaad4461m000 (Print Range of Audit Files) is taking too much time.

Hi,

How did u migrate from 8i to 10g? If export/import utility OR any DB utility has been used, you better Reorganize all the tables (In this case, all tools tables should be given higher priority) with "Data and Indices" option checked.