When the database server receives a row that is longer
than a page, the row is stored in as many whole pages as required.
The database server then stores the trailing portion in less than
a full page.
The page that contains the first byte of the row is the
row home page. The number of the home page becomes the logical page
number contained in the rowid. Each full page that follows the home
page is referred to as a big-remainder page. If the trailing portion
of the row is less than a full page, it is stored on a remainder page.
After the database server creates a remainder page to
accommodate a long row, it can use the remaining space in this page
to store other rows.
Remainder Pages illustrates the concepts
of home page, big-remainder page, and remainder page. Figure 1: Remainder Pages
Have feedback?
Google Analytics is used to store comments and ratings. To provide a comment or rating for a topic, click Accept All Cookies or Allow All in Cookie Preferences in the footer of this page.
