Structure

Table

every table has three linked list to orgnize 3 kinds of extent.

• FREE List
• FREE_FRAG List
• FULL_FRAG List

every table has many segment

• SET_INODES_FULL List
• SET_INODES_FREE List

when segment SET_INODES_FREE List is not enough, It will get a page from table’s FREE_FRAG List.

Table Structure

Table Information

FSP_HDR page store the table information, locate in the first extent, first pag.

Detail as follow

Segment

• every segment associate a INODE Entry
• INODE Entry are stored in INODE page.
• INODE Page controlled by two double linked list
  • SEG_INODES_FULL
  • SET_INODES_FREE

Segment structure

INODE Page : locate in first extent, third page.

INODE Entry

Extent

Extent Structure

Page

Basic Page: File Header + File Trailer

File Header

Page Type

FIL_PAGE_INDEX Page

Detail as follow.

Page Header

Other Information

• index page and file page are separate into different segment.
• when a table’s data has been over 32 pages, it will allocate extent rather than page.