QSM-00792: the specified SQL statement cannot be stored in
the workload because one or more tables have missing statistics



QSM-00792: the specified SQL statement cannot be stored in the workload because one or more tables ..

Answer / guest

Cause: The user attempted to add a workload statement that
contains a table without statistics. Access Advisor requires
all referenced tables to have valid statistics.

Action: Validate the workload statement and retry the operation.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-32101: cannot create OCI Environment

1 Answers  


RMAN-20039: format requires character when duplexing

1 Answers  


ORA-08103: object no longer exists

1 Answers  


ORA-15052: ASM file name 'string' is not in diskgroup "string"

1 Answers  


RMAN-06004: ORACLE error from recovery catalog database: string

1 Answers  






ORA-19756: corrupt block number string found in change tracking file

1 Answers   Scope International,


ORA-28604: table too fragmented to build bitmap index (string,string,string)

1 Answers  


ORA-08187: snapshot expression not allowed here

1 Answers  


AMD-00160: Warning! Exceeded maximum Custom Measure number of "string"

1 Answers  


ORA-00438: %s Option not installed

1 Answers  


ORA-16180: number processes specified for MAX_PARALLEL_SERVERS is too small

1 Answers  


ORA-02381: cannot drop PUBLIC_DEFAULT profile

1 Answers  


Categories