unified_audit_trail
turned on unified audit on our oracle 12 standalone databases.
4 times a day we get 3 sys errors:
- return_code = 955 (object already exists)
- os_username = SYS
- action_name = "create global temporary table"
- sql_text (3)
1. wri$_adv_objspace_trend_data
2. wri$_adv_objspace_chrow_data
3. wri$_adv_segadv_segrow
My sysaux tablespace is not growing.
I didn't have standard audit on before turning on unified (may not be related to "new" unified)
we do have OEM running which could be related some databases report the error 4 times a day (0600, 1000, 1400, 2200 hours) others 3 (0400, 1600, 1800 hours)
the temporary sys tables appear to be valid