Hi Team,
We had enabled auditing for named users in our database including for select statement.
Recently while checking our sys.aud$ entries, we could see that for each query fired from sqldeveloper there are multiple entries in the sys.aud$, all of which are seen to be executed by the person who executed the actual query.
Following query is seen repeatedly seen executed by this user. This is not seen while executing from sqlplus. How can we avoid this scenario, because its filling up our SYS.AUD$ table like anything as well as searching from SYS.AUD$ had become cumbersome.
We are using the latest version of Sqldeveloper 21.4.1.349
"
select tab_count
from
(select count(*) tab_count from all_tables where owner = :"SYS_B_0" and table_name = :"SYS_B_1")
where tab_count > :"SYS_B_2"
and exists (select null from GSMADMIN_INTERNAL.cloud)
"
Regards,
Vivek