• Home
• About
• RSS

Blue days

Tomorrow is another day.

11107 Patch Set for HP-UX Itanium is released

As you can see from above screenshot of MetaLink, 11.1.0.7.0 Patch Set for ORACLE Database Server for HP-UX Itanium is released on 06-OCT-2008.

And I’m so proud to make contribution to this release. Cheers!

Movie Collections 1

Kung Fu Panda

Wall-E

Hancock

Batman: The Dark Knight

Iron Man

Get Smart

The Incredible Hulk

Death Race

Dracula

Eternal Sunshine of the Spotless Mind

Oracle Wait Interface 2

V$SYSTEM_EVENT视图

V$SYSTEM_EVENT视图显示了数据库实例（instance）启动以来所有会话（session）所遇到的所有等待事件的累计统计信息（aggregated statistics）。

SQL> desc v$system_event
Name                                      Null?    Type
—————————————– ——– —————————-
EVENT                                              VARCHAR2(64)
TOTAL_WAITS                                  NUMBER
TOTAL_TIMEOUTS                            NUMBER
TIME_WAITED                                   NUMBER
AVERAGE_WAIT                                 NUMBER
TIME_WAITED_MICRO                       NUMBER
TOTAL_WAITS_FG                              NUMBER
TOTAL_TIMEOUTS_FG                        NUMBER
TIME_WAITED_FG                               NUMBER
AVERAGE_WAIT_FG                            NUMBER
TIME_WAITED_MICRO_FG                   NUMBER
EVENT_ID                                           NUMBER
WAIT_CLASS_ID                                  NUMBER
WAIT_CLASS#                                      NUMBER
WAIT_CLASS                                       VARCHAR2(64)

其中EVENT列包含了等待事件的名称，TOTAL_WAITS列包含了会话等待该事件的次数。TIME_WAITED显示了等待该事件所花费的总时间。

V$SESSION_EVENT视图

V$SESSION_EVENT视图显示了当前连接到实例上的所有会话的等待事件的累计统计信息。

SQL> desc v$session_event
Name                                      Null?    Type
—————————————–
SID                                                   NUMBER
EVENT                                              VARCHAR2(64)
TOTAL_WAITS                                  NUMBER
TOTAL_TIMEOUTS                            NUMBER
TIME_WAITED                                   NUMBER
AVERAGE_WAIT                                 NUMBER
MAX_WAIT                                         NUMBER
TIME_WAITED_MICRO                        NUMBER
EVENT_ID                                          NUMBER
WAIT_CLASS_ID                                 NUMBER
WAIT_CLASS#                                     NUMBER
WAIT_CLASS                                      VARCHAR2(64)

Oracle Wait Interface 1

V$EVENT_NAME视图

V$EVENT_NAME视图并不是一个动态视图，它的内容不会随着时间的推移而变化。它是一个包含了你的数据库实例所定义的所有等待事件（wait events）的名字的参考视图。等待事件的数量随着数据库版本的不同而不同，并且也依赖于所安装的数据库选项（option）：

$ sqlplus / as sysdba

SQL*Plus: Release 11.1.0.6.0 – Production on Tue Sep 23 01:33:39 2008

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 – 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options

SQL> desc v$event_name
Name                                      Null?    Type
—————————————–
EVENT#                                             NUMBER
EVENT_ID                                          NUMBER
NAME                                                VARCHAR2(64)
PARAMETER1                                     VARCHAR2(64)
PARAMETER2                                     VARCHAR2(64)
PARAMETER3                                     VARCHAR2(64)
WAIT_CLASS_ID                                 NUMBER
WAIT_CLASS#                                    NUMBER
WAIT_CLASS                                      VARCHAR2(64)

SQL> select count(*) from v$event_name;

COUNT(*)
———-
961

一个简单的COUNT(*)就可以告诉你你的数据库中定义了多少个等待事件。

每个等待事件拥有最多3个属性（attributes），它们分别被记录在PARAMETER1，PARAMETER2和PARAMETER3列中。同时，这3列的值也将会显示在V$SESSION_WAIT视图的P1TEXT，P2TEXT和P3TEXT列中。

Oracle OpenWorld 2008 is coming

Oracle OpenWorld 2008 will be held from September 21 to September 25 in San Francisco. And here is the agenda.

This year, there are 4 members of our group (in OARDC Shenzhen) have the opportuinity to participate this world’s largest conference for Oracle customers and technologists. But for me, I think I have to wait for OpenWorld 2009 or 2010

A glance of core dump

在平时的测试工作中经常碰到程序产生core dump的情况，什么是core dump？下面是摘自Wikipedia的core dump的定义：

A core dump is the recorded state of the working memory of a computer program at a specific time, generally when the program has terminated abnormally. In practice, other key pieces of program state are usually dumped at the same time, including the processor registers, which may include the program counter and stack pointer, memory management information, and other processor and operating system flags and information. The name comes from the once-standard core memory technology. Core dumps are often used to diagnose or debug errors in computer programs.

简单来说，core dump是在程序异常终止的时候对其所使用的内存内容和程序状态的一个记录。

Be sieged from all sides

谁在煽动痛楚  令人着魔

四面全是楚歌

怨恨太多  或快乐声线

换到太少耳朵