-------------------------------------------------------------------------------- | 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 | --------------------------------------------------------------------------------