Appendix A
Oracle Table Sizing Information
This section will help you estimate the extent size for tables used in iPlanet Market Maker.
The list in the Table 0-1, "Oracle table sizing information," on page ii gives the average row length for each of the tables for a simulation environment conducted using real users. The average lengths are based on one installation of iPlanet Market Maker software; the actual average lengths for each installation may vary. Care should be taken to add an additional buffer of 30 percent to account for variations.
The average row lengths are provided to assist in storage calculations for each of the tables. The storage calculations need not be done for small or stagnant tables because they would not have a lot of inserts, deletes, or updates. However, the row lengths can be used to calculate the core tables' initial and next extent storage parameters.
The following formula can be used to estimate the size of the table in blocks:
Table size in blocks = total_records / ((((blocksize - block header) - (inittrans *23)) * ((100 - pctfree)/100)) / (average_row_length +3 + number of columns + number of long columns))
where block_size, and block header are in bytes.
The inittrans, and pctfree (for example, inittrans = 1; pctfree = 40) are specified as absolute numbers for the table.
Number of bytes used by inittrans = 23 bytes (used in the above formula).
Average Row Length = estimated average row size for the table.
Total Records = total number of records estimated for the table.
Based on the total table size in blocks, you can estimate the intial and next extent sizes.
Also, refer to "Tuning Oracle" for a few examples of extents sizes for core tables of iPlanet Market Maker installation. The following table can be used as a guide to size the extents for each of the tables in a production environment.
Table 0-1 Oracle table sizing information
|
Table Name
|
Average Row Length
(Bytes)
|
|
ATTACHMENTS
|
121
|
|
AUC_ACCESS_LIST
|
70
|
|
AUC_AUCTION
|
273
|
|
AUC_AUCTION_RUNTIME
|
77
|
|
AUC_AUCTION_STATUS
|
39
|
|
AUC_AUCTION_TYPES
|
90
|
|
AUC_BID_HISTORY
|
210
|
|
AUC_FAVORITE
|
69
|
|
AUC_POLICY_ATTR
|
67
|
|
CAT_ATTR
|
148
|
|
CAT_ENUM
|
n/a
|
|
CAT_ENUM_VALUES
|
n/a
|
|
CAT_MASTER
|
73
|
|
CAT_MASTER_ENTRY
|
130
|
|
CAT_SEARCH_ATTR
|
83
|
|
CAT_UNIT
|
13
|
|
CAT_VIEW
|
106
|
|
CAT_VIEW_COMPANY_FILTER
|
70
|
|
CAT_VIEW_ENTRY
|
179
|
|
CAT_VIEW_ROLE_MAP
|
69
|
|
CMN_CONFIGS
|
770
|
|
CMN_CONFIG_PROFILE
|
649
|
|
CMN_JOB_SCHEDULER_ENTRY
|
168
|
|
CMN_LOG
|
138
|
|
CMN_LOG_NOTIFY_CONFIG
|
45
|
|
CMN_PLM
|
59
|
|
CMN_PLM_DATE
|
21
|
|
CMN_PLM_INT
|
16
|
|
CMN_PLM_STRING
|
38
|
|
COM_ADDRESSES
|
121
|
|
COM_COMPANIES
|
193
|
|
COM_UPDATE_LOG
|
83
|
|
COM_USERS
|
216
|
|
INBOX_ENTRY
|
133
|
|
MAIL_INFO
|
329
|
|
OMS_APPROVAL_CONFIG
|
88
|
|
OMS_APPROVER
|
135
|
|
OMS_BILL_INFO
|
102
|
|
OMS_BILL_INFO_TEMPLATE
|
179
|
|
OMS_LOCATION_TEMPLATE
|
n/a
|
|
OMS_NOTE
|
184
|
|
OMS_ORDER
|
387
|
|
OMS_ORD_LINE_ITEM
|
187
|
|
OMS_PAYMENT_
|
|
|
METHOD_TEMPLATE
|
112
|
|
OMS_PAY_INFO
|
59
|
|
OMS_REQUISITION
|
308
|
|
OMS_REQ_LINE_ITEM
|
186
|
|
OMS_SHIP_INFO
|
110
|
|
OMS_SHIP_INFO_TEMPLATE
|
182
|
|
PRI_EXCH_RATE
|
34
|
|
PRI_PRICING_RULE
|
1197
|
|
PRI_RULE_GROUP
|
103
|
|
RFX_REPLIES
|
292
|
|
RFX_REPLIES_ATTS
|
72
|
|
RFX_REPLIES_ATTS_D
|
n/a
|
|
RFX_REPLIES_ATTS_H
|
71
|
|
RFX_REPLIES_D
|
0
|
|
RFX_REPLIES_H
|
341
|
|
RFX_REPLY_ITEMS
|
224
|
|
RFX_REPLY_ITEMS_D
|
n/a
|
|
RFX_REPLY_ITEMS_H
|
217
|
|
RFX_REQUESTS
|
230
|
|
RFX_REQUESTS_ATTS
|
71
|
|
RFX_REQUESTS_ATTS_D
|
71
|
|
RFX_REQUESTS_ATTS_H
|
70
|
|
RFX_REQUESTS_D
|
230
|
|
RFX_REQUESTS_H
|
250
|
|
RFX_REQUEST_ITEMS
|
201
|
|
RFX_REQUEST_ITEMS_D
|
190
|
|
RFX_REQUEST_ITEMS_H
|
203
|
|
RFX_REQUEST_RECIPIENTS
|
92
|
|
RFX_REQUEST_RECIPIENTS_D
|
75
|
|
RFX_REQUEST_RECIPIENTS_H
|
76
|