I would like to have the commands or a scripts that will show me files that are not open by any process and meet a certain pattern (ie arch.log1_117512.dbf).
Basically I a wanting to delete all arched redo logs that oracle has popped out execpt for the current one it is writting to. I am assuming that the ones it is done writting to are not opened by any process.
I have searched through my books and I can not find anything telling me how to determine if a file is open and who has it open.
A breif explanation of any commands given would be greatly appreciated.