Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interview question on stats gathering

BalajidbaJan 29 2020 — edited Jan 30 2020

Hi,

This is an interview question.

There is an incident where application is inaccessible and I found the cause is due to table stats not gathered.

Can I gather stats for the table during peak hours.Could you please explain.

Oracle --11g,12c

OS -- Unix

Env -- Prod and non prod.

Regards,

Balaji

Added on Jan 29 2020

#general-database-discussions

11 comments

830 views