鹊桥常驻女ID综合指数排名 (转载)# Joke - 肚皮舞运动
O*A
1 楼
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
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
