SQL Query Running on One Thread in Windows 2003
Hi Everyone,
I'm having difficulties explaining to my client why their Oracle 10g RAC Database (3 nodes) running on Windows 2003 only use on thread when running a query which causes only 1 thread goes up to 100%.
The database is utilized for an OLTP purpose so basically the tables designed here don't have parallelism attribute (or it is set to noparallel).
Overall performance of the database looks good to me despite those queries utilizing 100% CPU usage.
The question from my client was why can't we make the database or the program utilize multiple threads while processing the queries.
I did explain that this is an OLTP database and the tables involved in the queries do not contain any parallelism attribute nor the queries use the parallelism hint.
I'm having difficulties explaining to my client why their Oracle 10g RAC Database (3 nodes) running on Windows 2003 only use on thread when running a query which causes only 1 thread goes up to 100%.
The database is utilized for an OLTP purpose so basically the tables designed here don't have parallelism attribute (or it is set to noparallel).
Overall performance of the database looks good to me despite those queries utilizing 100% CPU usage.
The question from my client was why can't we make the database or the program utilize multiple threads while processing the queries.
I did explain that this is an OLTP database and the tables involved in the queries do not contain any parallelism attribute nor the queries use the parallelism hint.
0