Oracle provided many method for us to understand its behaviors, help us to manage and improve it. Such as execution plan, statistics data, dynamic views, and even the events trace and dumping. However, as a DBA, we always want to get more informations to find its secrets, operation details. For example, when we tuning a SQL, we will get the consistent gets (Logical IOs) as an important performance reference. However, sometimes such figure may confuse us. why the logical IOs number is so high eventhough it scans an empty table? Why we get so many logical IOs even it hited index? ... In such scenario, we will want to know what the exact data blocks it got. But this is the Oracle internal behaviors, it did not provide any method to look into it. Now, let's change our view, look it from oracle inside. As we know, all of operations are finally implemented by oracle internal functions. If we can find such functions and trace their calling, we will get what we want. In unix/linux, there are several utilities to trace the call stack, such as pstack. ORADEBUG can also dump the call stacks. But such result may not enough for us. In windows (32), I built a tool (OraTracer) to trace special functions, try to detect their arguments. I will use it get the information we interested in.
【全文】

    绑定变量窥视其目的主要是帮助CBO下更加精确的计算出查询计划代价。但是，因为这依赖于被“窥视”的变量值，因而也为查询计划带来了不稳定性。数据的不平衡、分区的不平衡都可能会因为这种不稳定性而导致性能风险。
    周一收到生成支持人员的报告，系统上一个作业启动后很长时间没有完成，其执行时间远远大于上周的正常执行时间。接到报告后，首先检查了系统，不存在锁队列的问题。然后查询V$SESSION_LONGOPS，立即发现下面的语句正在进行长操作。
【全文】

New Features: Flexible function parameters setting; Disassembling to ASM code;
【全文】

      设计是整个数据库系统的基础。本教程着重介绍了数据库设计中逻辑设计和物理设计的作用和设计方法，对提高设计人员的数据库设计能力起到很大的引导帮助作用。
【全文】

      9月21日，“2006中国互联网大会”将在京召开，此次大会将主题定为“创新——互联网带来的机遇”，发布了《第二届中国互联网社区(站长)发展状况调查报告》。 报告显示，50.9%社区站长使用.com域名，其次是.cn域名，占总体比例的16.3%，而.net域名以11.7%比率排在站长选择第三位。
【全文】

      有没有想过在寂寞的旅途中、坐在闷热的长途大巴中，或者在教师上自习、思路短路时可以上网聊天呢？或者跑到论坛去灌水，又或者上网查急需的资料呢？嘿嘿，是不是心动了？下面就教大家如何用手机上网吧。
【全文】