Memory allocation much more than size of table TST03
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
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)
A lob column is stored in a seperate segment:
[code]SQL> select SEGMENT_NAME from dba_lobs where table_name = 'TST03';
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$$';