Shulou(Shulou.com)05/31 Report--

In this issue, the editor will bring you about what is the v$SQL view. The article is rich in content and analyzes and narrates it from a professional point of view. I hope you can get something after reading this article.

V$SQL view query SQL statement select sql_text,executions,disk_reads from v$sql where disk_reads > & number order by disk_reads desc that consumes the most disk Ibank O Using the variable & number allows the user to customize the number of disk reads, and executions indicates the amount of time the statement takes to execute Including the waiting time and service time of the statement analysis buffer read the most SQL statement query logic read the most SQL statement select sql_text,buffer_gets Parse_calls from v$sql where buffer_gets > & number order by buffer_gets query the first 24 CPU statements select sql_text,cpu_time that consume the most SQL resources in the current system Buffer_gets from (select sql_text,cpu_time,buffer_gets) from v$sql order by cpu_time desc) where rownum

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.