QSM-00513: one or more of the workload tables is missing

QSM-00513: one or more of the workload tables is missing
Cause: One or both of the workload tables are missing. The two workload tables which should be present in the user's schema are V_192216243_F_5_E_14_8_1 and V_192216243_F_5_E_15_8_1; the former is mapped to WORK$_IDEAL_MVIEW and the latter to WORK$_MVIEW_USAGE. The workload tables are created by the Oracle Trace Formatter when the data-collection-file (oraclesm.dat) is formatted by the user.
Action: Check whether the Formatter succeeded in formatting the data collection. Sometimes the V_192216243_F_5_E_14_8_1 (i.e WORK$_IDEAL_MVIEW) may not be created whereas the other table is created. The most likely cause of this is the init.ora parameters needed to invoke mview-rewrite are not enabled. Check your documentation for all the init.ora parameters which need to be set for mview-rewrite to occur. Another possibility is no GROUP BY queries were issued during the time the data was collected, in which case, run the Trace collection for a longer time to get a representative sampling of the queries issued in the data warehouse.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 18:54

QSM-00513：缺少一个或多个工作负载表,
.原因：缺少一个或两个工作负载表。应该存在于用户模式中的两个工作负载表是V_192216243_F_5_E_14_8_1和V_192216243_F_5_E_15_8_1; 前者映射到WORK $ _IDEAL_MVIEW，后者映射到WORK $ _MVIEW_USAGE。当数据收集文件（oraclem.dat）被用户格式化时，工作负载表由Oracle Trace Formatter创建。,
.操作：检查格式化器是否成功格式化数据收集。有时可能不会创建V_192216243_F_5_E_14_8_1（即WORK $ _IDEAL_MVIEW），而创建另一个表。最可能的原因是未启用调用mview-rewrite所需的init.ora参数。检查您的文档，了解需要为mview-rewrite设置的所有init.ora参数。另一个可能性是在收集数据时没有发出GROUP BY查询，在这种情况下，可以运行Trace集合更长时间以获取在数据仓库中发出的查询的代表性抽样。,
.

aiaiDBA

13718043309

010-86462881

QSM-00513: one or more of the workload tables is missing

1 个回答

相似问题