Database Tuning (MOSC)

MOSC Banner

Optimizer Statistics History Information Become Huge due to Automatic Statistics Gathering Job Run M

edited Sep 30, 2020 3:06PM in Database Tuning (MOSC) 1 commentAnswered

Hello,

I face issue described in (Doc ID 2305512.1)

The plan is to:

1. Disable SA task

2. Clean SYSAUX TBS

3. Enable SA task to get rid of ORA--20001 "Statistics Advisor: Invalid task name for the current user"

4. alter system set "_autotask_max_window"=2400 scope=spfile

5. Database bounce

I have question regarding Doc ID 2501155.1, point 4 in above plan

As a solution we have two options patch or workaround.

As I have currently Oracle 12 with APR2020 patches I prefer to apply workaround for a time being and apply patch after applying JUL2020 patches.

My current value for _autotask_max_window:

Parameter                                      Default Va Session Va Instance V IS_SESSION IS_SYSTEM_

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