TSV_TNEW_PAGE_ALLOC_FAILED ST02

[former_member226585]

Good afternoon, colleagues.

I need help

The annex to the report, imebtsya system parameters.

I have a question on several counts:

1. I have allocated under Page 20UGb but MaxUse shows only 1 GB and the summit of the curr use of 97%, why?

2. Why onDisk = 0?

[willi_eimler]

Hi,

the "Roll/Page on Disk" is defined by:

Page on Disk = ( rdisp/PG_MAXFS * 8 ) - ( rdisp/PG_SHM * 8 )

ROLL on Disk = ( rdispROLL_MAXFS * 8 ) - ( rdisp/ROLL_SHM * 8 )

Your values for rdispROLL_MAXFS or rdisp/PG_MAXFS are to low

or

Your values for rdisp/ROLL_SHM or rdisp/PG_SHM are to high.

Best regards

Willi Eimler

[alwina_enns]

Hello Evgeniy,

please have a look at the note:

1572499 - Negative values in performance MTE R3PagingSizeKB

if it can help.

Which kernel release has the affected system and to which value the parameter rdisp/PG_MAXFS is set? If rdisp/PG_MAXFS is set to the same value like rdisp/PG_SHM, then the paging memory will be allocated only in the shared memory and not on the disk.

Regards,
Alwina

[Sriram2009]

Hi

In which OS / DB version detail?

BR

[former_member226585]

RHEL 6 \ Oracle 11g

[Sriram2009]

Hi

Could you refer the SAP Note

369726 - TSV_TNEW_PAGE_ALLOC_FAILED

BR

SS