How to audit a specific query in Oracle
You are right in that audits of &quot;audit&quot; statements need to be made at the object level.
Using Traditional Auditing, you can use a query to generate a script to enable audit tracking for existing objects:
select 'audit audit on '||owner||'.'||object_name;' from dba_objects where owner='[owner]';

After that, or ideally when you first configure your database and before you install any schemas, you can set auditing of audit to happen by default for all future created objects with:
audit audit by default;

With Unified Auditing you can do something like this:
create audit policy audit_actions actions audit table, audit view, audit procedure, audit package, audit directory;
audit policy audit_actions;