How to use NQ logs to check data in DB

最新推荐文章于 2025-02-08 19:30:29 发布

原创最新推荐文章于 2025-02-08 19:30:29 发布 · 789 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

标签

#HCM #DATA Analysis #SATA #Physical SQL #Logical

收录于

BI 专栏收录该内容

10 篇文章

订阅专栏

本文介绍如何利用NQ日志文件来查找与逻辑查询相关的物理查询。通过Ctrl+F搜索特定的逻辑请求哈希（例如：3911c487），可以找到对应的物理查询，这些查询以[WITH]开头并以[orderby*******<=65001]结束。NQ日志路径为：http://url:10217/getlogs/OracleBIServerComponent/coreapplication_obis1/nqquery.log。

How to use NQ logs.

Using NQ logs we can find physical queries which are related to logical queries for test cases. This is a pair patten. one physical query ------ one logical query.

Ctrl+F find your logical query in this log with keyword. You can find a logical request hash, ie: 3911c487

Search this hash code in this log, you can find the physical query which is head with [WITH] and end with [order by ******* <= 65001].

The Path of NQ logs: (http://url:10217/getlogs/OracleBIServerComponent/coreapplication_obis1/nqquery.log)

Please check the latest one.