11 reputation
1
bio website
location
age
visits member for 2 years, 1 month
seen Jan 8 '13 at 11:40

Feb
3
awarded  Teacher
Jul
4
comment Should I expect a great increase in Oracle performance in terms of handling multiple requests switching from single to dual core?
@TomTom This is correct, in general. However, in this case we are told that the DBS size is 100G, there is only one vCPU and significant raise in CPU consumption during the query. These facts indicate that CPU power may be the bottleneck. However, since disk I/O plays a major role in databases, it would also be important to analyze the behavior of the database deeper for example with Statspack. That would also tell if the CPU really is what is needed.
Jul
4
answered display sql syntax in Oracle's sqlplus?
Jul
4
answered Should I expect a great increase in Oracle performance in terms of handling multiple requests switching from single to dual core?
Jul
4
answered Install Oracle 11g on Ubuntu using rpm package?