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



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

Answer / guest

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

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

RMAN-06084: the target database may not be mounted when issuing REPLICATE

1 Answers  


ORA-39105: Master process string failed during startup. Master error:

1 Answers  


PCB-00004: UNSAFE_NULL=YES must be used with DBMS=V7 or V8 and MODE=ORACLE

1 Answers  


ORA-26092: only LONG or LOB types can be partial

1 Answers  


RMAN-12013: multiple records for string channel number found in catalog

1 Answers  






TNS-00293: Trace File Name : string

1 Answers  


DRG-50800: failed to open cursor

1 Answers  


ORA-30677: session is already connected to a debugger

1 Answers  


NID-00137: All datafiles that are not dropped should be readable

1 Answers  


ORA-14645: STORE IN clause cannot be specified for Range List objects

1 Answers  


RMAN-06467: could not translate DBA: number

1 Answers  


ORA-00392: log string of thread string is being cleared, operation not allowed

1 Answers  


Categories