Database Administration (MOSC)

MOSC Banner

unified_audit_trail

edited Jun 9, 2020 4:53PM in Database Administration (MOSC) 3 commentsAnswered

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center