Tuning at the meeting

Near the end of business hour, my manager called me to attend a meeting related to slowness of data warehouse project.

without any info provided, during the briefing from the Vendor's DBA, lots of figure almost make me sleep. Maybe I was tired after whole day's hard work.

Finally, I realized :
1. The slowness is in development instead of production.
2. The partition key is not used.
3. The index is chosen. The cost shown in TOAD is 130. good value .?

Gathered more info from in-house developer, almost 1/6 rows are accessed in the partition.

Then was asked PGA, hash hint, nest hint ...


The join is in between a small table and a big partition. Feeling that FULL Table Scan should help.

Advise developer to hit the partition directly . And did a test of select count(*) from t partition(part-name), the elapsed time is about 4minutes.

Force to use FULL hint, took about the same time. However the cost shown to vendors is 500k. He looks not willing to try. instead, trying other hints, however needs to google syntax . I want to leave the meeting room, then I went to toilet.

When I came back, they were trying the FULL hint.

Run 4 concurrent sessions to hit different partitions, took the same timing , with 1k+ rows processed per second.

Application manager was so happy , asked everybody "happy with this ? " Saw some smile.


When I stepped the room, leaving 7 persons there continue testing happily more sessions. 6 Thanks to me, except the vendor's DBA.

Feeling COOL, it was almost 7:30pm.

Stressful if I didn't tune it on time. everybody was looking at me... even GM attended the meeting.



moreover, I use sqlplus defeated the TOAD while checking the execution plan.

send email in windows platform

This is my mind for 3 years. It is good for database monitoring, if it can be done by a perl script, however no initiative to follow up.

Yesterday, boss is not around & no urgent task at hand. a leisure Friday.

Googled and got some sample script. However not work with my environment, could be due to my lower version SendMail.pm.

Finally find below key lines from existing netbackup script.


$smtpSvr = "(smtp server)" ;

use Mail::Sendmail;

%mail = ( To => "yourid\@domain",
From => "yourid\@domain",
Message => "test message2 ",
Subject => "test sms2 from windows",
smtp => $smtpSvr,
);

sendmail( %mail ) or die $Mail::Sendmail::error;


Note that a "\" is needed before the "@".




3 years x mans versus 1hour 1 man effort. What do we learned from this case ?!

白狐

曾经沧海难为水，除却巫山不是云。
取次花丛懒回顾，半缘修道半缘君。

Abandom Notepad++

Finally I uninstall it, which was with me more than 3 years.

The reason is that it is boycotting Beijing Olympic 2008. Don't have any reason to appreciate such a programmer.

There are quite a few replacement listed here:

--gvim
--Textpad
--Programmer's Notepad

Cheers. I am not more feeling disgusting whenever using the text editor.

对ORACLE DBA 这份职业的看法

可以做的很久，如果够强，足以养老的职业
觉得是有前途（钱途）的工作！
关键是要过硬本领，要强
一个足够惊心动魄的工作
一个足以显示重要的工作
一个有激情的工作，在激情中时刻保持冷静分析

一般是一个比较闲的工作，一个需要不断学习进步的工作
一个需要理论＋实践并重的工作，想出什么都要实践验证，动手动脑并重
关键时刻能一击必胜，:-)

35岁前应做好的十件事

35岁是青春的后期，35岁以后是收获的季节，如果你没有资格说这句话，你将会憎恨自己。所以在35岁以前，你最好把下面十件事做好。
　　第一，学会本行业所需要的一切知识并有所发展。已故零件大王布鲁丹在他35岁时，已经成为零件行业的领袖，并且组建了年收入达千万美元的海湾与西部工业公司。每个人在年轻时都可能有过彻夜不眠、刻苦攻读，这在20岁甚或30岁都没有问题，但到了35岁，就不应该再为学习基本技能而大伤脑筋了。35岁之前是一个人从事原始积累的阶段，35岁之后就应该薄发了。

　　第二，养成个人风格。在35岁以前，找出你所喜欢的，不论是衣着或是爱好，哪怕是与众不同的小习惯也好。20岁、30岁时你可以不断尝试、不断改变，但是到了35岁，你便要明确地建立个人风格。

　　第三，在感情生活方面平和安定。在攀登事业的高峰时，如果私人生活不愉快，陷入感情危机，对你会产生很大的干扰，甚至会逐渐令你对别的事物失去兴趣。那些在35岁之前私人生活已经平和安定的人，一般都比生活动荡不安的人有更大的机会获得成功。在35岁以后，你应该专注地看着你对事业的投资开始获利。

　　第四，明白自己的短处。承认有些事情你的确做不好，或者不愿做。在35岁之前，一定要投入你所喜爱、所擅长的那种工作。否则，35岁之后必然会有一段郁郁不乐的日子。而且，真正的成功可能因为活力的消退而丧失。

　　第五，知道自己的长处。你应该知道自己擅长什么，并且清楚你所喜欢做而又做得比别人好的事情。不管你目前担任什么样的角色，知道自己的长处对成功都很重要。

　　第六，储备辞职另谋生路的钱。在这个多变的职业世界里，你也许不会永远在一个地方工作，或者永远在一个位置上淋漓尽致地发挥自己，当你感到无法施展时，你很可能会想到辞职，如果你事先储蓄了足够的钱，你便有了一个安全的后盾。

　　第七，建立人际关系网。如果到了35岁你仍未建立起牢固的人际关系网，那你就有麻烦了。人际关系网不是一朝一夕就能建立起来的，它需要几年甚至十几年的培养。一个人在事业上、生活上的成功其实如同一个政党的成功，你要有许多人散布在适当的地方，你可以依赖他们，他们也可以依赖你。

　　第八，学会授权他人。许多人不肯或不能这样做，因此始终被钉在从属的职位上。授权他人是成功的一半，一个事无巨细，不能将工作授权别人的人，注定会遇到极大的障碍。到了35岁，你最好已成为这方面的专家。换言之，你懂得挑选合适的人并信任他们。

　　第九，学会在什么时候三缄其口。因说话不小心而自毁前程的人，比因为任何其他原因丧失成功的人都多。要学会保持沉默而且看起来机智———别人自然以为你知道的比实际还多。别讲别人的闲话，别谈论你自己的大计，守口如瓶所赢得的声誉，远比讲人闲话所带来的东西更加珍贵。

　　第十，对人要忠诚。如果你到了35岁仍未能建立起坚如磐石的忠诚信誉，这一缺点将会困扰你一生。35岁以前，忠诚只是投资；35岁以后，你会作为一个可以信赖的人收到忠诚的回报。”。