Oracle ASM threads

suvbin — Tue, 23 Jul 2024 02:22:55 GMT

Hi Qlik,

The task have 8 ASM threads configured and i read from the article (https://community.qlik.com/t5/Official-Support-Articles/Oracle-Optimizing-read-speeds-using-Oracle-ASM-storage/ta-p/1712080 ) that its default but the logs only show 2 threads used . Is the threads are related to the number of nodes? and why it is not using the rest of the threads. ? Is it related to volume of data?

But i am confused with the article. Can you please explain briefly.

Re: Oracle ASM threads

aarun_arasu — Tue, 23 Jul 2024 06:14:18 GMT

Hello @suvbin ,

Below are a few points to consider:

ASM threads can be configured based on the system's requirements. However, not all threads might be actively used at all times.

Here are some reasons why only 2 out of 8 ASM threads might be used:

- If the volume of data being processed is low, the system may detect that only 2 threads are sufficient for the current workload and will not activate additional threads unnecessarily.

- In a clustered environment, the number of threads might correspond to the number of nodes. If there are only 2 nodes in the cluster, each node might be utilizing one thread.

- There might be configuration settings or parameters that limit the number of threads used. Check the ASM configuration parameters to ensure they are set correctly.

Regards,
Arun

topic Oracle ASM threads in Qlik Replicate

Oracle ASM threads

Re: Oracle ASM threads