You may experience deadlocks from a database if both methods try to access to the same table.
如果两个方法都试图访问同一张表，您就可能遇到来自数据库的死锁。
In this scenario, after analysis, it was determined that it will be optimum to use the index I11 to access the table TAB1, but the default behaviour of the optimizer did not, even after tuning.
在这个场景中，经过分析，可以确定使用索引i 11来访问表tab 1是最优的，但是优化器的默认行为不会这么做，即使在调优之后也仍然不会这样做。
Therefore, if all access to a table is static, you would only need to grant access to the package, not the entire table or view.
因此，如果对一个表的所有访问都是静态的，您仅需要授权给程序包，而非整个表和视图。
You ran RUNSTATS with distribution and indexes all option, allowing write access to the table.
您运行带有分布和索引所有选项的RUNSTATS，从而允许对表进行写访问。
Another popular method of controlling access to table data is through the use of stored procedures.
控制对表数据的访问的另一种流行方法是使用存储过程。
Listing 2 shows a simple database access class for the book table.
清单2显示了图书表的简单的数据库访问类。
Focus on optimizing access to one table at a time.
一次重点优化对一个表的访问。
Now, as shown in Listing 20, when users reconnect to the database and try to access the table, they receive an error.
现在，如清单20所示，当用户重新连接到数据库，并试图访问表时，将接收到错误消息。
One option for further consideration would tracking modifications using database triggers, and having the interceptor access the table the triggers write to.
一个可选的更深的考虑是使用数据库触发器来跟踪变化，让拦截器访问触发器所写入的表。
An index only scan is an index access that is not followed by a table access because the index itself contains all the requested data.
仅扫描索引是未包含表访问的索引访问，因为索引本身包含了所有被请求的数据。
This will allow both of the following queries to use indexed access rather than table scans.
这将允许下面两个查询来使用索引访问，而不是表扫描。
In other words, if all access to a table is static, the DBA would not need to grant access to the entire table or view, just to the package.
换句话说，如果对某个表的所有访问都是静态的，则DBA将不需要授予对整个表或视图的访问权限，而是仅授予对包的访问权限。
It is, therefore, recommended that you use the audit log views and do not access the audit log table directly.
因此，建议您使用审核日志视图，并且不要直接访问该审核日志表格。
With this heuristic, predicates are applied as soon as possible (as close to table access as possible) in the query.
通过这种试探法，可以尽快（尽可能接近表访问）地在查询中应用谓词。
Finally, if possible, include all of the columns in the SELECT in the index, so that there is no need to access the table rows.
最后，如果可能的话，将SELECT中所有的列包括到索引当中，这样就不需要访问表中的行。
The output confirms that SAM tried to access a table he was not supposed to.
这个输出可以证实SAM 曾经尝试访问他无权访问的一个表。
This guideline specifies that a single XML index scan be used to access the given table.
该准则指定一个单一的xml索引扫描，将用于访问给定的表。
Altering this attribute for a column requires table reorganization before further table access is allowed (SQLSTATE 57016).
修改列的这个属性要求进行表重组，然后才允许进行进一步的表访问(SQLSTATE 57016)。
To ensure that the script can't be used to access any table in the database, the code first checks the table name requested.
为确保这个脚本不能用于访问数据库中的任何表，代码首先检查被请求的表名。
This single value is a locator to the transition table, which the procedure USES to access the transition table columns.
这个单值是转换表的定位器，存储过程用它来访问转换表的列。
The example guideline in Listing 16 specifies that some XML index be used to access the table SECURITY.
清单16中的示例准则指定必须使用一些XML索引来访问表SECURITY。
This information is used behind the scenes for all the database access to this class 'table.
该信息隐式用于对该类的表的所有数据库访问中。
Performance can be improved by allowing the predicate to be applied close to the table access.
通过允许将谓词应用到表访问，可以提高性能。
That is, IDS verifies whether the user attempting to access the table has been granted the required privileges to perform the requested operation on that table.
也就是说，IDS验证试图访问表的用户是否已经被授予在该表上执行操作所需的权限。
Dropping a column requires table reorganization before further table access is allowed.
删除列之后要求进行表重组，然后才允许进行进一步的表访问。
This guideline specifies that all applicable XML indexes be used together by a XANDOR operator to access the given table.
该准则指定XANDOR操作符同时使用所有合适的xml索引访问给定表。
There are two options for user access to a table while a RUNSTATS is running against that table: allow read access and allow write access.
当对一个表运行RUNSTATS时，有两种用户访问选项：允许读访问和允许写访问。
LBAC controls access to table objects by attaching security labels to them. Users attempting to access an object must have its security label granted to them.
LBAC通过为表对象添加安全标签来控制对它的访问。
Your portlets can access the models shown in Table 1.
您的Portlet可以访问表1所示的模型。
Your portlets can access the models shown in Table 1.
您的Portlet可以访问表1所示的模型。
应用推荐