Return
-
Title
Oracle agent holds onto temp space on the monitored database host -
Description
A Foglight Oracle agent is holding on to temp space when an alter resize command is used to shrink a tempfile. The following message appears in SQL*Plus when a resize is attempted.
Alter database tempfile ‘/data4/oradata/MYDATABASENAME/temp01.dbf’ resize 20M
*
ERROR at line 1:
ORA-03297: file contains used data beyond requested RESIZE valueIs there any reason why the Oracle agent holds on to the temporary space?
-
Resolution
The Oracle agent uses temp segments because some of the collections (SQL statements) use sort operations.
Since this is the case, it would be reasonable that the HWM (high water mark) will be higher when the agent is up and running.