Memory Space

[Rahulbatra]

I want to reorg my memory and also do some refreshment in my memory utilization in my Oracle database. I want to get the size of System Global Area. For doing this does oracle have any command or do I need to write a SQL query. In case kindly let me know how to do this?

[Ralph]

There is no separate utility called reorg in oracle. But wait!! There is option for reclaim space which you can make use in your database. This would help you in unused space reclaiming. It is also possible for you to take up reclustering of data which would increase further more efficiency of your database handling.