My Oracle Support Banner

Questions On Threadpoolworker Stop Process (Doc ID 2013477.1)

Last updated on NOVEMBER 07, 2018

Applies to:

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


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.


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.