--prompt --- select count(*) from hisdb ---
--select sysdate from dual;
--select count(*) from hisdb.data partition (DATA_P2);
--select sysdate from dual;

--prompt --- select count(*) from ehist ---
--select sysdate from dual;
--select count(*) from hisdb.data partition (DATA_P2);
--select sysdate from dual;

prompt --- select SMT_HVC_A33N/VOLT from hisdb;
select sysdate from dual;
select count(*) from hisdb.data where varname = 'SMT_HVC_A33N/VOLT' and time > 'JUN 1 2004 00:00:00' and time < 'JUN 20 2004 05:00:00';
select sysdate from dual;

prompt --- select SMT_HVC_A33N/VOLT from ehist;
select sysdate from dual;
select count(*) from ehist.data where varname = 'SMT_HVC_A33N/VOLT' and time > 'JUN 1 2004 00:00:00' and time < 'JUN 20 2004 05:00:00';
select sysdate from dual;



