Appendix A
Oracle Table Sizing Information
This appendix provides information to help you estimate the extent size for tables used in iPlanet Market Maker. The list in the Table A-1 gives the average row length for each of the tables for a simulation environment conducted using real users.
|
Note
|
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 many inserts, deletes, or updates. However, the row lengths can be used to calculate the initial and next extent storage parameters of the core tables.
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 initial and next extent sizes.
You can also refer to Tuning Oracle section in Chapter 4 "Performance Tuning and Monitoring," for a few examples of extents sizes for core tables of iPlanet MarketMaker installation.
Table A-1 can be used as a guide for sizing the extents for each of the Oracle tables in a production environment.
Table A-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
|
92
|
|
EXC_MEMBER
|
73
|
|
EXC_EXCHANGE_STATUS
|
76
|
|
EXC_ORDER_AXES
|
54
|
|
EXC_ORDER_REQUESTS
|
239
|
|
EXC_ORDERS_TEMP
|
45
|
|
EXC_ORDER_REQUEST_CRITERIA
|
17
|
|
EXC_ORDER_REQUEST_LIFESPAN
|
19
|
|
EXC_TRADE_MASTER
|
51
|
|
EXC_TRADE_UNITS
|
77
|
|
EXC_TRADE_UNIT_AXES
|
12
|
|
EXC_QUOTE
|
35
|
|
EXC_NVP_EXT_PASSIVE_ORDER
|
49
|
|
EXC_NVP_EXT_PASSIVE_AXIS
|
54
|
|
EXC_NVP_EXT_ACTIVE_ORDER
|
n/a
|
|
EXC_NVP_EXT_ACTIVE_AXIS
|
n/a
|
|
EXC_NVP_EXT_TEMP_MATCHES
|
n/a
|
|
EXC_NVP_EXT_MATCH_RESULTS
|
n/a
|
|
EXC_COMPANY_ACCOUNT
|
88
|
|
EXC_TRADER_ACCOUNT
|
69
|
|
EXC_ORDER_AUDIT_LOG
|
127
|
|
EXC_COMPANY_PREFER
|
73
|
|
EXC_SYMBOL_STATUS
|
21
|
|
EXC_PROCESSED_MESSAGES
|
29
|
|
EXC_PUB_MESSAGES_M
|
n/a
|
|
EXC_PUB_MESSAGES_D
|
n/a
|
|
EXC_PUB_STATUS
|
6
|
|
EXC_MATCHING_ENGINE_LOCK
|
11
|
|
EXC_NVP_PASSIVE_ORDER
|
49
|
|
EXC_NVP_PASSIVE_AXIS
|
54
|
|
EXC_NVP_ACTIVE_ORDER
|
n/a
|
|
EXC_NVP_ACTIVE_AXIS
|
n/a
|
|
EXC_NVP_TEMP_MATCHES
|
n/a
|
|
EXC_NVP_MATCH_RESULTS
|
n/a
|
|
EXC_ORDER_SCHEDULER
|
57
|
|
EXC_ORDERS
|
103
|