SQL Performance (MOSC)

MOSC Banner

DBMS_GATHER_STATS

in SQL Performance (MOSC) 1 commentAnswered

Hello,

We are using the same PL/SQL package to gather DB Stats since 11g.

Now while upgrading to 19c, i am wondering is this script still valid, this is why i am wondering if you can help to select the most appropriate method to gather DB stats in 19c, knowing that my package does not gather fixed and dictionary stats.

Thank you in advance.

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