audits

1. What is the SQL that will report all objects and actions that are being audited within any specific instance?
2. I have an instance where hundreds of users all login with the same Oracle username and can store Oracle Browser queries within the DB. This has resulted in thousands & thousands of views being stored within the DB. Is there a way to enable auditing against just views (owned by a specific schema)? If so, how? The idea being that after a few months of auditing I'll be able to generate a report of those views that have not been used & be able to delete them.

Comments, ideas & suggestions are welcomed.

TIA & HAND!

-- 
Charlie Mengler                               Maintenance Warehouse  
charliem_at_mwh.com                              5505 Morehouse Drive   
858-552-6229                                  San Diego, CA 92121    
There is a fine line between vision & hallucination. Don't cross it!