|
|---|
|
|
|
|
|
|
a******e
发帖数: 36306 | 1 ☆─────────────────────────────────────☆
OracleDBA (OracleDBA) 于 (Sun Mar 16 12:55:51 2014, 美东) 提到:
What's your feeling about DS's email?
DS's 的Email 是否存在 SS 所说的问题？
==== below is a health check report email sent by MJ ==========
From: MJ
Sent: Sunday, March 16, 2014 8:52 AM
Subject: DB HC on mydbname/myservername looks good
Team,
The Health Check report of the mydbname Databases look good.
INSTANCE STATUS:
================
INSTANCE_NAME HOST_NAME TIMESTAMP OPEN_
MODE STATUS LOGINS STARTUP_TIME
SHU
---------------- --------------- ----------------- ---------- --------- ---
------- ------------------ -------------------------------------------------
---------------------
mydbname myservername Mar 16, 2014 08:45:30
READ WRITE OPEN ALLOWED 09-MAR-14
NO
1 row selected.
Server Name Instance Name CPU Idle % Connections (Active/Inactive)
Blockers Alert Log Space Issue Listener Status Shareplex
Process Shareplex Backlogs
myservername mydbname 54 % 64 / 2693 None No ORA-
/DBA- errors None Up Running fine No backlogs
EVENTS STATS:
=============
COUNT(*) EVENT MAX(
SECONDS_IN_WAIT)
--------- ---------------------------------------- --------------------
2701 SQL*Net message from client
512199
41 db file sequential read
0
15 rdbms ipc message
628310
11 read by other session 0
7 db file scattered read 0
3 SQL*Net message to client
0
2 Streams AQ: qmn slave idle wait
1
1 Streams AQ: waiting for time management 672
or cleanup tasks
1 pmon timer
47
1 smon timer
5
1 Streams AQ: waiting for messages in the 1
queue
1 Streams AQ: qmn coordinator idle wait 367785
12 rows selected.
==== below is a reply to MJ's email from DS, MJ belongs to the team ABC ===
=====
From: DS
Sent: Sunday, March 16, 2014 8:12 AM
To: MJ
Cc: Team ABC; ....
Subject: RE: DB HC on mydbname/myserveranme looks good
Team ABC
When you check the xx health, besides looking at CPU etc, there are reasons
we also check event count, you need to check the suspicious event and
investigate why they appear.
COUNT(*) EVENT MAX(SECONDS_
IN_WAIT)
---------- ---------------------------------------- --------------------
2701 SQL*Net message from client 512199
41 db file sequential read 0
15 rdbms ipc message 628310
11 read by other session 0
7 db file scattered read 0 =======?
db file scattered read means full table scan this is not normal, you need
to investigate why
3 SQL*Net message to client 0
2 Streams AQ: qmn slave idle wait 1
1 Streams AQ: waiting for time management 672
or cleanup tasks
1 pmon timer 47
1 smon timer 5
1 Streams AQ: waiting for messages in the 1
queue
I fixed the two queries with fts btw. If you don’t know how to fix, that’
s fine, but at least you need to point out the suspicious/abnormal behavior
during health check
Two problem sqls:
SQL_ID CHILD_NUMBER EXECUTIONS BUFFER_GETS/EXECUTIONS SQL_PROFILE
------------- ------------ ---------- ---------------------- ---------------
-------------------------------------------------
5whth3yj0fmj7 0 13 19.0769231 =? make sure
_b_tree_bitmap_plan is true
5whth3yj0fmj7 1 38 3553395.21
cc27daa65qp4h 0 58 11.0172414 COE_
cc27daa65qp4h_2750132956 =? fixed by create a sql profile
DS
=====below is an email from DS's boss SS to DS====
DS
Your input is very valuable and critical. Pls do help and mentor the team.
However, pls make sure your tone doesn’t come out as condescending Offer
the criticism in a constructive fashion to promote team spirit. If the
receiving team members feel bad how the suggestion is made, they may miss
the point about it but the unnecessary emotional aspect will remain and it
wouldn’t help the team nor meet your goal in mentoring.
Typically when giving feedback, you may want to point, what the right way to
do is, what the pitfall in doing the wrong way and where they went wrong
and how they can avoid it.
---------------------------------------
SS
☆─────────────────────────────────────☆
Monfucius (莽夫子) 于 (Sun Mar 16 17:24:35 2014, 美东) 提到:
1.
首先你这个问题帖看着费劲，把技术细节去掉会好很多。那些细节在这里提问题时没有
用。
2.
The xxxxxx report of the mydbname Databases look good.
应该是：
The xxxxxx report of the mydbname Databases looks good.
主语是report。另外我忘了 database 是可数还是不可数名词。
3.
我和你不是一个行业的，不过也认为 DS's 的 Email 有 SS 所说的问题。你看看下面
的句子怎么样：
Team ABC
Thanks for checking xx health. Besides looking at CPU etc, did you look
into any suspicious events and investigate why they happened? I identified
and fixed two queries with fts btw. If you are interested to know more
details, I'd be happy to show you.
DS
4.
现在请你再回头看看第一点，观察一下自己提问题的方式，回邮件的方式，考虑一下自
己有没有必要，愿不愿意做一下不同的尝试。
☆─────────────────────────────────────☆
southnorth (米乡) 于 (Sun Mar 16 20:49:54 2014, 美东) 提到:
SS说得很多，我觉得这个老板挺明锐也挺关心你的。
☆─────────────────────────────────────☆
wuchang (wuchang) 于 (Sun Mar 16 21:08:03 2014, 美东) 提到:
没有细看，不知道是不是下面这句话是争议点。就我看完全会令人不快.
I fixed the two queries with fts btw. If you don’t know how to fix, that’
s fine, but at least you need to point out the suspicious/abnormal behavior
during health check
☆─────────────────────────────────────☆
OracleDBA (OracleDBA) 于 (Sun Mar 16 21:11:30 2014, 美东) 提到:
Team ABC是印度的support team， 经常不知道在做什么，教也教不会； DS 是 onsite
senior techicanl staff, Health check 的内容就是他制定的。对于印度的team DS
确实不太客气， 但实际上DS是整个team中最愿意和最多分享经验和技术给大家的。整
个公司的方向是裁ONSITE, 把工作移到印度， every onsite is not happy and no
one really wants to work for the team and everyoen is only working to their
own best interests to move on.
SS 是新老板，原来的老板由于政治斗争靠边了。
非常感谢你的反馈, 不管怎么样知道怎么委婉地用词造句是很有必要掌握的一种本领。
☆─────────────────────────────────────☆
Monfucius (莽夫子) 于 (Sun Mar 16 22:56:02 2014, 美东) 提到:
呵呵，那我觉得 DS 坐在一个非常好的位置上。虽然 off shore 是大趋势，但是DS这
个位置可以说是至关重要。怎么讲呢，标准你来制定，效果你来评估，公司的大政策由
你来亲手施行！面子上，一定要坚决支持公司的大决策，私底下，一定要创造机会把自
己的位子坐的更牢！比如，在允许的范围内，把标准定高一点点，对下边的工作人员，
不必要指责，对自己的上司，总部，可以仔细地陈述，哎呀这些人水平真不行，真不让
人放心。我需要亲自出差去，每年至少两次......
☆─────────────────────────────────────☆
Monfucius (莽夫子) 于 (Sun Mar 16 23:05:58 2014, 美东) 提到:
赞同！
☆─────────────────────────────────────☆
dancwithwolf (dancwithwolf) 于 (Mon Mar 17 12:22:53 2014, 美东) 提到:
好帖，学习了！
☆─────────────────────────────────────☆
magazine (（（（（（（戒比比哀思两年！）））））) 于 (Mon Mar 17 15:05:30 2014, 美东) 提到:
DS email非常不客气，让我想起我前老板。经常拿出说教的口气。以为自己是什么东西
似的。对不起那段日子实在是太痛苦了，没到一年我就跳槽走了。
☆─────────────────────────────────────☆
acectl (磨) 于 (Tue Mar 18 23:16:37 2014, 美东) 提到:
I think what your boss said is very correct. Your certain sentence not only
does not contribute to solving/preventing the problem, but also makes the
teamwork even harder. If you need to shout at someone, at least it should
serve a purpose. Unnecessary conflict is not recommended.
☆─────────────────────────────────────☆
hiehiehie (hiehiehie) 于 (Tue Mar 25 11:16:21 2014, 美东) 提到:
不明白有什么可不快的。
你为什么当时没有point out the suspicious/abnormal behavior during health
check？明显是你做错事情在先，还不许人说了？
自己事情没做好，人家指出来，还有脸不块？赶紧记住下次不要再犯才是正常人该做的
事情。要不然老中怎么在公司里老爬不上去呢，时间和精力都用来“不快”了。 |
|
|
|
|
|
|
|
