fanfjaiyun的博客

alter table crm_ict_orderInfo rename column starttime to starttime_temp; alter table crm_ict_orderInfo add starttime date; update crm_ict_orderInfo set starttime =to_date(starttime_temp,'yyyy-mm-dd hh...

Oracle数据库 –查看连接等待数： SELECT COUNT (*), event, wait_class FROM gv$session_wait GROUP BY event, wait_class ORDER BY 1 DESC; –查看具体机器等待连接数 select t.MACHINE,count(1) from gv$session t where t.EVENT=...