oracle 11g on Linux. How do I know which oracle process/job updates data files?How?
ski123 wrote:every file in the DB gets written to every time SCN changes.
I know Db writer, log writer and checpoint. But I want to know which job is updating that data file. let's say, I have one data file (not oracle system files), I want to drop it because the users don't use it any more. But I found somehow, this file is updated all the time. Assuming no activity on this file, why it is updated?
So I like to know in which way, I can find who is updating this file?