SQL & PL/SQL

Hi All,

I was ask to audit the database DDL and DML's. I chose to implement Audit Vault, but unfortunately when i tap it to existing DB server, it slows down the database. So i deffer the implementation of Audit vault for the meantime.

Now I came across to Audit trail. But using it requires a lot of effort. you need to create your own sql statements, you need to identify first what are the columns you want to audit and etc.,

Now my first thing to do is to identify what are the most accessed tables in the database. Is there anyone who knows how to query this> or is there any data dictionary that can provide this info.?

We are using 11.5.10 E-Business Suite application and 10gR2 (10.2.0.3) database.

Hope somebody help.

Thanks,

Jay