The database session stores these query logs in memory and periodically commits the local history to disk.
数据库会话在内存中保存这些查询日志,并定期将本地历史写入磁盘。
We first issue the main query from one session (SESSION1 in this example) that we would like to see the runtime section explain for.
我们首先在第一个会话中(本例中是SESSION1)发出主查询,这样我们就能够得到运行时片段解释的目标。
In the first session (we will refer to it as SESSION1), one will be executing the query.
在第一个会话中(称为SESSION1),我们将执行这个查询。
Setting the AUTOTRACE option ON will enable the display of explain and statistics information for each statement executed in that session along with query results, until the AUTOTRACE is disabled.
将AUTOTRACE选项设置为ON 将允许显示该会话中执行的每条语句的说明和统计信息,以及查询结果,直至 AUTOTRACE 被禁用。
For example, it doesn't have session cache, and nor does it interact with any second-level or query cache.
例如,它不需要会话缓存,也不和任何二级缓存或查询缓存有交互。
When accessed for the first time, the proxy asks the Hibernate session to query the Address object and then defer all future calls directly to the queried instance.
当首次访问这个代理实例时,代理要求Hibernate会话查询Address对象,以后的所有调用都直接交给查询到的实例。
The SQL statements and commands submitted in a pass-through session do not go through the federated query compiler.
在pass - through会话中提交的sql语句和命令不会通过联邦查询编译器。
When just a query or a simple update to a database is needed, a session bean directly accessing the database is the right choice.
当只需要对数据库进行一次查询或简单的更新时,让会话bean直接访问数据库是正确的选择。
Once you have a valid session, you can query (and even update) the Twitter instance for interesting information.
有了一个有效会话后,就可以查询(甚至更新)Twitter实例来获得有趣的信息。
While the query is running, from another session (SESSION2 in this example) connect to the database and find out the executable-id associated to the statement. We can see it is
在查询运行时,在另一个会话中(这里是 SESSION2)连接数据库,然后查找与该语句关联的 executable_id。
When ESSearchServer dispatches the search query to a searcher session, it sends a query log entry to the database session.
当essearchserver将搜索查询分发到搜索器会话时,它将查询日志条目发送到数据库会话。
Result: Executing the query multiple times returns the data from the back end. This is because the read-level passthrough mode is set to FORCE for the whole session.
结果:多次执行查询从后端返回数据,这是因为整个会话的read-levelpassthrough模式都被设置为 FORCE。
A session indicates one logical interaction; you can fire more than one query in one session.
会话(session)指示了一个逻辑上的交互;在一个会话中您可以激活多个查询。
The query log data is stored in a Cloudscape database in a database session.
查询日志数据存储在数据库会话中的Cloudscape 数据库中。
You can also configure the profile to exclude query string parameters such as session IDs from the URLs that appear in the report interface.
您还可以配置的配置文件中排除查询字符串参数,如会话id的网址出现在报告界面。
Query historical events: Write a session bean or servlet to query the historical events by event groups using event Access interface.
查询历史事件:书写会话bean或servlet,并利用EventAccess接口,通过事件组查询历史事件。
The session ID can be passed in one of three ways: as a parameter in an HTML form (typically a hidden field); as a parameter appended to the query string; or as an attribute of a cookie.
会话标识可以用三种方式中一种进行传递:作为HTML表单中的参数(通常是隐藏字段);作为附加在查询字符串后的参数;或者作为 cookie 的属性。
A query algorithm and distributed backup model based on session manager are proposed to guarantee the reliability of cooperative editing systems.
提出一种基于会话管理器的站点查询算法和分布式备份模型,保证系统可靠协作。
Having revealed a particular bottleneck or pressure point, you can then take appropriate steps to alleviate the problem-perhaps by tuning a query, adding an index or simply killing a blocking session.
具有显示某个特定的瓶颈或压力点,然后,可以采取适当的措施来缓解此问题——也许通过优化查询,添加索引或只终止阻塞的会话。
Having revealed a particular bottleneck or pressure point, you can then take appropriate steps to alleviate the problem-perhaps by tuning a query, adding an index or simply killing a blocking session.
具有显示某个特定的瓶颈或压力点,然后,可以采取适当的措施来缓解此问题——也许通过优化查询,添加索引或只终止阻塞的会话。
应用推荐