Press Summary
CellCLI Utilities
May 9th, 2012
Written by John Clarke
Those familiar with Exadata's CellCLI command line interface often find themselves wondering what sorts of cell metrics are available, and if there's an easy-to-use interface to gather this data without having to look in the manual every time. I'm one of those guys, so I took some time and put some little shell scripts that might be able to help. The Utilities celldig.sh: Provides a menu-driven interface for cellclicellstats.sh: Provides a command-line interface for...
Managing Data in the 21st Century - Part 1
February 28th, 2012
Written by Jim Brull
This is the first of a three part series on "How Smart Companies Manage Data in the 21st Century." I am going to focus on trends and statistics for this first part and then as we progress, we will dive into how to get actionable information out of data.
In the past 10 years, data generated globally has grown faster than our ability to store and manage it. According to IDC, "Over 2 gigabytes of information are being produced per person, per year. 95% of that data is unstructured with only...
Auto DOP, Cell Offload, and Oracle EBS
January 30th, 2012
Written by John Clarke
Imagine you've recently migrating your Oracle e-Business Suite to Exadata, and you've decided to implement automatic degree of parallelism, or Auto DOP. How does this impact Smart Scan? Let's test by first ensuring that our Auto DOP is set to MANUAL: APPS @ visx1> alter system set parallel_degree_policy=MANUAL; System altered. Elapsed: 00:00:00.02APPS @ visx1> alter system flush shared_pool; System altered. Elapsed: 00:00:00.04APPS...
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...
