Database Administration (MOSC)

MOSC Banner

Does the SYS_AUTO_SQL_TUNING_TASK include shrinking of user tables

in Database Administration (MOSC) 3 commentsAnswered ✓

We are running an Oracle Enterprise RDBMS 19.23 on a Windows NT 64 system. In the last month I have started seeing Unified_audit findings with the error 10636 (Shrink tablex failed due to Move not being enabled).
This event is being run by the DB Service account originating on the db server (J002) at exactly 10pm, the only activity at that time is the SYS_AUTO_SQL_TUNING_TASK.
So I am asking is it possible that it being done as part of the automatic tuning job .

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

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center