-
Title
Foglight fills recycle bin on Oracle database FMS repository -
Description
It seems the Foglight repository is dropping tables several times. The results of this drop table command is that the tables are moved into the Oracle recycle bin.
Is there a way to stop this behaviour?
-
Cause
This is an Oracle environment issue -
Resolution
The database recycle bin is controlled by the Oracle instance and the database administrator could disabled it.
Foglight is using the following command during installation to stop this behaviour:
alter system set recyclebin=off deferred;
But for any reason this setting could have been reverted.
The Foglight server generally do not drop tables, though it is possible that tables would be dropped, for example if there have been changes on the tablespaces itself. In this case it is possible that Foglight drops tables and recreates them using the old tablespace configuration in the new tablespace setup.