How Oracle 11g leverages the features of Multi-core Architectures [message #393395] |
Sun, 22 March 2009 09:36 |
pkgthomas
Messages: 5 Registered: March 2009
|
Junior Member |
|
|
Hi,
I am investigating on the oracle 11g features which leverages the features of Multi-core architectures. Can you please give me some articles/papers/web-links which at least gives an introductory aspects of this.
Do you have some ideas about oracle features which oracle has provided for DB performance on multicore architectures.
Regds
Thomas
|
|
|
|
|
|
|
Re: How Oracle 11g leverages the features of Multi-core Architectures [message #393643 is a reply to message #393598] |
Tue, 24 March 2009 00:09 |
pkgthomas
Messages: 5 Registered: March 2009
|
Junior Member |
|
|
okk
so lets not make any confusion ... what I am looking is below
1. How the performance of oracle 11g will differ when we have that DB configured on a SingleCore m/c Vs Multicore M/C ?
2. Does Oracle provides any special handling to tune its performance on a multi-core system; if yes, do you have any idea how it is done?
3. Do we have any programming model exposed by oracle or any other vendor where we can embedded the Sql query in a traditional threading code. I think we can do threading programming (POSIX or OPENMP) with SQL queries in ProC. But not very sure.
I have tried to illustrate at a high level what I am looking for, still if you feel more discussions/details are required, your suggestions/comments are welcome.
|
|
|
|