Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Documentation on APEX scheduler jobs?

dwdbaApr 18 2011 — edited May 10 2011
Does anyone have any documentation on what happens in the following Apex scheduler processes:

wwv_flow_maint.daily_maintenance
wwv_flow_cache.purge_sessions

There are two other ones as well, but I suspect one of these contains what I'm looking for.

As background, running Apex 4.0. We are having issues with the collection table statistics. When the tables have statistics (after reports using collections have been run) the reports run in a timely manner. However, over the weekend, when no one is running the reports, statistics are run against the collections tables (wwv_flow_collections$ and wwv_flow_collection_members$) and revert the row counts to 0. Come Monday morning, the queries run abnormally slow since the optimizer thinks the tables are emptly.

I would like to be able to generate statistics on the tables and NOT have them wiped out by some scheduler job. Just trying to figure out which one it is, as I will likely have to put in place a "counter" job to import statistics after the built-in job runs.

Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 7 2011
Added on Apr 18 2011
8 comments
904 views