eSight Database Usage is High

eSight prompts high database usage as below;

1) Looked for dump logs to be cleared by navigating to the System Log page, then search for “Dump”. Cleared the logs however, the usage is still around 88%.

2) Once cleared, checked on nasmgr database for the usage. The usage is still high. Used sql ‘select segment_name,bytes from dba_segments where owner='NASMGR' order by bytes;’ to check who occupy the biggest space, and we find that a table named ‘tbl_fs_************’ occupy about 8G space but there is no records in this table.

3) Manually released the space of the table ‘tbl_fs_************’ by using sql ‘truncate table nasmgr.tbl_fs_************’ . Checked the usage and found it has been reduced drastically to 54%

4) Expanded the nasmgr database size to 100G and the result is as below;

The database usage is high. 

1) Cleared dump logs.

2) Located the data that is consuming a lot of database and released it.

3) Expanded the nasmgr size.