At the time of performance analysis of SQL statements, the general query V $SQL view, or DBA_HIST_SQLSTAT system tables, but inside the query SQL statement total running times and total operation time, time consuming need total number divided by the total time, come out on average, the average time is not clear the SQL statement in the characteristic point in time, how long it will take to run,
Did excuse me each warrior, Oracle system tables can query SQL statement, at a certain time such as: the 2020-10-10 16:42:00 run time-consuming long???????
To ask next, Oracle all operations on the table in the query, such as Oracle will automatically table analysis of statistics, the analysis of statistical records how to query??

CodePudding user response:

masters excuse me, is there a system in Oracle table can query SQL statement, at a certain time, for example: the 2020-10-10 16:42:00 run time-consuming long???????

This not, you must in the program to record the time,

to ask next, Oracle all operations on the table in the query, such as Oracle will automatically table analysis of statistics, the analysis of statistical records how to query??

Statistical information contains the content is more, what do you want to specific what to do, or what is your first to know about the statistics and the content,