Oracle ASM threads

[suvbin]

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-A...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.

[aarun_arasu]

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