Re: how to identify what sql statements are generating archived logs

I'd start with using the data out of V$SESS_IO. [EMAIL PROTECTED]> desc v$sess_io NameNull?Type --- SID NUMBER BLOCK_GETS NUMBER CONSISTENT_GETS

how to identify what sql statements are generating archived logs

Dear Listers: Any way (other than LogMiner) to easily identify what sql statements running now are generaing archived logs ? I have suddenly a lots of archived logs generated and almost fillup my file system. TIA --David Jones _