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
Michael Hofmänner replied
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$$';