Forum Stats

  • 3,875,502 Users
  • 2,266,930 Discussions
  • 7,912,239 Comments

Discussions

How to Clear Tablespaces memory without data loss?

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


Answers