F***7 发帖数: 884 | |
B*****g 发帖数: 34098 | 2 只准用sql写。
【在 F***7 的大作中提到】![](/moin_static193/solenoid/img/up.png) : 不会无聊到问reverse string吧
|
B*****g 发帖数: 34098 | 3 不许用reverse function,呵呵
【在 B*****g 的大作中提到】![](/moin_static193/solenoid/img/up.png) : 只准用sql写。
|
i****a 发帖数: 36252 | 4 entry level:
cluster vs non-cluster index
statistic
recovery mode
mid level:
log shipping
replication
mirroring
【在 F***7 的大作中提到】![](/moin_static193/solenoid/img/up.png) : 不会无聊到问reverse string吧
|
j*****n 发帖数: 1781 | 5 table partitioning
execution plan |
B*****g 发帖数: 34098 | 6 你在湾区,还是在华府?
【在 F***7 的大作中提到】![](/moin_static193/solenoid/img/up.png) : 不会无聊到问reverse string吧
|
F***7 发帖数: 884 | 7 现在湾区,不过过几个月就要搬了,去哪里还不知道
【在 B*****g 的大作中提到】![](/moin_static193/solenoid/img/up.png) : 你在湾区,还是在华府?
|
B*****g 发帖数: 34098 | 8 跟着ld走?
【在 F***7 的大作中提到】![](/moin_static193/solenoid/img/up.png) : 现在湾区,不过过几个月就要搬了,去哪里还不知道
|
F***7 发帖数: 884 | 9 冰雪啊,呵呵
【在 B*****g 的大作中提到】![](/moin_static193/solenoid/img/up.png) : 跟着ld走?
|
B*****g 发帖数: 34098 | 10 面世有没有人问这类问题,用户说一个页面很慢,java developer说web server正常,
肯定是数据库问题,DBA该砸办?
【在 F***7 的大作中提到】![](/moin_static193/solenoid/img/up.png) : 冰雪啊,呵呵
|
|
|
a9 发帖数: 21638 | 11 查sql语句的执行时间?呵呵。
一定要找个能养我的PPMM */
【在 B*****g 的大作中提到】![](/moin_static193/solenoid/img/up.png) : 面世有没有人问这类问题,用户说一个页面很慢,java developer说web server正常, : 肯定是数据库问题,DBA该砸办?
|
i****a 发帖数: 36252 | 12 DBA 说 database server正常, 肯定是 storage 的问题
【在 B*****g 的大作中提到】![](/moin_static193/solenoid/img/up.png) : 面世有没有人问这类问题,用户说一个页面很慢,java developer说web server正常, : 肯定是数据库问题,DBA该砸办?
|
B*****g 发帖数: 34098 | 13 kick, 肯定是network的问题
【在 i****a 的大作中提到】![](/moin_static193/solenoid/img/up.png) : DBA 说 database server正常, 肯定是 storage 的问题
|
b*****r 发帖数: 239 | 14 RAC,RMAN,Dataguard,Tuning.
【在 F***7 的大作中提到】![](/moin_static193/solenoid/img/up.png) : 不会无聊到问reverse string吧
|
i****a 发帖数: 36252 | 15 actually I did get this *exact* question on an interview.
I said I would work with java developers to identify the source of the
problem by runing sql profiler and perfmon
【在 B*****g 的大作中提到】![](/moin_static193/solenoid/img/up.png) : 面世有没有人问这类问题,用户说一个页面很慢,java developer说web server正常, : 肯定是数据库问题,DBA该砸办?
|
B*****g 发帖数: 34098 | 16 你这个不应该问.net吗?嘿嘿。
【在 i****a 的大作中提到】![](/moin_static193/solenoid/img/up.png) : actually I did get this *exact* question on an interview. : I said I would work with java developers to identify the source of the : problem by runing sql profiler and perfmon
|
i****a 发帖数: 36252 | 17 Chinese in North America Oracle User Group (CINAOUG)
The name is so long. Wouldn't it be better as north America Chinese oracle
user group?
【在 B*****g 的大作中提到】![](/moin_static193/solenoid/img/up.png) : 你这个不应该问.net吗?嘿嘿。
|
B*****g 发帖数: 34098 | 18 我个人喜欢chinese或者china是第一个字
【在 i****a 的大作中提到】![](/moin_static193/solenoid/img/up.png) : Chinese in North America Oracle User Group (CINAOUG) : The name is so long. Wouldn't it be better as north America Chinese oracle : user group?
|
y****9 发帖数: 144 | 19 Classic question is: when someone called you, said : "database is slow",
what would you do?
See the following link
http://www.linkedin.com/groupAnswers?viewQuestionAndAnswers=&di |
B*****g 发帖数: 34098 | 20 现在DBA看report是run自己的script还是去EM上看?感觉oracle也向傻瓜型发展。
【在 y****9 的大作中提到】![](/moin_static193/solenoid/img/up.png) : Classic question is: when someone called you, said : "database is slow", : what would you do? : See the following link : http://www.linkedin.com/groupAnswers?viewQuestionAndAnswers=&di
|
|
|
y****9 发帖数: 144 | 21 >> 现在DBA看report是run自己的script还是去EM上看?
I think it really depends on different situations. Being able to run scripts
only from command-line is a must-have skill, and it works for all situation
and across verisons and different shops.
Not every shop has GUI tool. we don't have EM at this moment
>> 感觉oracle也向傻瓜型发展。
In terms of managability of RDBMS software or their marketing goal at least,
it seems to be true.
But I don't think an Oracle DBA can be challenged to any less extent by less
number of issues. Some area of automation eliminates the intervention of a
DBA, but do we worry less? New features also bring new issues or point-of-
failure to worry.
RAC brings higher availability, but it requires DBA to be smarter or broader
in understanding of storage, network in addition to just database server. |
g*******g 发帖数: 108 | 22 then your question to them would be "what is slow" Developer said it was
slow. What exactly is the "IT" , this question could only be answered by the
java developers.
yes Oracle/sql/mysql DBA can analyze the "waiting events" but there is no
way for DBA to know how important a "waiting events" are related to the
application...
the best source of this information is in frontend code.
I ask this question to the developers all the times. it worked every time!
【在 B*****g 的大作中提到】![](/moin_static193/solenoid/img/up.png) : 面世有没有人问这类问题,用户说一个页面很慢,java developer说web server正常, : 肯定是数据库问题,DBA该砸办?
|
g***l 发帖数: 18555 | 23 SQL还是ORCALE啊,现在问的问题可专业了,还要看是搞PERFORMANCE的还是开发的 |