Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
suvbin
Creator III
Creator III
‎2024-07-22 10:19 PM

Oracle ASM threads

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.

 

Labels (2)
Labels
1,053 Views
1 Reply
aarun_arasu
Support
Support
‎2024-07-23 02:14 AM

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

1,012 Views