cancel
Showing results for 
Search instead for 
Did you mean: 

delete temp table from HANA

Former Member
0 Kudos

When i call report in BOBJ (which use universe on Calc view )in Administration i see that this report use more than 2 GB RAM.

When report is done i see the same value of memory, but when HANA delete data from temp table which i use in Calc view?

Thanks!

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member182277
Contributor
0 Kudos

Hi llya,

As per my knowledge, its taking time to release the memory and many time you have to restart the database.

Like in HANA if I am loading the data and then I am deleting the data, it take some time to release the memory.

But if you are using same then its remain active in the main memory.

Hope it's helpful.

Regards,Neha

Former Member
0 Kudos

So if i understand coorectly,after generation report my temp table is still in the memory.

In my CV several temp tables:var_bseg  and other.

if i run report several times my temp tables creates once and then system only read from this temp table ?

former_member182277
Contributor
0 Kudos

yes, you can say like this. See, to free the from memory it took sometime..instantly it will not release the memory. It's for few minute/seconds only. If you will say for long hour then that is wrong.

Hope is clear your doubt..

Regards,

neha

duncanspeidel
Advisor
Advisor
0 Kudos

Hi IIya,

As far as I know, HANA uses a least recently used method to decide when an object is removed from memory.  This allows it to be reused if the view is called again. 

Best regards,

Duncan