Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

SQL Query parallel

SachinP-OracleOct 21 2024

The output of lscpu

Architecture: x86_64
CPU op-mode(s): 32-bit, 64-bit
Byte Order: Little Endian
CPU(s): 96
On-line CPU(s) list: 0-95
Thread(s) per core: 2
Core(s) per socket: 24
Socket(s): 2

I have 96 virtual CPUs. If I execute 300 parallel threads in JAVA code for DML operation and all 300 are hitting the DB at same time that means , only 96 will be executing at the same time and rest of 204 threads will be in waiting ? May be the waiting time would be fraction of second? Is my understand correct?

Comments
Post Details
Added on Oct 21 2024
0 comments
26 views