Our BI Prod System is throwing the dump for "TSV_TNEW_PAGE_ALLOC_FAILED" error.
I have extended the parameters couple of times based on sap notes.
Please find the current parameter values set in our BI Prod system
em/global_area_MB = 250
We have 32GB RAM and 64 GB Paging space.
I'm attaching the details of "how to currect the error" from the ST22 dump below,
The amount of storage space (in bytes) filled at termination time was:
Roll area...................... 6221152
Extended memory (EM)........... 6000468352
Assigned memory (HEAP)......... 3000777840
Short area..................... " "
Paging area.................... 16384
Maximum address space.......... 4294967295
Please let me know, with my current memory availability, can I increase the parameter further and what should be parameter values.
Or Please let me know, how can I rectify this error.
Before you change the memory parameters, I would like to highlight some points which can help you making your decision :
1) If you are getting memory dump for a specific program, then firstly involve any developer to tune the records selection criteria from the tables. Often, it has been seen that the data selected from the tables in BW systems is quite high which is stored in runtime memory and uses SAP memory in the sequence of ext. and then heap.
2) If there is no chance to tune the program, then you have to change the memory parameters.
3) You need to consider the memory consumed by oracle and SAP both on the server and memory settings should fit into physicam RAM.
4) For eg. Database consumes 15 GB (SGA + PGA), so 17 GB can be used by SAP in this scenario.
With the above facts, it makes more relevant to ask you some questions :
a) Are you using Windows/Unix and 32bit/64bit OS ?
It is required to set the paramter ztta/roll_extension because the behavior of memory allocations changes accordingly
b) How much memory is allocated to your database software.
c) If you increase ext. memory for a WP, it is required to be calculated like how many WPs do you have and what can the total em size of your SAP
I hope I am not confusing you. Let me know if you have further queries.