Collectives™ on Stack Overflow
Find centralized, trusted content and collaborate around the technologies you use most.
Learn more about Collectives
Teams
Q&A for work
Connect and share knowledge within a single location that is structured and easy to search.
Learn more about Teams
I am using
dbms_stats.gather_schema_stats('%schema%')
The process is working about 3 hours.
Objective: to optimize the current process.
Where do I see the time of collection of statistics?
The best thing to do is to trace the process that executes dbms_stats.gather_schema_stats and then profile the output. Then nobody has to guess.
SQL> select * from v$diag_info /* to get location of trace file */;
SQL> exec dbms_monitor.session_trace_enable(null, null, true, false, 'all_executions')
SQL> exec dbms_stats.gather_schema_stats('%schema%')
SQL> exec dbms_monitor.session_trace_disable(null,null)
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
