-------------------------------------------------------------------------------- | RESULTS OF SUITE ON HANA SIZING IN GB | |------------------------------------------------------------------------------| | Based on the selected table(s),the anticipated memory requirement is: | | | | Column store data 19,8 | | + Row store data 35,5 | | + Work space 55,3 | | + Hybrid LOB stored on disk 7,0 | | + Fixed size for code, stack and other services 50,0 | | ------------------------------------------------------------------------- | | = Anticipated total memory requirement considering 20% of | | records stored on disk are cached in memory 162,0 | | = Anticipated net data size on disk 89,5 | -------------------------------------------------------------------------------- Sizing report: /SDF/HDB_SIZING Version of the report: 50 Date of analysis: 05.06.2022 Selected accuracy: M Number of work processes used: 01 SID BIP NW release: 730 SP 13 Type of analyzed database: ORACLE Database version: 11.2.0.3.0 Unicode system Yes Number of tables successfully analyzed: 28.232 Number of tables partially analyzed: 0 Number of tables with error: 1 ----------------------------------------------------------------------------------------------------- | TABLES NAMES ERROR MESSAGE/CODE (See FAQ) | |---------------------------------------------------------------------------------------------------| | RSD99 Sampling error | ----------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------- | LARGEST COLUMN ESTIMATED HANA ESTIMATED RECORD | | STORE TABLES MEMORY SIZE IN GB COUNT | |------------------------------------------------------------------------------| | BALDAT 9,1 27.628.424 | | RSBMLOGPAR_DTP 1,4 38.922.917 | | RSBMONMESS_DTP 0,8 28.722.476 | | RSDDSTATDTP 0,7 9.998.233 | | /BIC/AQCFIOGL140 0,6 23.025.251 | | EDIDS 0,6 11.640.991 | | /BIC/B0000476000 0,3 7.402.867 | | REPOSRC 0,3 1.272.312 | | DOKTL 0,2 5.780.872 | | EDID4 0,2 5.169.576 | | SRRELROLES 0,2 5.147.322 | | BALHDR 0,2 4.331.248 | | /BI0/AFIAR_O0300 0,2 3.919.657 | | /BIC/AQCFIOGL100 0,2 3.829.091 | | /BIC/B0000444000 0,2 3.689.171 | | /BIC/AQCSDOTRK00 0,2 3.667.800 | | /BIC/B0000612000 0,2 3.611.878 | | /BIC/FQCFICGL1 0,1 12.950.716 | | /BI0/F0FIAR_C03 0,1 10.614.479 | | /BI0/SDOC_NUMBER 0,1 7.076.748 | -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- | LARGEST ROW ESTIMATED HANA ESTIMATED RECORD | | STORE TABLES MEMORY SIZE IN GB COUNT | |------------------------------------------------------------------------------| | RSBATCHDATA 10,0 4.372.396 | | RSBMREQ_DTP 6,2 96.823.056 | | RSMONMESS 3,8 11.963.958 | | RSBKDATA 2,8 1.010.069 | | D010TAB 1,7 12.044.644 | | RSMONIPTAB 1,6 7.369.115 | | D010INC 1,0 4.817.044 | | RSMONFACT 1,0 4.729.708 | | RSBKDATAPAKID 0,8 10.453.170 | | RSBKDATAPAKSEL 0,7 10.664.528 | | RSPCINSTANCE 0,6 1.993.541 | | RSPCPROCESSLOG 0,5 700.736 | | RSREQDONE 0,5 547.547 | | PKRT_LOAD_DEP 0,4 5.440.738 | | RSSELDONE 0,4 419.929 | | DD03L 0,3 1.203.266 | | RSBATCHCTRL 0,3 641.209 | | DDPRS 0,2 1.146.570 | | SEOCOMPODF 0,2 802.477 | | PKRT_LOAD 0,2 754.077 | |------------------------------------------------------------------------------| -------------------------------------------------------------------------------- | LARGEST COLUMN STORE ESTIMATED LOB ESTIMATED RECORD | | TABLES WITH LOB SIZE ON DISK COUNT | |------------------------------------------------------------------------------| | REPOSRC 1,7 1.272.312 | | TFRT_BLOB 0,2 27 | | STXL 0,1 66.183 | -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- | LARGEST ROW STORE ESTIMATED LOB ESTIMATED RECORD | | TABLES WITH LOB SIZE ON DISK COUNT | |------------------------------------------------------------------------------| | REPOLOAD 2,8 123.053 | | PKRT_LOAD 0,9 754.077 | | WDR_ADP_CONST_MP 0,2 12.737 | | DYNPLOAD 0,2 12.689 | | REPOTEXT 0,1 150.729 | | WDY_CTLR_COMPO 0,1 104.424 | | ECSCR_XML_STR 0,1 24.582 | | RSOTLOGOHISTORY 0,1 6.827 | | RSXCLSDATA 0,1 90 | -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- | TOTAL MEMORY REQUIREMENT IN GB WITH VARIOUS AMOUNT OF LOB CACHED IN MEMORY | |------------------------------------------------------------------------------| | With all LOB records cached 167,6 | | With 80% of LOB records cached 166,2 | | With 50% of LOB records cached 164,1 | | With 20% of LOB records cached 162,0 | | With no LOB records cached 160,6 | -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- | DETAILED SIZING PER COMPONENT MEMORY SIZE IN GB | |------------------------------------------------------------------------------| | Column Store tables: 13,3 | | Column Store keys: 6,5 | | including: | | - Primary keys: 4,6 | | - Row ID: 1,8 | | - Udiv: 0,1 | | - Secondary unique keys: 0,0 | | | | Row Store tables: 27,2 | | Row Store primary keys: 3,5 | | Row Store secondary keys: 4,8 | | | | LOB CS data stored on disk: 2,0 | | LOB RS data stored on disk: 5,0 | --------------------------------------------------------------------------------