Memory allocation much more than size of table TST03

[Former Member]

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 · Accepted solution]

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

[Former Member · Accepted solution]

Michael,

Excellent piece of info!