B*g
2 楼
只准用sql写。
【在 F***7 的大作中提到】
: 不会无聊到问reverse string吧
【在 F***7 的大作中提到】
: 不会无聊到问reverse string吧
B*g
3 楼
不许用reverse function，呵呵
【在 B*****g 的大作中提到】
: 只准用sql写。
【在 B*****g 的大作中提到】
: 只准用sql写。
i*a
4 楼
entry level:
cluster vs non-cluster index
statistic
recovery mode
mid level:
log shipping
replication
mirroring
【在 F***7 的大作中提到】
: 不会无聊到问reverse string吧
cluster vs non-cluster index
statistic
recovery mode
mid level:
log shipping
replication
mirroring
【在 F***7 的大作中提到】
: 不会无聊到问reverse string吧
j*n
5 楼
table partitioning
execution plan
execution plan
B*g
6 楼
你在湾区，还是在华府？
【在 F***7 的大作中提到】
: 不会无聊到问reverse string吧
【在 F***7 的大作中提到】
: 不会无聊到问reverse string吧
F*7
7 楼
现在湾区，不过过几个月就要搬了，去哪里还不知道
【在 B*****g 的大作中提到】
: 你在湾区，还是在华府？
【在 B*****g 的大作中提到】
: 你在湾区，还是在华府？
B*g
8 楼
跟着ld走？
【在 F***7 的大作中提到】
: 现在湾区，不过过几个月就要搬了，去哪里还不知道
【在 F***7 的大作中提到】
: 现在湾区，不过过几个月就要搬了，去哪里还不知道
F*7
9 楼
冰雪啊，呵呵
【在 B*****g 的大作中提到】
: 跟着ld走？
【在 B*****g 的大作中提到】
: 跟着ld走？
B*g
10 楼
面世有没有人问这类问题，用户说一个页面很慢，java developer说web server正常，
肯定是数据库问题，DBA该砸办？
【在 F***7 的大作中提到】
: 冰雪啊，呵呵
肯定是数据库问题，DBA该砸办？
【在 F***7 的大作中提到】
: 冰雪啊，呵呵
a9
11 楼
查sql语句的执行时间？呵呵。
一定要找个能养我的PPMM */
【在 B*****g 的大作中提到】
: 面世有没有人问这类问题，用户说一个页面很慢，java developer说web server正常，
: 肯定是数据库问题，DBA该砸办？
一定要找个能养我的PPMM */
【在 B*****g 的大作中提到】
: 面世有没有人问这类问题，用户说一个页面很慢，java developer说web server正常，
: 肯定是数据库问题，DBA该砸办？
i*a
12 楼
DBA 说 database server正常, 肯定是 storage 的问题
【在 B*****g 的大作中提到】
: 面世有没有人问这类问题，用户说一个页面很慢，java developer说web server正常，
: 肯定是数据库问题，DBA该砸办？
【在 B*****g 的大作中提到】
: 面世有没有人问这类问题，用户说一个页面很慢，java developer说web server正常，
: 肯定是数据库问题，DBA该砸办？
B*g
13 楼
kick, 肯定是network的问题
【在 i****a 的大作中提到】
: DBA 说 database server正常, 肯定是 storage 的问题
【在 i****a 的大作中提到】
: DBA 说 database server正常, 肯定是 storage 的问题
b*r
14 楼
RAC,RMAN,Dataguard,Tuning.
【在 F***7 的大作中提到】
: 不会无聊到问reverse string吧
【在 F***7 的大作中提到】
: 不会无聊到问reverse string吧
i*a
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 的大作中提到】
: 面世有没有人问这类问题，用户说一个页面很慢，java developer说web server正常，
: 肯定是数据库问题，DBA该砸办？
I said I would work with java developers to identify the source of the
problem by runing sql profiler and perfmon
【在 B*****g 的大作中提到】
: 面世有没有人问这类问题，用户说一个页面很慢，java developer说web server正常，
: 肯定是数据库问题，DBA该砸办？
B*g
16 楼
你这个不应该问.net吗？嘿嘿。
【在 i****a 的大作中提到】
: 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 的大作中提到】
: 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
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 的大作中提到】
: 你这个不应该问.net吗？嘿嘿。
The name is so long. Wouldn't it be better as north America Chinese oracle
user group?
【在 B*****g 的大作中提到】
: 你这个不应该问.net吗？嘿嘿。
B*g
18 楼
我个人喜欢chinese或者china是第一个字
【在 i****a 的大作中提到】
: 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?
【在 i****a 的大作中提到】
: 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
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
what would you do?
See the following link
http://www.linkedin.com/groupAnswers?viewQuestionAndAnswers=&di
B*g
20 楼
现在DBA看report是run自己的script还是去EM上看？感觉oracle也向傻瓜型发展。
【在 y****9 的大作中提到】
: 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 的大作中提到】
: 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
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.
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
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 的大作中提到】
: 面世有没有人问这类问题，用户说一个页面很慢，java developer说web server正常，
: 肯定是数据库问题，DBA该砸办？
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 的大作中提到】
: 面世有没有人问这类问题，用户说一个页面很慢，java developer说web server正常，
: 肯定是数据库问题，DBA该砸办？
g*l
23 楼
SQL还是ORCALE啊，现在问的问题可专业了，还要看是搞PERFORMANCE的还是开发的
相关阅读
怎么移植一个SQL server数据库[转载] SQL server2k on XP?[转载] 求教: 转数据库服务器,装什么CPU+主板+内存?mysql questionHow to get real time data from a webpage and input it into database automatically?[转载] MySQLinstall problem for msyql on sunosa simple questionHelp!! Data Access Page in AccessRedhat 7.3能把缺省语言从中文改成英文么？SQL replication二个简单Access问题再问一个巨简单的问题(SQL+XML)How to insert CURRENT TIMESTAMP into sql[转载] Coldfusion 怎样实现嵌套查询?oracle 9.2i is much bettertora是不是连不上oracle9i呀，只能连8i吧？Access数据库能存一二十万条记录吗?Help: SASCan we make a list of NiuNiu in Database area?