Wonderful's DBA Story

介绍一个SQLPLUS中粘贴SQL语句的小技巧。 除了Windows环境下的SQLPLUSW之外，当在sqlplus中运行了一个很长的语句后，得到的是一个带有行号的SQL： SQL> SELECT ksppinm name, 2 ksppstvl VALUE, 3 ksppdesc des 4 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