Below Procedure cache sizing formula, we can keep this handy with us Approximate calculation for memory needed in procedure cache:
2KB(context structure) -- Required for loading databases ( also in Cross Platform dump load )
+ 16KB(translation dictionary for system tables) ( Suppose we load into a different byte storage architecture in Cross Platform then system tables translational dictionary will be built for conversion)
+ 146KB(work memory to build translation dictionary for system tables and user tables) ( This will be required to build up the translational dictionary for initiating Cross Platform Load )
+ ((# of user tables) * 20 bytes) ( Normal estimation for user tables )
+ ((# of indexes on user tables) * 8 bytes) ) ( Normal estimation for user table indexes )
+ ((# of columns on user tables which needs translation + # of columns in index keys on user tables which needs translation) * 12 bytes) ( Number of columns of tables or indexes which have to be translated )
Example : 10,000 user tables + 40,000 indexes + 400,000 columns = 164KB + 200KB + 320 KB + 4.8 MB = 5.5MB
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment