| Tony's profileThinking The WayPhotosBlogLists |  Tools  Help |
|
7/24/2008 DBA Books 循序渐进OracleEygle 是个大师 Eygle 的书深入浅出，分析充分 Eygle 的书得买正版的 推荐 此书 基于三点原因 1) 如果分不清 Instance_name, Service_name, database_name ，读此书 2) 如果想了解Oracle字符集的基本知识，很有用的只是啊，读此书 3) 如果想了解数据迁移，读此书 上周三桂问我一个问题，关于数据迁移的，据说这种业务，非常多。 读读此书吧。 置顶:《循序渐进Oracle》一书及相关信息作者：eygle |English Version 【转载时请以超链接形式标明文章出处和作者信息及本声明】 链接：http://www.eygle.com/archives/2008/08/stepbs_oracle_info.html （媒体收藏）少年杀母事件zz 这是《南方人物周刊》的一名实习记者历时五个多月时间写成的稿子，获得了业内很高的赞誉。光是采访杀母少年的父亲就多达6，7次。因为无法采访到少年本 人，记者多方采访了他的亲戚，朋友，网友，还原了一个真实的立体形象，并试图以少年的视角来描述发生在他身上的一切。追述开始的开始，还原最后的最后。让 读者走进少年的内心，去感受那种压抑和颠覆的焦灼。 也许，每一个罪犯都需要倾诉，都渴望被理解，不是为了宽恕，而是避免类似悲剧的再次发生。 在此，向这个怀揣理想而勇敢践行的实习女记者致敬！ ————————————————————————————- 周日读完。 作者隐含的表达了一些东西，看过就明白。 讲个笑话Original URL: http://huojia.b.mumuyin.com/2008/07/24/stresses-a-joke/ 说十八摸里面信箱叫notes id.一般是用中文名字的拼音，模仿英文名的习惯，姓在后，名在前来命名的。 我的还好 Jia Huo/China/IBM ，简称假货中国。 保不齐有个哥们拼音叫huo jian, notes id Jian Huo/China/IBM，简称xx中国… ———————————————— 看一送一。 话说今天下班的时候，手机突然显示一陌生号码来电。一上来就问，你猜我是谁？ 我最烦别人问我，你猜我是谁。 我知道你是谁， 你爱谁谁？一听这话，我就气不打一处来。 此人用广东口音的普通话，不停的问我，你不记得我了？你猜我是谁？意识到是个诈骗电话，于是回答说，我不认识广东人啊。。。。此人坚持了两分钟，汗一个。我也够可以的。 挂了电话，我说，这是个骗子。 浪迪说，都听出来了，你咋不问他，你妈癌症咋样了？ 我K，脑袋太死板，没转到这根，下次再打，准问候。  博客归来Original URL: http://huojia.b.mumuyin.com/2008/07/19/blog-return/ taotao同学上上周突然发信告知博客会关闭几天，原因是域名服务商卷款跑了。终于，交涉一周多，域名终于可用了。博客归来。感谢taotao同学的辛苦交涉。再次鄙视卷款跑了那小子。 7/1/2008 Oracle Managing Database Performance Fundamental Q&AOriginal URL: http://huojia.b.mumuyin.com/2008/07/01/oracle-managing-database-performance-fundamental-q-a/ 1/If you create a table and a procedure that refers to it, and then change the definition of the table, what will happen when you try to run the procedure? D. The procedure may or may not compile, depending on the nature of the change. Ex,Oracle will attempt to recompile automatically, but this may or may not succeed. 2/If a SELECT statement attempts to use an UNUSABLE index, what will happen? D. It depends on the SKIP_UNUSABLE_INDEXES parameter. Ex,The instance parameter SKIP_UNUSABLE_INDEXES controls this behavior. Depending on this, the statements will either fail or run by resorting to full table scans. 3/You determine that an index is unusable, and decide to rebuild it. Which of the following statements, if any, are correct? B. A rebuild may require double the disk space while it is in progress Ex, A rebuild needs space for both the old and the new index while it is in progress. 4/You can analyze an index with the ANALYZE INDEX command, or with the DBMS_STATS.GATHER_INDEX_STATS procedure. Which view will be populated after this? B. DBA_INDEXES Ex,This view could also have been populated by analyzing the table on which the index is based. 5/Object statistics are gathered and become out of date. What will cause them to be gathered again? B. You can configure a Scheduler job to gather statistics automatically. C. You can always force the gathering of statistics by using the ANALYZE command. Ex,B and C. The Scheduler can be configured to run a statistics gathering job automatically, or the statistics can be gathered interactively at any time. 6/From where are dynamic performance views populated? A. The instance B. The controlfile Ex,A and B. Dynamic performance views are populated from either the instance or the controlfile. 7/When you shut down an instance, what happens to the information in the dynamic performance views? A. It is lost. Ex,A. Information in the dynamic performance views exists only for the lifetime of the instance: it is lost on shutdown, no matter how it occurs. 8/If a primary key index becomes unusable, what will the effect be upon an application that uses it? A. SELECT will succeed, but perhaps at reduced performance. Ex,A. If the SKIP_UNUSABLE_INDEXES instance parameter is on default, then SELECT statements will still succeed, by resorting to full table scans. Most DML statements will fail in this situation. The only exception is UPDATE statements that do not affect the key columns. |
|
|
