cancel
Showing results for 
Search instead for 
Did you mean: 

Roll, extended and heap memory EXTM

former_member182034
Active Contributor
0 Kudos

hi Dear,

I am getting issue performance issue one new server while the system specs is:

*Processor 2 * x3690 X5, Xeon 8C E7-2820 105W 2.00GHz

Cache 18MB L3

Memory (Installed) 32 GB PC3L-10600 CL9 ECC DDR3 1333MHz

Instance Profile

Parameter Name                              Parameter value

em/initial_size_MB                          12288
ztta/roll_extension                         2000683008
abap/swap_reserve                           20971520
abap/heaplimit                              40894464
abap/heap_area_total                        15204352000
abap/heap_area_nondia                       0
abap/heap_area_dia                          2000683008
rdisp/PG_MAXFS                              32768
rdisp/PG_SHM                                16384
rdisp/ROLL_MAXFS                            32768
rdisp/ROLL_SHM                              32768
ztta/roll_area                              3000320
ztta/roll_first                             1024
rsdb/ntab/sntabsize                         9631
rsdb/ntab/irbdsize                          19261
rsdb/ntab/ftabsize                          96305
rsdb/ntab/entrycount                        64167
zcsa/presentation_buffer_area               14640128
rsdb/cua/buffersize                         8000
rtbb/buffer_length                          90000
zcsa/table_buffer_area                      30000000
abap/buffersize                             1500000
PHYS_MEMSIZE                                18432
login/no_automatic_user_sapstar             1
login/password_history_size                 5
login/fails_to_user_lock                    5
rsdb/obj/buffersize                         40000
rdisp/wp_no_dia                             12
rdisp/wp_no_btc                             3
rdisp/wp_no_enq                             1
rdisp/wp_no_vb                              2
rdisp/wp_no_vb2                             1
rdisp/wp_no_spo                             2
rsdb/obj/max_objects                        2500
rdisp/max_wprun_time                        2400

would you give me your expert Suggestion with respect to system Specs(Processor_8C and RAM_32gb)

Regards,

Accepted Solutions (1)

Accepted Solutions (1)

rupali_karbhari3
Active Contributor
0 Kudos

Hi,

Refer SAP Notes 116042,88416 for Memory relevent recommandations.

Regards,

former_member182034
Active Contributor
0 Kudos

Dear,

following dump is occurring when I execute tcods (MB51, QA32 etc) to get 6 month data.

TSV_TNEW_OCCURS_NO_ROLL_MEMORY

Each transaction requires some main memory space to process

application data. If the operating system cannot provide any more

space, the transaction is terminated.

TSV_TNEW_PAGE_ALLOC_FAILED

No more storage space available for extending an internal table.

DATA_LENGTH_0

CX_SY_RANGE_OUT_OF_BOUNDS

Invalid partial field access: Length 0

would anyone give me suggestion about following parameters w.r.t RAM.

Roll, extended and heap memory EXTM

ztta/roll_area        3000320     Byte
ztta/roll_first       1024        Byte
ztta/short_area       3200000     Byte
rdisp/ROLL_SHM        32768       8 kB
rdisp/PG_SHM          16384       8 kB
rdisp/PG_LOCAL        150         8 kB
em/initial_size_MB    12288       MB
em/blocksize_KB       4096        kB
em/address_space_MB   4096        MB
ztta/roll_extension   2000683008  Byte
abap/heap_area_dia    2000683008  Byte
abap/heap_area_nondia 0           Byte
abap/heap_area_total  15204352000 Byte
abap/heaplimit        40894464    Byte
abap/use_paging       0

or I have to configure the zero administration memory management.

Regards,

Former Member
0 Kudos

I suggest the modification of following parameters.

abap/heap_area_dia : 4000000000

abap/heap_area_nondia :4000000000

Regards

Purna

former_member182034
Active Contributor
0 Kudos

Hi Experts,

I am getting following dump

"TSV_TNEW_PAGE_ALLOC_FAILED" " "
"SAPLSRTT" or "LSRTTU07"
"SRTT_GET_DATA"
The amount of storage space (in bytes) filled at termination time was:

Roll area...................... 2718352
Extended memory (EM)........... 2002756912
Assigned memory (HEAP)......... 4000044160
Short area..................... " "
Paging area.................... 147456
Maximum address space.......... " "

while the current value of Extended & Heap Memory parameters are:

ztta/roll_area        3000320     Byte
ztta/roll_first       1           Byte
ztta/short_area       3200000     Byte
rdisp/ROLL_SHM        32768       8 kB
rdisp/PG_SHM          16384       8 kB
rdisp/PG_LOCAL        150         8 kB
em/initial_size_MB    16384       MB
em/blocksize_KB       4096        kB
em/address_space_MB   4096        MB
ztta/roll_extension   2000683008  Byte
abap/heap_area_dia    4000000000  Byte
abap/heap_area_nondia 4000000000  Byte
abap/heap_area_total  15204352000 Byte
abap/heaplimit        40894464    Byte
abap/use_paging       0

would any oracle Expert suggest me the suitable values of above parameters w.r.t (RAM 32 GB DDR3 1333MHz).

Regard,

Former Member
0 Kudos

Hi Mate,

Have you problem resolved , If not please provide me the following :-

1) When this dump occurs , ( during specific activity or anytime).

2) When ever the dump occured go to ST02 and History ( by Shift+F6) and provide the screenshot of last table in that page.

Please increase the ztta/roll_extension to 4GB i.e 4294967296.

If the issue still persists provide the answer of above two questions so that we can provide you the values for memory.

Thanks and regards

Gaurav

former_member182034
Active Contributor
0 Kudos

hi Gaurav,

1) When this dump occurs , ( during specific activity or anytime).

Dump is occurring against specific transaction when users are executing tcode with big selection criteria.

System: PRDSAP_PRD_00 Tune summary

Date + Time of Snapshot: 21.02.2012 09:37:21 Startup: 19.02.2012 22:05:14

Buffer             HitRatio %  Alloc. KB Freesp. KB % Free Sp. Dir. Size FreeDirEnt % Free Dir    Swaps  DB Accs
Nametab (NTAB)                                                                                0
  Table definition     86.81     21,809                          64,167                        127,586  192,179
  Field definition     77.90    101,318     45,098      46.83    64,167     50,613      78.88  109,591  123,279
  Short NTAB           98.44     11,636      8,958      93.01    16,041     13,391      83.48        0    2,650
  Initial records       0.99     21,266     14,669      76.16    16,041      2,860      17.83   53,460   66,641
                                                                                0
program                96.73  1,500,000    795,367      57.04   375,000    305,187      81.38        0  209,493
CUA                    99.30      8,000      3,129      47.71     4,000      3,754      93.85        0      252
Screen                 99.59     14,297      9,503      67.43     2,000      1,731      86.55        0      275
Calendar              100.00        488        366      76.57       200         48      24.00        0      152
OTR                   100.00      4,096      3,375     100.00     2,000      2,000     100.00        0
                                                                                0
Tables                                                                                0
  Generic Key          99.73     29,297      2,399       8.65     5,000      1,611      32.22       39   14,181
  Single record        88.77     90,000     51,599      57.45       500        403      80.60        0   72,187
                                                                                0
Export/import          92.43     40,000     34,517      88.28     2,500        975      39.00        0
Exp./ Imp. SHM         53.57      4,096      3,203      94.90     2,000      1,999      99.95        0



SAP Memory      Curr.Use % CurUse[KB] MaxUse[KB]  In Mem[KB] OnDisk[KB] SAPCurCach HitRatio %

Roll area            0.12        325      3,488     262,144          0   IDs           98.77
Page area            0.25        666     94,624     131,072    131,072   Statement     93.00
Extended memory      4.03    675,840  6,881,280  16,773,120          0                  0.00
Heap memory                        0  1,084,762           0          0                  0.00



Call Stati     HitRatio % ABAP/4 Req ABAP Fails DBTotCalls AvTime[ms]  DBRowsAff.

 Select single     99.84  1,755,375    267,018      9,898          0   1,488,357
 Select             1.53  1,471,444          0    561,166          0   5,708,457
 Insert             0.00    225,271      5,926     58,267          0   4,146,957
 Update             0.00        497         25        572          0         507

Parameters of SWAP entries

 Efficiency        HITRATIO          %        87
                   HITS                1,264,801
                   REQUESTS            1,456,982
                   DB access quality %        87
                   DB access             192,179
                   DB access saved     1,264,787
                   Reorgs                      0
 Size              Allocated        KB    21,809
                   Available        KB    18,297
                   Used             KB    18,297
                   Free             KB         0
                   Free             KB         0
 Directory entries Available              64,167
                   Used                   64,167
                   Free                        0
 Swaps             Objects swapped       127,586
                   Frames swapped              0
 Resets            Total                       0

you can check the starting date of above server while there are some users are login on this server for data testing.

would you suggest me the value of above parameters?

Regards,

Regards,

Former Member
0 Kudos

Hi,

Please increase the ztta/roll_extension to 4 GB .

Thanks and regards

Gaurav

former_member182034
Active Contributor
0 Kudos

Dear,

now the value of Roll area, Extended and Heap Memory is:

Roll Area

ztta/roll_first       1           Byte
ztta/roll_area        3000320     Byte
rdisp/ROLL_SHM        32768       8 kB
rdisp/ROLL_MAXFS    32768
rdisp/PG_SHM          16384       8 kB

Roll Area parameters value are OK?

here is default value of ROLL_SHM & MAXFS, how can i calculate the value of these parameter?

Extended Memory

em/initial_size_MB    16384       MB
em/blocksize_KB       4096        kB
ztta/roll_extension   4294967296  Byte
em/address_space_MB   4096        MB

here value of above Parameters are OK with respect to 32GB.

Heap Memory

abap/heap_area_dia    4000000000  Byte
abap/heap_area_nondia 4000000000  Byte
abap/heap_area_total  15204352000 Byte
abap/heaplimit        40894464    Byte

here I am bit confuse about abap/heap_area_total because dia and nodia have 4GB respectively while total parameters have big value 14GB.

Regards,

volker_borowski2
Active Contributor
0 Kudos

Hi,

"TSV_TNEW_PAGE_ALLOC_FAILED" " "
 The amount of storage space (in bytes) filled at termination time was:
 Roll area...................... 2718352
 Extended memory (EM)........... 2002756912
 Assigned memory (HEAP)......... 4000044160

So you program already allocated 6GB of memory before it runs out of storage.

Now this is the point to step back and ask yourself: Does it really have to do it?

The answer should be NO in 85% of the cases. In this case you have to redesign your program to

use less memory or use selection criteria, that do a limitation on the amount of selected data.

If the answer is YES (and correct), the next questions have to be:

How many users have to use it at the same time?

How much memory is really needed for one session?

Where is my training documentation about how a SAP process allocates memory?

A process allocates a small roll aera first and then allocates EM up to a max. of ztta/roll_extension

or available memory, whichever is first. It tries then to allocate HEAP up to heap_aerea_(non)dia.

Your process gets it all and dies with the maximum of allocated memory as to your parameters.

If you assume, your process will have allocate 10GB of memory to work correctly, and you will

likely have TWO of these that like to do this action, you should provide more memory for starters.

Might be SWAP in the beginning and if performance sucks, change it to RAM later.

Bringing down the HEAP to 4GB for bumping up EM is ok (to avoid processes go PRIV),

but you need to increase EM-max to ~24GB roll_extension to say 8 or 9 GB,

so that each of the both candidates can allocate up to the 10GB needed (with the rest taken from the HEAP).

How the rest of life will go on in your system with these settings needs to be monitored.

Volker

BTW, since the processors are x86 -> Is this Windows or Linux ?

Edited by: Volker Borowski on Mar 6, 2012 9:11 PM

former_member182034
Active Contributor
0 Kudos

hi Volker,

Thanks for your explanation and now I understood the scenario.

Dear, simple is here, currently, users are executing their Tcode with big selection criteria to verify their data between Current PRD server and New Server(Before Live). if you have look on following memory statistics than you will observed the Max use(KB) which was reached (Ext Mem -13,852,672 , Heap-9,998,988 ) with big selection criteria but as you know that in future, users have no need to execute these tcode with this selection criteria at same time.

SAP Memory      Curr.Use % CurUse[KB]  MaxUse[KB]  In Mem[KB] OnDisk[KB] SAPCurCach HitRatio %

Roll area            0.45      1,192       8,656     262,144          0   IDs           99.87
Page area            0.18        472      95,712     131,072    131,072   Statement     96.00
Extended memory     14.16  2,375,680  13,852,672  16,773,120          0                  0.00
Heap memory                        0   9,998,988           0          0                  0.00

current parameter is:

Roll, extended and heap memory EXTM
ztta/roll_area        3000320     Byte
ztta/roll_first       1           Byte
ztta/short_area       3200000     Byte
rdisp/ROLL_SHM        32768       8 kB
rdisp/PG_SHM          16384       8 kB
rdisp/PG_LOCAL        150         8 kB
em/initial_size_MB    16384       MB
em/blocksize_KB       4096        kB
em/address_space_MB   4096        MB
ztta/roll_extension   4294967296  Byte
abap/heap_area_dia    4000000000  Byte
abap/heap_area_nondia 4000000000  Byte
abap/heap_area_total  15204352000 Byte
abap/heaplimit        40894464    Byte
abap/use_paging       0

System Specs (PRD DB):

Processor 2 * x3690 X5, Xeon 8C E7-2820 105W 2.00GHz

RAM 32 GB

ECC 6 with Oracle 10.2.0.5 on Window Server 2008 SP2.

FYI.... Production server will consist on PRD_DB and PRD_APP server and each server on separate machine. I am asking about PRD_DB server.

How the rest of life will go on in your system with these settings needs to be monitored

then...what is your expert recommendation for Role, Extended and Heap Mem parameters?

Regards,

Edited by: majamil on Mar 7, 2012 7:05 PM

volker_borowski2
Active Contributor
0 Kudos

> How the rest of life will go on in your system with these settings needs to be monitored

then...what is your expert recommendation for Role, Extended and Heap Mem parameters?

Ha ha

I have no idea, because I do not know anything about the rest of action in your system.

I do not know, why your system has such a big heap, esp. on a windows system.

So if someone did set that for a reason, my advice might be well completely wrong.

I'd do (as for best guess, not knowing WHY you have 16G of Heap !!!):

heap dia/nondia = 2GB

heap total = 4 GB (to give any 2 procs the chance to allocate 2G) and to avoid early PRIV modes

em/max_size_MB probably 30GB, depending on what initial_MB is has now and taking into account

that reducing heap_total will give you 11GB back.

With these settings, your system is already configured deep into SWAP when on the edge, so provide enough SWAP.

In real life, you would always try to avoid this. So consider this just to be a setup to investigate, how much space

your guys really need.

Not sure how em_address_space_MB is handled in W2K8. Crosscheck the Defaults,

may have need to increase to em_max + 10%

may have need to increase to roll_extension + 10%

ztta/roll_extension... Humm. I'd give it a try with 8GB, just to see, how much space your application guys like to have.

If this is not enough, there might be need to seriously reconsider other strategies.

But to be honest, I have no idea if this will work for you.

Make Backup copies of your SAP-profiles before you apply these changes.

It might be possible, that your system is not starting any more when there is some memory shortage anywhere,

so you will need these copies to back out in worst case.

Volker

Edited by: Volker Borowski on Mar 7, 2012 10:01 PM

corrected em_max to roll_extension after re-reading

former_member182034
Active Contributor
0 Kudos

Dear Volker,

last one

thx for above recommendation for Roll and Extended Parameters.

as you know. Generally, we will assign RAM to DB,SAP and OS.

With 32 GB

For DB: (32 * 40) / 100 = 13GB

For SAP: (32 * 55) / 100 = ~18GB

For OS: ~3 to 4 GB

how can i distribute the RAM to DB and SAP Parameters respectively.

Oracle Parameter 13GB

db_cache_size=

shared_pool_size=

pga_aggregate_targe=

SAP Parameter 18GB

PHYS_MEMSIZE=

abap/buffersize =

em/initial_size_MB

Thanks man for sharing your knowledge and suggestion.

Thanks and Regards,

volker_borowski2
Active Contributor
0 Kudos

Dear Volker,

> last one

never promise things you can't keep

> thx for above recommendation for Roll and Extended Parameters.

> as you know. Generally, we will assign RAM to DB,SAP and OS.

> With 32 GB

> For DB: (32 * 40) / 100 = 13GB

> For SAP: (32 * 55) / 100 = ~18GB

> For OS: ~3 to 4 GB

Works for me in general, but if you have requests for big EM,

you might need to go swap and save a bit on DB.

So possibly:

db_cache_size= 8,5GB

shared_pool_size= 1 GB

pga_aggregate_targe= 1,5 GB - 2,0GB

SAP Parameter 18GB+swap

PHYS_MEMSIZE=15G

abap/buffersize = 1 GB

em/initial_size_MB = 6-10GB

rest as discussed above, depending on swap. (Or seach E-Bay for more RAM

Volker

former_member182034
Active Contributor
0 Kudos

Bundle of thanks respected Volker.

Regards,

Answers (0)