This site was created to host online resources related to the Apress book Expert Oracle Exadata. The book was published in July of 2011 and was authored by Kerry Osborne, Randy Johnson and Tanel Poder. The technical reviewer was Kevin Closson. The primary purpose of this site is to provide online copies of the scripts used in the book and post errata as necessary. We expect to also use this site to answer questions related to the book. Please feel free to drop us a note with any questions or comments.
Hi,
Thank you for the good book. Would you be able to comment the following please
1/ there is typo
p.192
Chapter 7 Resource Management
Step 3: Start Load Test
create table skew (
pk_col number,
col1 number,
col2 varchar2(30 byte),
col3 date,
col4 varchar2(1 byte) );
create index skew_col2 on skew (col2);
create index skew_col2 on skew (col2); <– same index twice ?
2/ How to re-create the 'skew' table? Guessing some sort of PL/SQL was used to load test data.
Thanks,
Serg
Hi Rich,
The current spec sheet describes them this way:
Exadata Storage Servers X2-2 with 12 x 600 GB 15,000 RPM High
Performance SAS disks or 12 x 2 TB 7,200 RPM High Capacity SAS disks
The 2TB drives are definitely slower, but in many systems that is covered up by the Exadata Smart Flash Cache.
Kerry
I believe there is a typo on page 11 where you say “the disks will either be 2TB or 600GB SAS drives”.
I’m pretty sure the 2TB are SATA and hence slower.