Press Summary
What To Expect from Oracle’s Release of World’s Fastest Chip
April 1st, 2013
Written by Centroid
On March 26th 2013, Larry Ellison, the CEO of Oracle unveiled a new Sun Microprocessor. Oracle acquired Sun in 2010 and made several changes to the company, they now claim that they surpassed their competition in microprocessor industry, and that the new chip is the fastest in the world. This chip will now be used to run Oracle’s server, and it is expected that Oracle databases and applications will now function faster than ever. Larry Ellison also mentioned that the new ‘SPARC T5’ chip is just...
Automatic DOP and Oracle EBS
January 30th, 2012
Written by John Clarke
What is Auto DOP?Starting with 11g, Oracle introduced Automatic Degree of Parallelism, or Auto DOP. I’ve blogged about this at http://www.centroid.com/knowledgebase/blog/automatic-degree-of-parallelism-in-oracle-11gr2. I’m not going to review all the ins and outs of Auto DOP in this post. Here, I’ll talk about a few things specific to Oracle e-Business Suite that are worth noting. Enabling Auto DOP: First Tests ...
Oracle 11gR2 SQL Monitoring
January 22nd, 2012
Written by John Clarke
What is SQL Monitoring? Starting with 11g, Oracle introduced a new tool to add to the performance optimizer’s toolkit called “Real Time SQL Monitoring”. Real Time SQL Monitoring, or just “SQL Monitoring”, enables you to measure the performance of SQL statements while they are executing. SQL Monitoring is enabled any time a statement runs in parallel or when it consumes more than 5 seconds of CPU or IO time. Oracle populates V$SQL_MONITOR and V$SQL_PLAN_MONITOR views with...
Automatic Degree of Parallelism in Oracle 11gR2
November 29th, 2011
Written by John Clarke
What is Parallel Execution?At a very high level, parallel execution is a means for Oracle to “divide and conquer” the process of fetching data Oracle tables. See http://docs.oracle.com/cd/E14072_01/server.112/e10837/parallel.htm#CACEEBJJ. Parallel execution in Oracle allows a single database operation to apply multiple CPU and IO resources (i.e., processes) to work together to retrieve the results. Parallel execution is often a desirable goal when and if:A large amount of data...
Parallel Execution and Partitioning
November 29th, 2011
Written by John Clarke
What is Parallel Execution?At a very high level, parallel execution is a means for Oracle to “divide and conquer” the process of fetching data Oracle tables. See http://docs.oracle.com/cd/E14072_01/server.112/e10837/parallel.htm#CACEEBJJ. Parallel execution in Oracle allows a single database operation to apply multiple CPU and IO resources (i.e., processes) to work together to retrieve the results. Parallel execution is often a desirable goal when and if:A large amount of data...
