Ric Van Dyke is presenting at the 5th Annual Michigan Oracle User Summit on November 14, 2012. Ric's presentation is entitled "Journey to the Center of the Database", and his abstract is as follows:
When we run a SQL statement in Oracle that statement will access some number of blocks in the database to do the work we want. Many of us know the value of reducing the number of blocks read so as to achieve fast scalable SQL statement. But just what does this block look like? How are the rows actually stored in the block? Does block size have any significant impact on performance? What about the setting of PCTFREE, PCTUSED, MIN and MAXTRANS? In this presentation we will take a journey to the center of the database, the Oracle Block, and explore its interior to find answers to these questions.
The Michigan Oracle User Summit will be held at the Schoolcraft College in Livonia, MI.
Read more about the conference at www.mous.us.