1.For OLTP applications, there should be less sorting and temp space required and only a handful of concurrent cursors opened at a time.
对于OLTP应用程序,所需的排序和临时空间会比较少,一次只打开少数并发游标。
2.Batch and query applications typically do a lot of sequential processing, while data access for OLTP tends to be more random in nature.
批处理和查询应用程序通常要进行大量的顺序处理,而用于OLTP的数据访问往往更具有随机性。
3.What if you know your OLTP searches should use the same execution plan for different binding values?
要是你知道你的OLTP搜索对不同绑定值应该使用相同执行计划又该怎么办呢?
4.On OLTP systems, where user sessions are performing quick queries, tuning this parameter can be very important.
在OLTP系统上,用户会话执行快速查询,调节此参数可能非常重要。
5.A key concept of SOA is to reuse assets across the enterprise, which is composed of both OLTP workloads and batch.
SOA有一个非常重要的概念,即在企业之间重用资产,它由OLTP工作负载和批处理组成。
6.Separating OLTP data from OLAP data allows you to optimize for the access patterns of each technique.
独立存储OLTP数据和OLAP数据使您可为每种技术的访问模式进行优化。
7.The results are very relevant to any DBA that must maintain and tune an online transaction processing (OLTP) system.
结果与必须维护和调优在线事务处理(OLTP)系统的任何DBA密切相关。
8.Philip Howard of Bloor Research provides competitive analysis of these two OLTP systems for IT specialists.
BloorResearch的PhilipHoward为IT专家提供了这两个OLTP系统的竞争力分析。
9.Sequential numbers are often used in OLTP-like applications to generate primary keys required by the relational model.
连续数字在OLTP类应用程序中常常用于生成关系模型所需的主键。
10.For for a large OLTP database, set aside as much as memory as possible for the buffer pool while keeping the system stable.
对于大型OLTP数据库,在保持系统稳定的同时为缓冲池留出尽可能多的内存。