Questions On Threadpoolworker Stop Process (Doc ID 2013477.1)

Last updated on JULY 31, 2015

Applies to:

Oracle Utilities Meter Data Management - Version 2.1.0.2 and later
Information in this document applies to any platform.

Goal

Questions on the threadpoolworker stop process:

1) What are the issues /concerns when the Threadpoolworkers are stopped when the batches are running.
Due to the time taken for all threadpoolworker restarts especially during the critical usage loading process where time is of essence, we generally stop all TPWs.


2) Do you need to always truncate the F1-TSPACE_ENTRY table before all TPWs start back up?


3) We see that there are some sessions under INACTIVE for hours even after the batch job completes successfully and don't free until the Threadpoolworker restart. Wanted to understand if this is an expected behavior.



Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms