如果你想写份邮件,检索一下网页的数据库,传输一段720p的小猫视频,或以60帧每秒的速度再现爆炸场面,首先必须得有台电脑。
If you wish to compose an E-mail, index a database of web pages, stream a kitten video in 720p or render an explosion at 60 frames per second, you must first build a computer.
为了确定数据库中的哪些表具有页面级锁定以及需要修改为行级别锁定,我使用了一段sql脚本:genlockmod . sql(参见清单1)。
To determine which tables in a database have page-level locking and need to be modified to row-level locking, I use a helpful SQL script: genlockmod.sql (see Listing 1).
这低于1.75GB的共享内存限制,并且每个数据库共享内存段可以安全地连续映射到一个象限。
This is well under the 1.75gb Shared memory limit, and each database Shared memory segment can safely map contiguously to a quadrant.
创建少数附加回滚段来处理数据库活动。
Create few additional rollback segments to handle the database activities.
注意这个数量同时还包括实例共享内存和数据库共享内存,并且它们的内存段必须是邻接的。
Note this amount includes both the instance Shared memory and database Shared memory, and their memory segments must be contiguous.
数据仓库和在线分析处理技术是近一段时间以来,数据库界最重要的两种新技术。
Data warehousing and Online Analytical Processing (OLAP) are two of the newest technologies in the database area.
QueryOpen代理的以下LotusScript代码段执行对approver数据库的查找。
The following LotusScript code fragment of the QueryOpen agent performs a lookup to the approver database. It populates the RETENTION_ERRMSG field if the approver is no longer found.
如果启用了ESTORE,那么还要从数据库共享内存中拿出另一个段。
If ESTORE is enabled, then it will take another segment away from the database Shared memory.
限制:在此配置中,对于数据库共享内存的限制是2gb或8个段。
Limit: In this configuration, the limit for database Shared memory is 2gb, or 8 segments.
该向导将创建路径的最后一段,并且在这个目录中创建数据库。
The wizard will create the final segment of the path, and will create the database within that directory.
所有这8个段(2gb)可能都被用于数据库共享内存。
Potentially, all 8 segments (2 GB) can be used for database Shared memory.
本文包含一些代码段示例并提供一个可以下载的示例数据库。
This article includes snippets of code examples and provides an example database that you can download. The example Lotus Notes application includes the following agents
要解决这个问题,可以在unfenced模式下运行udf,或者将数据库共享内存减少至不多于5个段。
To resolve the problem, run UDF in an unfenced mode or reduce database Shared memory set to no more than 5 segments.
DBA_SEGMENTS视图描述的是数据库中所有段的存储和分配信息。
DBA_SEGMENTS describes the storage allocated for all segments in the database.
数据库没有彻底关闭(在回滚段中有活动的事务)。
The database was not cleanly shut down (there are active transactions in the rollback segments).
所有3个绿色的段被用于共享内存,包括实例共享内存和数据库共享内存。
All three green segments are used for Shared memory, which includes both instance Shared memory and database Shared memory.
我们只知道,数据库共享内存在0xfe002000结束,因为从这个地址开始的是一个用于匿名内存的段。
All we know is that the database Shared memory ends at 0xfe002000, because starting at that address is a segment for anonymous memory.
在前面的示例中,两个用户交互之间将保持数据库游标打开,从而防止其他用户访问被锁定的数据段。
The previous example held the database cursor open between user interactions, preventing other users from accessing database segments that are locked.
第一段包含初始化应用程序的事件处理函数(onload)和数据库初始化,如清单3所示。
The first block contains the event handler to initialize the application (onload) and the initialization of the database, as shown in Listing 3.
一项大型注册研究数据库中ST段抬高和非st段抬高心肌梗死转归的比较:非st段抬高心肌梗死是否与更差的远期预后相关?
A comparison of st elevation versus non-ST elevation myocardial infarction outcomes in a large registry database: Are non-ST myocardial infarctions associated with worse long-term prognoses?
当数据库服务器处于联机状态并执行操作时,如果虚拟区的初始尺寸太小,数据库服务器会自动向虚拟区附加其他操作系统段。
When the database server is online and performing operations, it automatically attaches additional operating-system segments to the virtual portion, if the initial size is too small.
如果数据库是分区的,或者启用了intra - parallel或连接集中器,那么数据库共享内存中有一个段被预留给应用程序组共享内存。
If the database is partitioned, or intra-parallel enabled, or connection concentrator enabled, then one segment is used for Application Group Shared Memory.
例如,与连续从数据库中逐段检索对象相比,缓存对象使应用程序能够更好地执行。
Caching of objects helps your application perform much better than it would if it continually retrieved objects piece by piece from a database, for example.
现在,在最终提交该事务之前,客户机通知参与的数据库准备提交(第1阶段)。
Now, before the transaction is finally committed the client advises the participating database to prepare the commit (Phase 1).
可以根据需要详细地定义规则,规则可以包含各种参数,从用户名和数据库类型到命令、时间段和计数。
Rules can be made as detailed as necessary and can include a wide range of parameters-from user names and database type to command, time period, and counts.
第三段加粗的代码用于处理数据库故障转移和连接切换。
The third bold section contains code for handling database failover and connection switching.
在许多情况下,事务会话会持续较长一段时间,占用着数据库连接,直到完成。
In many cases, the session of transactions can take a good while, holding the database connection until complete.
如果需要,创建另一个新的数据库以存储整个一年或者特定时间段内的假期信息。
If needed, create another new database to store holiday information for an entire year or for a specified time duration.
比如,最初曾经尝试将XML数据保存在关系数据库的varchar2字段中,然后简单地增加一个XQuery引擎层,结果查询性能很差。
For example, early attempts at storing XML data in varchar2 fields of a relational database resulted in poor query performance when an XQuery engine was simply layered on top.
比如,最初曾经尝试将XML数据保存在关系数据库的varchar2字段中,然后简单地增加一个XQuery引擎层,结果查询性能很差。
For example, early attempts at storing XML data in varchar2 fields of a relational database resulted in poor query performance when an XQuery engine was simply layered on top.
应用推荐