-------------------------------------------------------------------------------- | RESULTS OF SUITE ON HANA SIZING IN GB | |------------------------------------------------------------------------------| | Based on the selected table(s),the anticipated memory requirement is: | | | | Column store data 93.6 | | + Row store data 13.9 | | + Work space 107.5 | | + Hybrid LOB stored on disk 45.1 | | + Fixed size for code, stack and other services 50.0 | | ------------------------------------------------------------------------- | | = Anticipated total memory requirement considering 20% records stored | | on disk are cached in memory 274.0 | -------------------------------------------------------------------------------- Sizing report: /SDF/HDB_SIZING SID NED NW release: 702 SP 12 Date of analysis: 06/06/2016 Version of the report: 44 Selected accuracy: M Number of work processes used: 01 Type of analyzed database: ORACLE Number of tables successfully analyzed: 83,487 Number of tables partially analyzed: 2 Number of tables with error: 1 Error estimation in % due to tables with errors: .62 ----------------------------------------------------------------------------------------------------- | TABLES NAMES ERROR MESSAGE/CODE (See FAQ) | |---------------------------------------------------------------------------------------------------| | DYNPSOURCE 98 | ----------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------- |TABLES PARTIALLY READ NUMBER OF RECORDS SAMPLED | |------------------------------------------------------------------------------| |REPOLOAD 14250| |RESB 18998| -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- | LARGEST COLUMN ESTIMATED HANA ESTIMATED RECORD | | STORE TABLES MEMORY SIZE IN GB COUNT | |------------------------------------------------------------------------------| | IBINVALUES 19.5 234,067,595 | | MSTA 3.7 116,037,789 | | KONV 2.3 64,137,150 | | MBEWH 2.2 66,640,201 | | DOKTL 2.2 60,230,315 | | JEST 2.1 77,488,322 | | RESB 1.9 27,769,901 | | KONP 1.8 62,554,580 | | ONR00 1.6 68,292,240 | | CE40010_ACCT 1.6 40,567,558 | | KONH 1.5 50,168,877 | | VBFA 1.4 32,457,543 | | A552 1.3 33,901,719 | | MBEW 1.3 19,616,289 | | ONROK 1.2 46,466,586 | | J_3ABUAFVV 1.2 36,562,907 | | J_3ABUAFRU 1.1 31,275,482 | | COKEY 1.1 19,589,153 | | MARC 1.1 17,320,779 | | KEKO 1.1 14,547,983 | -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- | LARGEST ROW ESTIMATED HANA ESTIMATED RECORD | | STORE TABLES MEMORY SIZE IN GB COUNT | |------------------------------------------------------------------------------| | D010TAB 3.7 30,664,146 | | D010INC 2.1 11,806,454 | | DD03L 1.6 6,401,747 | | APQD 0.8 3,015,069 | | DD04T 0.4 2,795,280 | | INDTEXT 0.4 996,192 | | LTEX 0.4 147,247 | | REPOTEXT 0.3 1,787,437 | | DDFTX 0.3 1,377,592 | | SEOCOMPODF 0.3 1,334,424 | | DD02T 0.2 2,200,458 | | DDPRS 0.2 1,419,235 | | SMIMCONT1 0.2 133,230 | | TST03 0.1 2,457,942 | | DD05S 0.1 1,400,597 | | DD08T 0.1 1,309,745 | | DD07T 0.1 1,158,165 | | DD03T 0.1 772,631 | | DD08L 0.1 703,217 | | DD40T 0.1 605,594 | -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- | LARGEST COLUMN STORE ESTIMATED HANA ESTIMATED SIZE OF | | TABLES WITH LOB MEMORY SIZE IN GB DISK-BASED LOB IN GB | |------------------------------------------------------------------------------| | REPOSRC 0.7 5.7 | | STXL 0.9 0.1 | | IACTU_C1 0.0 0.1 | | SOFFCONT1 0.0 0.1 | | N2EXTLOAD 0.0 0.1 | -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- | LARGEST ROW STORE ESTIMATED HANA ESTIMATED SIZE OF | | TABLES WITH LOB MEMORY SIZE IN GB DISK-BASED LOB IN GB | |------------------------------------------------------------------------------| | TST03 0.1 18.4 | | REPOLOAD 0.1 13.8 | | DYNPLOAD 0.0 1.4 | | REPOTEXT 0.3 1.3 | | FPLAYOUTT 0.0 1.3 | | ENHOBJCONTRACT 0.0 0.4 | | APQD 0.8 0.3 | | COVREF 0.1 0.2 | | FPCONTEXT 0.0 0.2 | | ENHHEADER 0.0 0.2 | | WDY_CTLR_COMPO 0.0 0.2 | | WDR_ADP_CONST_MP 0.0 0.2 | | SFDG 0.0 0.1 | | ENHLOG 0.0 0.1 | | SLIN_CACHE 0.0 0.1 | | ENHSPOTHEADER 0.0 0.1 | | D342L 0.0 0.1 | | D345T 0.0 0.1 | -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- | TOTAL MEMORY REQUIREMENT IN GB WITH VARIOUS AMOUNT OF LOB CACHED IN MEMORY | |------------------------------------------------------------------------------| | With all LOB records cached 310.1 | | With 80% of LOB records cached 301.1 | | With 50% of LOB records cached 287.6 | | With 20% of LOB records cached 274.0 | | With no LOB records cached 265.0 | -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- | DETAILED SIZING PER COMPONENT ESTIMATED MEMORY SIZE IN GB | |------------------------------------------------------------------------------| | Column Store tables: 32.9 | | of which is LOB: 4.4 | | Column Store keys: 60.7 | | including: | | - Primary keys: 37.9 | | - Row ID: 9.9 | | - Udiv: 0.3 | | - Secondary unique keys: 12.6 | | | | Row Store tables: 9.2 | | of which is LOB: 2.8 | | Row Store primary keys: 1.9 | | Row Store secondary keys: 2.8 | | | | LOB CS data stored on disk: 6.3 | | LOB RS data stored on disk: 38.8 | --------------------------------------------------------------------------------