How to Clear Tablespaces memory without data loss?

Musadiq Hussain

Our team is using Oracle Database, and a single execution costs us GBs of memory in the tablespaces, after 150 executions we have 32GB*4 memory.

Please refer to the users' tablespace in the screenshot. After deleting data from the tables the memory owned by tablespaces didn't clear. Please suggest a way to clear the tablespaces memory without data loss. Thanks

asahide

Hi,

DELETE does not release the area.

The following may be helpful.

https://docs.oracle.com/en/database/oracle/oracle-database/19/cncpt/logical-storage-structures.html#GUID-0385358A-7F7F-4151-AAC4-F49B3B123852

Regards,