Wonderful's DBA Story

介绍一个SQLPLUS中粘贴SQL语句的小技巧。除了Windows环境下的SQLPLUSW之外，当在sqlplus中运行了一个很长的语句后，得到的是一个带有行号的SQL：SQL> SELECT ksppinm name,2 ksppstvl VALUE, 3 ksppdesc des4 FROM x$ksppi x, x$ksppcv y 5 WHERE (x.indx =

You can use the following command to determine what proportion of the entire non-idle wait time is taken up by these wait classes:SELECT  SUBSTR(WAIT_CLASS, 1, 30) WAIT_CLASS,  ROUND(TIME_WAIT