年底了，很多地方都要写份年终总结，似乎我也脱不了俗，除了要应付单位那一份外，自己还得整一份，真是把贱骨头。本想把题目定为类似于“2009年终总结”比较正式或者“不是总结的总结”一类比较标新立异的，但是想想还是算了吧，毕竟这是个人的Blog，没必要整的太官样化了，最后，实在没想到更好的标题，于是用了一个万能的标题：“无题”。
前几天我妈跟我MM聊天的时候说了一句精辟的话：“又怕死，又想当官”，用在某些在其位不谋其职的人来说，实在是太精辟了。
今年最大的成绩我估计就是考取了 OCP ，虽然还差一门培训，在整个备考的过程中，我MM给予了我很大的支持，太激动了，这样的MM，实在找不出什么词来形容了。
12月27号通过OCP考试之后，发现变得迷茫了，可能是一下从紧张的状态转入放松的状态吧，非常不适应，真是贱骨头啊，于是乎找来OCM的考点，作为今后自己研究的一个大纲：
Server Configuration [ ] Create the database [ ] Determine and set sizing parameters for database structures [ ] Create and manage temporary, permanent, and undo tablespaces [ ] Stripe data files across multiple physical devices and locations [ ] Configure the database environment to support optimal data access performance [ ] Create and manage database configuration files [ ] Create and manage bigfile tablespaces [ ] Create and manage multiple network configuration files [ ] Create and configure a listener [ ] Configure the database instance to support shared server connections [ ] Set up network tracing [ ] Manage Oracle network processes (the Listener Control utility) [ ] Configure the network environment to allow connections to multiple databases [ ] Use configurationless connections Enterprise Manager Grid Control [ ] Install the Enterprise Manager Grid Control software [ ] Configure the Enterprise Manager repository [ ] Create Enterprise Manager Grid Control users [ ] Use Enterprise Manager to modify a database configuration [ ] Configure Enterprise Manager to modify a database availability [ ] Create and manage jobs [ ] Create and monitor alerts [ ] Create notifications [ ] Implement Grid Control and Database Control [ ] Choose the appropriate tablespace type for the intended use [ ] Create Scheduler jobs [ ] Create schedules [ ] Assign jobs to windows [ ] Create programs [ ] Create job classes [ ] Install the Enterprise Manager Grid Control infrastructure [ ] Deploy Enterprise Manager Grid Control agents [ ] Configure Grid Control for business requirements Managing Database Availability [ ] Create a recovery catalog database [ ] Configure Recovery Manager [ ] Use Recovery Manager to perform database backups [ ] Use Recover Manager to perform complete database restore and recovery operations [ ] Set Flashback Database parameters [ ] Monitor Flashback Database logs and statistics [ ] Perform a Flashback Database operation [ ] Configure a flash recovery area Data Management [ ] Implement fine-grained auditing [ ] Create a secure application role [ ] Grant specific privileges for a Flashback Query [ ] Set parameters for retaining undo [ ] Implement fine-grained access control [ ] Create and manage contexts [ ] Use SQL*Loader [ ] Implement transportable tablespaces between homogeneous and heterogeneous systems (using different methods of moving files) [ ] Choose the appropriate partition method (range, hash, list, and composite) [ ] Choose the appropriate partition key [ ] Choose appropriate indexing methods (local, global, prefixed, and nonprefixed) [ ] Perform partition maintenance operations [ ] Maintain indexes on a partitioned table [ ] Create and manage LOB segments [ ] Apply parallelism appropriately [ ] Tune memory for parallel operations [ ] Set parallel parameters Data Warehouse Management [ ] Create external tables (Data Loader and Data Pump drivers) [ ] Implement Data Pump export and import jobs for data transfer [ ] Implement Data Pump to and from remote databases [ ] Implement Replication/Streams [ ] Configure and manage master replication [ ] Configure and manage distributed materialized views [ ] Configure and manage Streams for replication Performance Management [ ] Install Statspack [ ] Adjust the default interval for statistics collection [ ] Customize the events that are monitored [ ] Use ADDM to analyze statistics and to identify performance bottlenecks and fix them [ ] Implement automatic shared memory management [ ] Tune memory using manual memory management [ ] Monitor and tune SGA areas that are not automatically tuned [ ] Implement automatic SQL execution memory management [ ] Tune the PGA using work area size parameters [ ] Use the PGA Advisor [ ] Create a Database Resource Manager plan with directives (active session count, max execution time) [ ] Create consumer groups [ ] Configure consumer group mappings [ ] Manage Services [ ] Create and manage objects to accommodate different data access methods (schema tuning) [ ] Use the SQL Tuning Advisor [ ] Use the SQL Access Advisor [ ] Gather Optimizer statistics [ ] Interpret execution plan [ ] Use SQL tuning tools and features Real Application Clusters [ ] Install Oracle Clusterware [ ] Install the Oracle Database 10g software [ ] Implement ASM failure groups [ ] Create and manage as ASM instance [ ] Create and manage ASM disk groups [ ] Configure ASM for the shared disks, and create a clustered database [ ] Configure archiving [ ] Configure Services with a preferred instance and an available instance Data Guard [ ] Use Data Guard Manager and DGMGRL [ ] Create and utilize a physical standby database [ ] Create and utilize a logical standby database [ ] Set up log transport services for various levels or protection [ ] Configure the network environment to allow communication between the standby database and the primary database [ ] Open the physical standby database in a "ready-only" state [ ] Perform a switchover operation and a failover operation [ ] Implement Data Guard
也许这辈子都没有机会考取OCM，但是，目标和希望是不应放弃的。
考完试后有点闲，于是乎又在构建我心目中的数据仓库，于是捣鼓起SSIS，希望以此作为ETL工具来使用，希望在2010年中，SSIS能成为我的好帮手吧。
Perl这个被人称为巫师语言的东西，终于入门了，虽然现在写出来的程序C味道很浓，不像一个酷毙了的Perler，但是它的确成为了我的好帮手。
2009年工作中遇到挺多不顺心的事情，特别是负责邮件系统之后，用户迁移，RHCS的集群，乱七八糟的事情一大堆，维护一套邮件系统比起维护5套数据库系统还要头痛，对于这种核心的系统来说，选用第三的产品真的很头痛，第一几乎没有文档可以像Oracle那样研究内部运行机制，第二，出了问题只能找开发商，如果开发商因为这样那样的问题拖着的话，基本上就只能拖着了，第三，日后维护只能找同一家开发商了。其实 MS 的 Exchange 挺不错的，第一，有文档，哪怕不能研究内部运行机理，最起码也能借助Google和baidu解决，第二，服务可以外包，这家不行，可以找另一家。
老家起房子了，加上考OCP，基本上把我的积蓄挖光了，基本上整个下半年，工资卡里的钱都没几天是上千的，有可能是这个原因吧，终于激发了我对现在薪酬的不满，其实不满一直都有了，只不过没有这段时间这么强烈，也许跳槽的时间快到了。还记得第一份“工作”，是在电信实习，由于电信不跟我签约，我不得不跳槽，这是我第二份工作，我自问我做到了“忠诚”，但是现在体会到“忠诚不能当饭吃”那份无奈。