微软专家

从Oracle Database 10g开始，Oracle在建库后就默认创建了一个名为GATHER_STATS_JOB的定时任务，用于自动收集CBO的统计信息。理论上一张表超过10%的数据变动就会被这个job收集一次统计信息

这个自动化功能已经影响了很多系统的正常运行，晚上10点对于大部分生产系统也并非空闲时段。
而自动分析可能导致极为严重的闩锁竞争，进而可能导致数据库Hang或者Crash。

所以建议最好关闭这个自动统计信息收集功能：
exec DBMS_SCHEDULER.DISABLE('GATHER_STATS_JOB');

1.查询job
SQL> select JOB_NAME,LAST_START_DATE from dba_scheduler_jobs;
JOB_NAME LAST_START_DATE
------------------------------ ------------------
AUTO_SPACE_ADVISOR_JOB 04-DEC-07 10.00.00.692269 PM +08:00
GATHER_STATS_JOB 04-DEC-07 10.00.00.701152 PM +08:00
FGR$AUTOPURGE_JOB
PURGE_LOG 05-DEC-07 03.00.00.169059 AM PRC

----------------------------------------------------------------------------

有两种方法，分别如下：
方法一：
SYSDBA登录
exec dbms_scheduler.disable('SYS.GATHER_STATS_JOB');
exec dbms_scheduler.enable('SYS.GATHER_STATS_JOB');
方法二：
alter system set "_optimizer_autostats_job"=false scope=spfile;
alter system set "_optimizer_autostats_job"=true scope=spfile;
Pfile可以直接修改初始化参数文件
然后重新启动数据库。

闲来无事，做了个摄像头拍照，activex，还是delphi方便啊

dll:

http://files.cnblogs.com/yansc/WillingWebcam.rar

demo:

http://files.cnblogs.com/yansc/demo1.rar

用前先cmd注册 regsvr32 WillingWebcam.dll。

COM图片转换备忘

        class ImageConverter2 : System.Windows.Forms.AxHost

        {

            public ImageConverter2()

                : base("59ee46ba-677d-4d20-bf10-8d8067cb8b33")

            { }

            public static System.Drawing.Image IPictureToImage(stdole.StdPicture picture)

            {

                return ImageConverter2.GetPictureFromIPicture(picture);

            }

        }

select updatedate from trans_studycard t
where
to_date('2010-12-17 23:59:59','yyyy-mm-dd hh24:mi:ss') - updatedate >0
and to_date('2010-12-17 23:59:59','yyyy-mm-dd hh24:mi:ss') - updatedate < 3
order by updatedate

六种日期函数：
1.       add_months(日期，number)    指定日期推迟number个月
2.       last_day(日期)   指定日期当月的最后一天
3.       new_time(日期，时区简写)   调整时区
4.       next_day(日期，number)   number表示周几，星期日是1，指定number的日期（一周内或一周后）
5.       months_between(日期1，日期2)   日期1和日期2之间有几个月
6.       sysdate   系统当期那日期和时间

update trans_exchangeapplication set applicationformdata = replace(applicationformdata,',','#')
where id='1ca156d9-e931-4d70-91a5-c32c1ea724ee'

/*
sselect to_char(TRANSACTIONTIME,'yyyy-MM-dd') as StatisticDataTime,
sum(decode(TRANSACTIONTYPE,'1',TRANSACTIONMONYAMOUNT,0)) as DepositCount,
sum(decode(TRANSACTIONTYPE,'3',TRANSACTIONMONYAMOUNT,0)) as ConsumCount
from trans_transactionhistory t
where months_between(TRANSACTIONTIME,to_date('2010-12-1','yyyy-MM-dd'))<1
group by to_char(TRANSACTIONTIME,'yyyy-MM-dd')
order by StatisticDataTime desc
*/

/*按月，2010年的，按月
select to_char(TRANSACTIONTIME,'yyyy-MM') as StatisticDataTime,
sum(decode(TRANSACTIONTYPE,'1',TRANSACTIONMONYAMOUNT,0)) as DepositCount,
sum(decode(TRANSACTIONTYPE,'3',TRANSACTIONMONYAMOUNT,0)) as ConsumCount
from trans_transactionhistory t
where to_char(TRANSACTIONTIME,'yyyy')='2010'
group by to_char(TRANSACTIONTIME,'yyyy-MM')
order by StatisticDataTime desc
 * */

/*季报
select case when to_char(TRANSACTIONTIME,'q')=1 then '第一季度'
when to_char(TRANSACTIONTIME,'q')=2 then '第二季度'
when to_char(TRANSACTIONTIME,'q')=3 then '第三季度'
when to_char(TRANSACTIONTIME,'q')=4 then '第四季度' end as StatisticDataTime,
sum(decode(TRANSACTIONTYPE,'1',TRANSACTIONMONYAMOUNT,0)) as DepositCount,
sum(decode(TRANSACTIONTYPE,'3',TRANSACTIONMONYAMOUNT,0)) as ConsumCount
from trans_transactionhistory t
where to_char(TRANSACTIONTIME,'yyyy')='2010'
group by to_char(TRANSACTIONTIME,'q')
order by StatisticDataTime
 */

/*年报
select to_char(TRANSACTIONTIME,'yyyy') as StatisticDataTime,
sum(decode(TRANSACTIONTYPE,'1',TRANSACTIONMONYAMOUNT,0)) as DepositCount,
sum(decode(TRANSACTIONTYPE,'3',TRANSACTIONMONYAMOUNT,0)) as ConsumCount
from trans_transactionhistory t
where to_number(to_char(TRANSACTIONTIME,'yyyy'))>= 2010 and to_number(to_char(TRANSACTIONTIME,'yyyy'))<=2011
group by to_char(TRANSACTIONTIME,'yyyy')
order by StatisticDataTime desc
 */