ITPub博客

with vw_lock AS (SELECT * FROM v$lock)selecta.sid,'is blocking',(select 'sid:'||s.sid||' object:'||do.object_name||' rowid:'||    dbms_rowid.rowid_create ( 1, ROW_WAIT_OBJ#, ROW_WAIT_FILE#, ROW_WAIT_BLOCK#, ROW_WAIT_ROW# )    ||' sql_id:'||s.sql_id   from v$sessi...

SELECT   TRUNC (first_time) "Date", TO_CHAR (first_time, 'Dy') "Day", COUNT (1) "Total",          SUM (DECODE (TO_CHAR (first_time, 'hh24'), '00', 1, 0)) h0,          SUM (DECODE (TO_CHAR (first_tim...