kramer

摘要： SELECT S.sid || ','|| S.serial# sid_serial, S.username, S.osuser, P.spid, S.module, P.program, SUM (T.blocks) * TBS.block_size / 1024 / 1024 mb_used, T.tablespace, COUNT(*) statementsFROM v$sort_usage T, v$session S, dba_tablespaces TBS, v$process PWHERE T.session_addr = S.saddr AND S.... 阅读全文

摘要： 可以用下面的SQL来查看。SQL> select nam.ksppinm, val.KSPPSTVL, nam.ksppdesc from sys.x$ksppi nam, sys.x$ksppsv val where nam.indx = val.indx AND nam.ksppinm LIKE '_%' AND upper(nam.ksppinm) LIKE '%LOG_PARALLE%';KSPPINM KSPPSTVL KSPPDESC---------------------------... 阅读全文