分析查询 [英] Analyzing queries
问题描述
我们有一个在Oracle上运行的产品。与我一起使用的Oracle版本是
，版本是8.1.7。我还应该注意到，我是一个相对较新的
Oracle。
我正在对一个具有性能的特定数据库进行故障排除
当我们尝试运行各种quireies和peform插入或
更新时
问题。
不幸的是这个特定的产品需要那个OPTIMIZER_MODE
= RULE。
我在分析表时所做的研究，似乎在分析
查询和表只影响数据库，如果你运行成本
Basis系统vs.规则。
鉴于我们必须运行RULE ，有没有任何选项可以帮助我们解决和调整这个数据库？
感谢您的时间！
Virgina
现场工程师
vl ***** @ nai.com
***没有垃圾邮件请****
We have a product that runs on Oracle. The version of Oracle I''m
working with is 8.1.7. I should also note that I''m relatively new to
Oracle.
I''m troubleshooting one particular database that is having performance
problems when we try to run various quireies and peform inserts or
updates.
Unfortunately this particular product "requires" that "OPTIMIZER_MODE
= RULE".
Of the research I''ve done on analyzing tables, it seems that analyzing
queries and tables only effect a database if you''re running a Cost
Basis system vs. Rule.
Given that we have to run RULE, are there any options that will assist
us in troubleshooting and tuning this database?
Thank you for your time!
Virgina
Field Engineer
vl*****@nai.com
***NO SPAM PLEASE****
推荐答案
Virginia写道：
Virginia wrote:
我们有一个在Oracle上运行的产品。我正在使用的Oracle版本是8.1.7。我还应该注意到，我对Oracle很新。
当我们尝试运行各种quireies时，我正在对一个有性能问题的特定数据库进行故障排除和peform插入或
更新。不幸的是，这个特定的产品需要。那个OPTIMIZER_MODE
= RULE。
我在分析表时所做的研究，似乎分析
查询和表只影响数据库，如果你' 运行成本
基础系统与规则。
鉴于我们必须运行RULE，是否有任何选项可以帮助我们排除故障并调整此数据库？
感谢您的时间！
Virgina
现场工程师
vl ***** @ nai.com
***没有垃圾邮件请****
We have a product that runs on Oracle. The version of Oracle I''m
working with is 8.1.7. I should also note that I''m relatively new to
Oracle.
I''m troubleshooting one particular database that is having performance
problems when we try to run various quireies and peform inserts or
updates.
Unfortunately this particular product "requires" that "OPTIMIZER_MODE
= RULE".
Of the research I''ve done on analyzing tables, it seems that analyzing
queries and tables only effect a database if you''re running a Cost
Basis system vs. Rule.
Given that we have to run RULE, are there any options that will assist
us in troubleshooting and tuning this database?
Thank you for your time!
Virgina
Field Engineer
vl*****@nai.com
***NO SPAM PLEASE****
很多。
没有冒犯，但我会尝试找专家;可能会在一天内完成
。查看来自hotsos.com的索赔
-
问候，
Frank van Bortel
Plenty.
No offense, but I''d try to get an expert in; would probably be done
within a day. See claims from hotsos.com
--
Regards,
Frank van Bortel
Virginia写道：
Virginia wrote:
我们有一个在Oracle上运行的产品。我正在使用的Oracle版本是8.1.7。我还应该注意到，我对Oracle很新。
当我们尝试运行各种quireies时，我正在对一个有性能问题的特定数据库进行故障排除和peform插入或
更新。不幸的是，这个特定的产品需要。 OPTIMIZER_MODE
= RULE。
这听起来像Siebel。
我在分析表时所做的研究，似乎只分析了查询和表格的影响一个数据库，如果你正在运行一个Cost
Basis系统vs. Rule。
鉴于我们必须运行RULE，是否有任何选项可以帮助我们进行故障排除并调整此数据库？
We have a product that runs on Oracle. The version of Oracle I''m
working with is 8.1.7. I should also note that I''m relatively new to
Oracle.
I''m troubleshooting one particular database that is having performance
problems when we try to run various quireies and peform inserts or
updates.
Unfortunately this particular product "requires" that "OPTIMIZER_MODE
= RULE".
This sounds like Siebel.
Of the research I''ve done on analyzing tables, it seems that analyzing
queries and tables only effect a database if you''re running a Cost
Basis system vs. Rule.
Given that we have to run RULE, are there any options that will assist
us in troubleshooting and tuning this database?
启用SQL_TRACE&使用TKPROF进行故障排除。
您可能选择调整选项。
Enable SQL_TRACE & use TKPROF for troubleshooting.
You may have limited options for "tuning".
查看我的回复内联...
" Virginia" < VL ***** @ nai.com>在消息中写道
news：84 ************************** @ posting.google.c om ...
see my replies inline...
"Virginia" <vl*****@nai.com> wrote in message
news:84**************************@posting.google.c om...
我们有一个在Oracle上运行的产品。我正在使用的Oracle版本是8.1.7。我还应该注意到，我对Oracle很新。
当我们尝试运行各种quireies时，我正在对一个有性能问题的特定数据库进行故障排除和peform插入或
更新。不幸的是，这个特定的产品需要。 OPTIMIZER_MODE
= RULE。
与现成产品相同。他们是在不久之前制作的，并且从未对CBO进行过b $ b测试。因此他们告诉你不要使用它。
我在分析表时所做的研究，似乎分析查询和表只会影响数据库，如果你正在运行成本
基础系统与规则。
不要在规则模式下进行分析。
鉴于我们必须运行RULE，是否有任何选项可以帮助我们进行故障排除和调整这个数据库？
是的，学习如何使用解释计划。转到metalink和otn.oracle.com
然后搜索那个和''autotrace''。这将为您提供
查询的图表。
您可以通过运行
ORACLE_HOME / rdbms /中的脚本来安装它admin / utlxplan.sql
感谢您的时间！
Virgina
现场工程师
vl ***** @ nai.com
***没有垃圾邮件请****
We have a product that runs on Oracle. The version of Oracle I''m
working with is 8.1.7. I should also note that I''m relatively new to
Oracle.
I''m troubleshooting one particular database that is having performance
problems when we try to run various quireies and peform inserts or
updates.
Unfortunately this particular product "requires" that "OPTIMIZER_MODE
= RULE".
common with off the shelf products. they were made a while ago and never
tested against CBO. so they tell you not to use it.
Of the research I''ve done on analyzing tables, it seems that analyzing
queries and tables only effect a database if you''re running a Cost
Basis system vs. Rule.
dont analyze in rule mode.
Given that we have to run RULE, are there any options that will assist
us in troubleshooting and tuning this database?
yes, learn how to use the explain plan. go to metalink and otn.oracle.com
and do a search on that and ''autotrace''. this gives you a chart of your
query.
you can install it by running the script in
ORACLE_HOME/rdbms/admin/utlxplan.sql
Thank you for your time!
Virgina
Field Engineer
vl*****@nai.com
***NO SPAM PLEASE****
这篇关于分析查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
