PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

AE Timings in table - How to clear them out.

edited Jun 19, 2015 10:01AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 1 commentAnswered

We have turned on AE timings to do performance tracing. We want to keep some history so we can judge timing differences after tuning indexes and SQL. But I'm trying to think ahead and prevent the table from growing hugely.
Does anyone have a script/dms to clear these tables out?

Or better yet an Archive Template?

I would prefer to be able to do so by date and/or process name, but if someone knows all of the affected tables that can be safely cleared out I should be able to work on my own process.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center