j*n
5 楼
table partitioning
execution plan
execution plan
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 的大作中提到】![](/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 的大作中提到】
![](/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
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 的大作中提到】![](/moin_static193/solenoid/img/up.png)
: 面世有没有人问这类问题,用户说一个页面很慢,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 的大作中提到】
![](/moin_static193/solenoid/img/up.png)
: 面世有没有人问这类问题,用户说一个页面很慢,java developer说web server正常,
: 肯定是数据库问题,DBA该砸办?
g*l
23 楼
SQL还是ORCALE啊,现在问的问题可专业了,还要看是搞PERFORMANCE的还是开发的
相关阅读
What is wrong?HELP! need info on QBE(Query By Example)打算自行开发一个DBMS斑竹们呢?Any paper of Broadcasting?IBM Overtakes Oracle In Database Raceprimary key?Re: 打算自行开发一个DBMScan i ...?ORACLE Pro*C 远程接续一问?哭诉!Why SQL Server 7 Enterprise Manager is so slow?is oracle the best database pro?[转载] database for Linux?急!!!hehe, a trivial yet annoying questionoralce8 and UTF8 supportY2K No.1~~谁知道哪里找有关data warehouse的论文?n-tier enterprise application