Making the Most of Exadata
Aug 7, 2010 / By Marc Fielding
My article Making the Most of Oracle Exadata in the August 2010 issue of the NoCOUG Journal has come out. It covers Exadata’s feature set, and then dives deeper, discussing how to make the best use of its capabilities. For those of you not subscribers of the print edition, it’s also available electronically.
I’m also going to be presenting a webinar about Exadata this coming Wednesday, August 11, and speaking about Exadata at Oracle OpenWorld in September.
Just a point of clarification with recommended setting of CELL_PARTITION_LARGE_EXTENTS=TRUE: this parameter applies only partitioned tables, but does not change the extent allocation for non-partitioned tables. Given that the default and recommended extent management is AUTOALLOCATE, there really is no need worry about 8MB extents for small non-partitioned tables since CELL_PARTITION_LARGE_EXTENTS? does not apply to them. Manually setting INITIAL (to 8MB or larger) for large non-partitioned tables may be desirable though.
Hi Greg,
You’re entirely right: CELL_PARTITION_LARGE_EXTENTS applies only to partitioned tables. I’ve run into the issue of small initial extents mostly in heavily partitioned tables due to the large number of segments, but it can happen on any table.
And as you point out, manually setting 8m INITIAL extent size is the workaround for non-partitioned tables, assuming the tables are large enough to use them.
Marc
@Marc
If you’ve run into an “issue of small initial extents mostly in heavily partitioned tables due to the large number of segments”, then you didn’t set CELL_PARTITION_LARGE_EXTENTS=TRUE, did you as this is exactly what this parameter setting adresses.
Your article says to use CELL_PARTITION_LARGE_EXTENTS, but it does not mention that in order to get 8MB INITIAL it must be TRUE or ALWAYS. TRUE is the recommended setting.
Pingback: Exadata « Oracle Scratchpad
Pingback: Making the Most of Oracle Exadata – A Technical Review | Structured Data
Pingback: Making the Most of Exadata, revisited | The Pythian Blog
Pingback: Making the Most of Exadata, revisited | Singer Wang