性能测试sql查询
我们有两个相同的 Oracle Exadata 四分之一机架，每个机架运行一对数据库实例。我的湿手指性能测试表明，其中一个的运行速度是另一个的四分之一。
是否有一组可以与计时器一起运行的 SQL 查询，可以对两台服务器之间的查询性能进行更科学的比较？
我知道我可以编写一组查询。我想知道是否已经存在半标准基准集。类似于一些表创建查询，然后是迭代插入语句（大量随机数据）、索引、约束、触发器、函数、过程和语句。视图创建脚本（最好包括物化视图），然后是一堆复杂的查询，这些查询通过连接、触发器触发、函数和过程调用等稍微拉伸了引擎......同时将性能统计数据写入一些临时表？
有人遇到过这样的库/工具/脚本集吗？
We have two identical Oracle Exadata quarter racks each running a pair of database instances. My wet-finger-in-the-wind performance tests indicate that one is running at a quarter of the speed of the other.
Is there a set of SQL queries that can be run with timers that would give a more scientific comparison of query performance between the two servers?
I'm aware that I could write a set of queries. I'm wondering if a semi-standard benchmark set already exists. Something like a few table creation queries followed by iterative insertion statements (lots of random data), index, constraint, trigger, function, proc & view creation scripts (preferably including materialised views) and then a bunch of complex queries that stretch the engine a bit with joins, trigger firing, function and proc calls, etc... while writing performance stats to some temp tables?
Anyone come across such a library/tool/script-set?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
尝试为每个机架运行 awrgrpt.sql 并比较输出。通常可以在这里找到 ${ORACLE_HOME}/rdbms/admin/awrgrpt.sql
这将为您提供大量信息，例如等待事件和顶级 sql 统计信息。应该可以让您了解为什么其中一个的性能比另一个低。
Try running the awrgrpt.sql for each rack and compare the output. Usually it is found here ${ORACLE_HOME}/rdbms/admin/awrgrpt.sql
This will give you a bunch of information like wait events, and top sql statistics. Should give you a clue as to why one has degraded performance over the other.