My Oracle instance up on Amazon's RDS filled a 20GB storage in the space of about 20 minutes. I checked all the applications that use this DB and nothing looks out of the ordinary - I can't figure out why this would have happened.
See the graph from CloudWatch:
As you can see, I increased the storage to 25GB hoping that I might "shake something loose" - but obviously, all it did was increase my free space by 5GB.
This instance runs a very low traffic web app and you can see the free space has been very stable with the usage. 20GB should be more than enough for this system. What's going on?
Any tips for how I can figure out what's taking up all the space?
Edit: Some stats I managed to get from the DB:
SELECT
( SELECT SUM(BYTES)/1024/1024/1024 DATA_SIZE FROM DBA_DATA_FILES ) +
( SELECT NVL(SUM(BYTES),0)/1024/1024/1024 TEMP_SIZE FROM DBA_TEMP_FILES ) +
( SELECT SUM(BYTES)/1024/1024/1024 REDO_SIZE FROM SYS.V_$LOG ) +
( SELECT SUM(BLOCK_SIZE*FILE_SIZE_BLKS)/1024/1024/1024 CONTROLFILE_SIZE FROM V$CONTROLFILE) "Size in GB"
FROM
DUAL;
Produces:
Size in GB
------------------
19.360321044921875
And using a process of elimination, I figured out that it's DBA_TEMP_FILES
that's taking up 18 of the 19 GB.
What's in DBA_TEMP_FILES? How do I clear them out?