CondTools/IntegrationTest/monitoring/compare.sql - master - githubmirror/cmssw

CondTools/IntegrationTest/monitoring/compare.sql

17 строк437 B

Giulio Eulisse

Snapshot of CMSSW_6_2_0_pre8.

26 июн 2013, 18:12

26 июн 2013, 18:12214ab73

set serveroutput on;

DECLARE
tbl varchar2(32);
ts timestamp;
cnt number(10);

BEGIN
  SELECT systimestamp INTO ts FROM dual;
  dbms_output.put_line('Time:  ' || ts);
  FOR result IN (SELECT table_name FROM user_tables ORDER BY table_name)
  LOOP
    EXECUTE IMMEDIATE 'SELECT ''' || result.table_name || ''', count(*) FROM ' || result.table_name INTO tbl, cnt;
    dbms_output.put_line(tbl || ' ' || cnt || ' rows');
  END LOOP;
END;
/