|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2006年12 期
| 标题 |
| 查询优化解决“车站系统”数据库I/O冲突(15 卷) |
| 英文标题 |
| Optimizing inquiring I/O of Oracle on Railway Station Information System |
| 摘要 |
| 详细阐述优化查询SQL解决“铁路车站系统”数据库I/O冲突的步骤。“车站系统”中某些子系统响应速度非常慢，监视系统性能瓶颈时间段数据库的状态，比较两个以上时间点性能差异，发现引起性能瓶颈的主要问题来自I/O争用。可以通过建立索引，为查询增加参数，修连接改查询语句书 |
| 作者 |
| 新闻作者:廖国良，马 征 |
| 关键字 |
