Hello -

Apart from OEM tool, can someone tell me how else can I monitor long running transactions and full table-scans in an oracle database? Any scripts?

Thanks