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