RESULTS OF SUITE ON HANA SIZING IN GB Based on the selected table(s),the anticipated memory requirement is: Column store data 413.7 + Row store data 37.1 + Work space 450.8 + Hybrid LOB stored on disk 114.8 + Fixed size for code, stack and other services 50.0 ------------------------------------------------------------------------- = Anticipated total memory requirement considering 20% records stored on disk are cached in memory 974.6 Sizing report: /SDF/HDB_SIZING SID NEQ NW release: 702 SP 12 Date of analysis: 06/09/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,234 Number of tables partially analyzed: 4 Number of tables with error: 2 Error estimation in % due to tables with errors: .43 WARNING! The size of tables in error is too large. The sizing result is NOT reliable. Check the error log, correct the errors and re-execute the report.
TABLES NAMES ERROR MESSAGE/CODE (See FAQ) EDID4 99 DBTABLOG 98
TABLES PARTIALLY READ NUMBER OF RECORDS SAMPLED APQD 29976 DYNPSOURCE 13979 LIPS 20640 REPOLOAD 17809
LARGEST COLUMN ESTIMATED HANA ESTIMATED RECORD STORE TABLES MEMORY SIZE IN GB COUNT IBINVALUES 46.0 547,009,388 CDPOS 39.6 525,981,352 KONV 35.5 955,007,710 VBFA 11.8 263,726,290 GLPCA 10.2 124,709,898 BSEG 10.1 109,338,674 MSTA 10.0 307,905,681 ACCTCR 8.9 256,055,957 STXL 7.5 78,543,568 ACCTIT 6.7 85,540,329 FAGLFLEXA 5.9 92,998,898 MBEWH 5.7 173,821,815 JEST 5.4 193,084,337 LIPS 5.2 47,092,346 COEP 5.0 103,643,229 VBRP 5.0 47,779,215 BSIS 4.8 81,724,708 KONP 4.5 155,486,888 CDHDR 4.5 118,553,787 KONH 4.0 136,286,221
LARGEST ROW ESTIMATED HANA ESTIMATED RECORD STORE TABLES MEMORY SIZE IN GB COUNT APQD 22.3 80,379,748 D010TAB 3.6 29,697,187 D010INC 2.1 11,624,613 DD03L 1.6 6,352,013 ARFCSDATA 1.6 1,051,610 LTEX 0.9 339,619 DD04T 0.4 2,527,634 REPOTEXT 0.3 1,596,304 SEOCOMPODF 0.3 1,334,100 INDTEXT 0.3 906,910 ARFCSSTATE 0.3 413,873 DD02T 0.2 1,984,293 DDFTX 0.2 1,060,538 VARI 0.2 363,609 SMIMCONT1 0.2 131,550 DD05S 0.1 1,400,796 DD08T 0.1 1,218,540 DD07T 0.1 1,062,400 DD03T 0.1 723,419 DD08L 0.1 662,275
LARGEST COLUMN STORE ESTIMATED HANA ESTIMATED SIZE OF TABLES WITH LOB MEMORY SIZE IN GB DISK-BASED LOB IN GB SOFFCONT1 0.2 11.2 REPOSRC 0.7 5.5 STXL 7.5 0.1 N2EXTLOAD 0.0 0.1 IACTU_C1 0.0 0.1 CNVMBTCLU 0.0 0.1
LARGEST ROW STORE ESTIMATED HANA ESTIMATED SIZE OF TABLES WITH LOB MEMORY SIZE IN GB DISK-BASED LOB IN GB APQD 22.3 63.5 REPOLOAD 0.1 13.6 DYNPSOURCE 0.0 13.2 TST03 0.0 1.6 REPOTEXT 0.3 1.2 FPLAYOUTT 0.0 1.2 DYNPLOAD 0.0 1.2 ENHOBJCONTRACT 0.0 0.3 COVREF 0.1 0.2 FPCONTEXT 0.0 0.2 WDY_CTLR_COMPO 0.0 0.2 WDR_ADP_CONST_MP 0.0 0.2 ENHHEADER 0.0 0.2 SFDG 0.0 0.1 ENHLOG 0.0 0.1 D342L 0.0 0.1 D345T 0.0 0.1 ENHSPOTHEADER 0.0 0.1
TOTAL MEMORY REQUIREMENT IN GB WITH VARIOUS AMOUNT OF LOB CACHED IN MEMORY With all LOB records cached 1,066.4 With 80% of LOB records cached 1,043.4 With 50% of LOB records cached 1,009.0 With 20% of LOB records cached 974.6 With no LOB records cached 951.6
DETAILED SIZING PER COMPONENT ESTIMATED MEMORY SIZE IN GB Column Store tables: 163.0 of which is LOB: 15.9 Column Store keys: 250.7 including: - Primary keys: 176.9 - Row ID: 39.1 - Udiv: 1.0 - Secondary unique keys: 33.7 Row Store tables: 30.9 of which is LOB: 19.7 Row Store primary keys: 3.4 Row Store secondary keys: 2.8 LOB CS data stored on disk: 17.3 LOB RS data stored on disk: 97.5