select sid,
p1,
p1raw,
p2,
p2raw,
p3,
p3raw,
wait_time,
seconds_in_wait,
state,
event,
sysdate
from v$session_wait
where event not in
('AQ Proxy Cleanup Wait', 'ASM background timer', 'DIAG idle wait',
'EMON idle wait', 'KSV master wait', 'LNS ASYNC archive log',
'LNS ASYNC dest activation', 'LNS ASYNC end of log',
'LogMiner: client waiting for transaction',
'LogMiner: slave waiting for activate message',
'LogMiner: wakeup event for builder',
'LogMiner: wakeup event for preparer',
'LogMiner: wakeup event for reader', 'Null event',
'PX Deq Credit: need buffer', 'PX Deq Credit: send blkd',
'PX Deq: Execute Reply', 'PX Deq: Execution Msg',
'PX Deq: Par Recov Execute', 'PX Deq: Signal ACK',
'PX Deq: Table Q Normal', 'PX Deq: Table Q Sample', 'PX Deque wait',
'PX Idle Wait', 'Queue Monitor Shutdown Wait',
'Queue Monitor Slave Wait', 'Queue Monitor Wait',
'SQL*Net message from client', 'SQL*Net message to
数据表day_energy当前为月分区表，分区信息如下：DE_200912,DE_201001,DE_201002.....,月分区表出现速度查询慢，因此通过建立日分区表进行改善。
拆分月分区表的语句为：
alter table day_energy split partition de_201001 at('20100102') into (partition de_20100101,partition de_20100102)
分析：
alter table 表� ......
