Multithreading with Oracle
639485May 16 2008 — edited May 17 2008Hi all,
I used Max threads=12 and 16 processors(files) with partitions for SQL query for improving the performance.How Multithread concept will work with this Processors when we partitioned the se files.
eg: we have 12 threads.
Threads : 1 2 3 4 ..... 12
Files : 1 2 3 4 .......12
13 14 15 16
I know it will work like this.then my doubt is I know theoretically. can any one please explain me practically how it works?
Thank you.