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.
Official Pythian® Blog
7 Comments. Leave new
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.
[…] Making the most of Exadata […]
[…] many of the key points of Exadata, however, even though I read (skimmed is a much better word) and briefly commented on the article back in August, after further review I found some technical inaccuracies with this […]
[…] real-world performance group posted a technical review of an article I wrote last summer, entitled Making the Most of Oracle Exadata. I have a few comments on the technical concerns Greg […]
[…] real-world performance group posted a technical review of an article I wrote last summer, entitled Making the Most of Oracle Exadata. I have a few comments on the technical concerns Greg […]