This content has been marked as final. Show 5 replies
970371 wrote:IMO it's highly unlikely to happen. The file size would only increase if there is any data entry happening from some source or the other. The file's size wont increase on it's own AFAIK.
Hi DBA Guru(s),
I have a general question that, if the size of data file is growing automatically without intervention of
users then what would be the reason.
Well, we could see some significant growth for the datafile(s) that make up the SYSAUX tablespace,
especially with a short snapshot interval (on a RAC DB with many nodes , possibly) and a very long snapshot retention.
This would happen without any user activity even ;-)
"Don't believe it, test it!"