Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Memory allocation much more than size of table TST03

Hi all,

I found a strange situation, in our system, memory allocation in SP12 shows 2GB is used in DB side, but when I go to transaction DB02 to check the table TST03, it only has 50MB. Our parameter rspo/store_location is already set to 'db'.

System environment is: ECC6 running on AIX 53/Oracle 10g, 64bit.

In my opinion, temse data will be stored in TST03, so I think TST03 size should be larger than memory allocation result in SP12.

Could you please help me about this?

Thanks and regards

Former Member
Former Member replied

Hi Justin

Nice question, really made me think. I just checked, in the newer SAP versions, TST03 has a BLOB column, in the older versions there was a LONG RAW col.

I bet you have the BLOB (ECC6), you can check in sqlplus:

[code]SQL> desc sapsr3.tst03

Name Null? Type

-


-


-


DCLIENT NOT NULL VARCHAR2(9)

DNAME NOT NULL VARCHAR2(60)

DPART NOT NULL NUMBER(5)

DROWNO NOT NULL NUMBER(10)

DDATALEN NOT NULL NUMBER(5)

DCONTENT BLOB[/code]

A lob column is stored in a seperate segment:

[code]SQL> select SEGMENT_NAME from dba_lobs where table_name = 'TST03';

SEGMENT_NAME

-


SYS_LOB0000031954C00006$$[/code]

Just replace your segment_name to get the size, you can enter the segment in DB02 too:

[code]SQL> select BYTES/1024/1024 "SIZE_MB" from dba_segments where segment_name = 'SYS_LOB0000031954C00006$$';

SIZE_MB

-


12[/code]

Regards

Michael

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question