How to check memory distribution in the TemSe data storage in SAP ?

Login to SAP Application using SAP GUI then transaction SP12 -> TemSe database -> memory allocation

Here, you can check the distribution of your TemSe objects by age, client, and creator. For more information about this, see SAP Note 11070. Check whether the number of your TemSe objects is very large.

CAUTION:

The expiry time of the TemSe objects is usually unlimited. The reason for this is that a TemSe object should never be deleted without the relevant application object. Accordingly, the expiry date of the application object determines the lifetime of the Temse object. The retention period of the spool orders, for example, is stored in the table TSP01 and can be read in the header data for the spool request (transaction SP01).

NOTE THAT TEMSE IS NOT AN ARCHIVING SYSTEM.

Furthermore, the maximum permitted number of spool requests is limited (see SAP note 48284). Use archiving for spool requests.
Always ensure that the number of objects and the memory allocation do not continually increase in your system.