Edit D:\app\Administrator\product\11.2.0\dbhome_1\RDBMS\mesg\qsmus.msb
" T ? 0 ? U? 0 ??? "(br|???????? %.3<DMT[g????????6?F?A????? ,AJS[cjqy??? ? ? ? ? ? ? ? ? ? ? # + 0 ? V ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? $? L x ? ?unable to initialize Summary Advisor environmentOCI errorout of memoryinternal errorsyntax errorno fact-tables could be foundno dimensions could be foundstatistics missing on tables/columnsinvalid parameterstatistics missing on materialized viewsinvalid fact-tables specified in fact-filterinvalid summaries specified in the retention-listone or more of the workload tables is missing 8 w ? ? ? 5? t? ? ?the size of must-retain summaries exceeds specified space limitoperation cancelled by userillegal status detected for runSummary Advisor requires a COMPATIBLE setting of 8.1.0.0 or greaterJava is not enabled. Please execute INITJVM.SQL and INITQSMA.SQLSummary Advisor is not installed. Please execute INITQSMA.SQL.data access error in module %sthe specified value %s for parameter %s is invalid or contains an invalid item ? 2 ? b ? ? ? ? ? >? y? ? ?the file %s could not be opened for write accessthe parameter %s contains an invalid combination of options %sthe specified value %s is out of the acceptable range of %s to %s for parameter %stask %s does not reference a valid workload and therefore cannot be executeda set of workload statements already exists for workload %sthe specified workload %s is being used by one or more advisor tasksthe specified workload %s is not referenced by task %s ? 2 ? i ? ? ? ? ? ? K? ? ?the specified parameter %s is not valid for workload %sthe user %s does not exist for the specified workload statementthe import mode %s is invalid for the current operationthe priority %s is invalid for the current operationthe specified Summary Advisor workload %s does not existthe owner %s was not found while validating user-defined workload %s.%sthe column %s was not found in the user-defined workload table %s.%s ? 2 ? w ? ? ? I ? ?cannot validate user-defined workload because table %s.%s is invalid.a SQL statement is required for the current workload operationa SQL cache is not available to user %sthe search condition is invalid for the requested operationthe SQL statement %s was not found for workload %sthe specified workload %s is already referenced by task %sthe specified SQL statement cannot be stored in the workload because it has no valid table references 2 ? ? ? E ? ? ?the specified SQL statement cannot be stored in the workload due to a statement errorthe parameter %s contains the invalid %s name %sthere are no SQL statements to process for task %sthe specified SQL statement cannot be stored in the workload due to invalid table referencesthe user-defined workload %s is missing the following column: %sthe specified directive %s is unsupported at this timethe specified output filename %s is invalid or cannot be accessed , l ? B ? ?the specified directive conflicts with the existing directive %sthe task %s could not be executed because the workload %s is being modifiedthe specified value %s is invalid for parameter %s. Valid keywords are %sthe specified value %s is an invalid date format for parameter %sthe specified value %s contains an invalid date for parameter %sthe %s %s referenced in the list %s is invalid for parameter %s , f ? ? ? I ?the directive %s is not supported for task %s at this timethe name %s is invalid for directive %sthe tablespace %s is invalid for directive %sThe requested recommendation does not support direct implementationThe requested recommendation requires user editing and cannot be implementedthe workload %s cannot be modified or changed because it is being used by task %s & ? . q ?the specified SQL statement cannot be stored in the workload because is contains unsupported statement typethe specified SQL statement cannot be stored in the workload because one or more tables have missing statisticsthe specified SQL Tuning Set %s does not existthe statement can not be stored due to a violation of the %s filterthe SQL Tuning Set repository has not been implemented 2 ? ? 5! ^" ? ?the specified SQL statement cannot be stored in the workload because table %s does not have valid statisticsthe specified workload %s does not exist for the current userthe specified workload %s already existsthe user-defined workload table %s cannot be foundthe specified workload name %s is invalidthe specified username %s is invalidAn error occurred while implementing action %s (%s) %s. # , $ ? % ? & ? ' 0( ? ?The STORAGE_CHANGE parameter value %s cannot be zero or negative for partial workloads.not enough space for mandatory access structuresthe specified recommendation %s value %s is invalidthe %s parameter value must be specified when STORAGE_MODE is set to TOTALthe ANALYSIS_SCOPE parameter value contains an incomplete or invalid combination of options.parameter %s only permits a single keyword. Choose one of the following: %s ) t R ? S ? T ? U ? V ? W ? X Y Z R[ s\ ?] ?^ ?_ ?` ?a ?b ? ?the selected number of recommendations exceeds the maximum value of %staskworkloadEMPTYNULL%sWorkload processing completed: %s scanned %s accepted %s discardedstatementsImporting workload from user-defined workload %s.%sImporting workload from SQL cacheImporting workload from schemaImporting workload from Summary Advisor workload %sModuleActionUsernameDescriptionHypothetical workloaduser c h d m e s f ? g ? h ? i ? j ? k l m n 9o jp ?q ?r ? ?tableobjectGeneral purpose database templateOLTP database templateData Warehouse database templateSQL Access Advisor: Version %s - ProductionUsername:Task:Execution date:index typeMissing statistics: Table: %sInvalid table references: User: %s Statement: %sInvalid SQL: User: %s Statement: %sImport query: %sWorkload processing query: %sPreparing workload for analysis s D t m u ? v ? w ? x y .z f{ ?| ? ?Importing workload from SQL Tuning Set %sFilter violation: %s: Statement: %sInvalid user: User: %s Statement: %sDeprecated parameter: Old name: %s New Name: %sFilter Summary: %s: UnusedFilter Summary: %s: Statements discarded: %sFilter Summary: All user-specified filters were disabledDefault Enterprise Manager task templateFilter Summary: %s: Statements invalidated: %sResetting workload } 8 ~ | ??? ? ? ? ? ? ? O? ? ?Workload processing completed: %s scanned %s passed %s invalidatedValid SQL: User: %s Statement: %sIn BRIEF mode star transformation analysis is skippedNo index candidates were found for statement %sAll new index solutions for statement %s were rejected by the query optimizerNo index candidates were found for MVs referenced in statement %sAll new index solutions on MVs in query %s were rejected by the query optimizer ? > ? h ? ? ? ? ? ? ? *? b? ?? ? ?Existing index %s does not have statisticsTable %s considered too volatile for %s indexesColumn %s considered too volatile for %s indexesInternal Error during index analysis for query %sError loading existing index for index analysis %sTask has been set to ignore table volatility informationOperation cancelled by user at stage %s, step %sOperation interrupted by user at stage %s, step %sOperation timeout at stage %s, step %s ? D ? m ? ? ? ? ? ? '? L? n? ?? ? ?No existing materialized views were foundNo eligible materialized views found for query %sGenerating materialized view candidates (%s%%)Generating intial recommendations for each query (%s%%)Performing local optimization (%s%%)Performing global optimization (%s%%)Generating index candidates (%s%%)Evaluating the initial execution cost for each query (%s%%)Preparing workload queries for analysis (%s%%)Access advisor execution completed ? z ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? "? 9? K? [? m? ?? ?? ? ?SQL Syntax or Semantic ErrorValid tableInvalid tableValid usernameInvalid usernameValid actionInvalid actionValid moduleInvalid moduleValid SQL StringInvalid SQL StringInvalid table referenceInvalid start timeInvalid end timeMissing statisticsMissing statistics: Statement: %sInvalid commentPerforming optimal global greedy post-processing (%s%%)%s ? > ? h ? ? ? ? ? ? ? ? S? q? ? ?SQL Access Advisor publishing results (%s)SQL Access Advisor was interrupted or cancelledNote %s managed statement: %sRepartitioning table %sDependent objects prevent automatic table repartitioningThe following objects must be removed before executing implementation script: %sCreating new partitioned tableCopying %s to new partitioned tableDropping materialized view log on original table ? \ ? ? ? ? ? ? H? P? [? r? y? ?? ?? ?? ?? ? ?Creating materialized view log on new partitioned tableRevalidating %s for use with new partitioned tablePopulating new partitioned table with data from original tableRenaming tables to give new partitioned table the original table namecommentsconstraintsreferential constraintsindexestriggersobject grantsfine-grained access-control policiesaudits of schema objectsfine-grained audit policiesmaterialized views ? J ? T ? ? ? ? ? ? ??? ????7? b? z? ? ?dimensionsAdvisor feature is not currently implementedquery rewrite not enabledno query rewrite when OPTIMIZER_MODE is rule basedno query rewrite on DDL queriesno query rewrite before view mergingno query rewrite when query has slave SQLquery rewrite disabled for this query blockquery has NOREWRITE hintno query rewrite for update queriesquery rewritten with materialized view, %s, using text match algorithm ? > ? v ? ? ? ? ? ? 9? X???? ? ?table(s) in the query not found in materialized view, %swhen heuristic rewrite not set, rewrite hint requiredSAMPLE clause present in FROMnested aggregates or CONNECT BY/START WITH clause presenttop level operator in WHERE clause of the query is an ORGROUP BY clause has non-columnsQuery rewrite does not support, aggregate, %saggregate argument cannot be converted to canonical formsingle table materialized join view rewrite not required ? D ? } ? ? ? ? ?? ?5 f ??? ? ?no suitable materialized view found to rewrite this querymaterialized view, %s, is ineligiblematerialized view, %s, not found in the hint lista more optimal materialized view than %s was used to rewritematerialized view, %s, has GRANT errorsmaterialized view, %s, has unknown compile errorsmaterialized view, %s, not foundquery rewrite is disabled for, %smaterialized view, %s, is unusablematerialized view, %s, is currently being refreshed 8 r ? ? ; ?{ ?? ?materialized view, %s, is stale in ENFORCED integrity modematerialized view, %s, has PL/SQL functions in ENFORCED integrity modematerialized view, %s, is stale in TRUSTED integrity modematerialized view, %s, not foundquery rewritten with materialized view, %smaterialized view, %s, needs a dimension level to join table, %sa row level security policy exists on this tableunmatched column, %s, present in query after view merging ?8 ?w ? ? \ ? ? ?Query Rewrite failed to allocate the necessary query join graphlogical operator(s) could not be processedselection present on right hand side of an outer joinmatch between the materialized view (%s) and query join graphs failedmaterialized view, %s, does not match with a measure in the queryanchor and matching join arc check failed for %sjoin back attempted on a table to the RHS of a semi or anti join for %s join back attempted on a view for %s 2 j ? ?? ? e ?complex join back on correlated columns not allowed (%s)complex join back on non-MAV rewrite not allowed (%s)join back level(s) not present (%s)semi-join check failed for materialized view, %sroll-up check failed for materialized view, %sno support for rollup when a window function is present on the columnreferential integrity constraint on table, %s, not VALID in ENFORCED integrity mode > ?? ? ! ;" c# ?$ ?% ? ?NORELY referential integrity constraint on table, %s, in TRUSTED/STALE TOLERATED integrity modeno join match between query and summary, %sQuery Rewrite failed to allocate the necessary materialized view join graphno query rewrite for this DDL expressionno query rewrite for this DML expressionMV, %s, does not have column, %s, for a joinbackHAVING clause in the query block is malformedillegal subquery in the HAVING clauseillegal query expression & > ' g ( ? ) ? * ? + (, c- x.?? ?query has one or more manual partition(s)query has a dictionary table or viewquery has a fixed table or viewmaterialized view, %s, cannot compute measure, %s, in the querymaterialized view, %s, does not have the column, %s, from querymaterialized view, %s, cannot support the query measure, %sno dimensions presentsummary join graph for, %s, does not have table, %sequivalence class manager was not found / & 0 ? 1 ? 2 :3 ? ?query rewrite not possible because a join in materialized view % with table % has eliminated some rows found in querymaterialized view, %s, and query have different joins between tables, %squery rewrite not possible because materialized view, %s, has a join not found in queryquery rewrite not possible because materialized view, %s, and query have different number of joins between tables, %smaterialized view, %s, does not support aggregate function, %s 4?> 5 a 6?? 7 ? 8 ? 9 : J; ?< ? ?no materialized join view was foundmaterialized view, %s, is grouping at a higher level than querymaterialized view, %s, is marked invalidDML operation occurred on a table referenced by MV, %sinvalid dimension, %sno primary key or row id found for table, %s, in MV, %sJoining materialized view, %s, with table, %s, not possiblequery text not available - possible inline viewmaterialized view %s has an anchor table %s not found in query = 2 > l ? ? A?? B?4C WD ? ?materialized view, %s, has a lossy join between tables, %sdimension(s) not present or not used in ENFORCED integrity modequery grouping on a column that cannot be derived from materialized view, %san inline view in the query does not have a materialized viewno query rewrite after view mergingcost based optimizer found query rewrite is more expensivemjv tries to rewrite a semi-join and primary key or rowid missing E > F r G ? H ? I J JK |L ?M ? ?anti-join marker not found in materialized join viewouter-join filter not found in materialized join viewno suitable grouping_id found in MV with grouping setsMaterialized view with grouping sets contains duplicatesMaterialized view with grouping sets has too long keymv %s clause more restrictive than query %s clausenon-tolerated reference to stale portion of mv for table %scontainment check failed for mv, %srollup(s) took place on mv, %s N 2 O w P ? Q ? R ? S ST ? ?materialized view, %s, requires join back to table, %s, on column, %sthere is a remote table, %s, referenced in the queryquery is using flashbackno primary key or row id in MV, %s, is found for table, %smaterialized view, %s, is stale with respect to some partition(s) in the base table(s)Partition Containment Tracking (PCT) rewrite is not allowedmaximum number of disjuncts exceeded in the query %s U , V k W (X \Y ?[ ? ?while rewriting with MV, %s, table, %s, migrated to query deltaquery rewrite not possible with materialized view %s because it contains a join between tables (%s) that is not present in the query and that potentially eliminates rows needed by the queryno partition key or partition marker found in MV, %sWHERE clause of mv, %s, is more restrictive than queryHAVING clause of mv, %s, is more restrictive than queryrollup took place on a column with a window function \ 8 ` c a ? c ? d ? e 9f ?g ? ?window function computability checks failedrecursive rewrite not allowed herematerialized view, %s, is TRUSTED in ENFORCED integrity modeself-join algorithm could not resolve multiple instancesset operator materialized view, %s, doesn't have a marker columna more optimal set operator materialized view than %s was used to rewritequery rewritten with set operator materialized view, %squery rewritten with materialized view(s), %s h P i m j ? k ? l ? m n 1o Zp qq ?~ ? ? ?Multi MV rewrite is disabled query has NO_MULTIMV_REWRITE hint Multi MV rewrite not allowed if at least one query block has no MVs query has ONLY_MULTIMV_REWRITE hint query has a named array type columnquery has an ADT columnquery has a hidden or nested table columnquery has an LOB columnquery has a nested table columndimension level, %s, marked as SKIP WHEN NULLquery did not rewritequery was rewritten ? , ? q ? ? ? ? ? ?? ?multi-mv query rewrite not possible when there is a CONNECT BY clausemulti-mv query rewrite not possible when there is an inner query blockmulti-mv query rewrite not possible when there is a START WITH clausemulti-mv query rewrite not possible when there is a Window Functionmulti-mv query rewrite not possible when there is a grouping setmulti-mv query rewrite not possible when there is a set operator ? , ? l ? ? ? ? F? ? ?multi-mv query rewrite not possible when there is a spread sheetmulti-mv query rewrite not possible when there is a nested aggregatemulti-mv query rewrite not possible when the number of disjuncts in the query exceeds 256multi-mv query rewrite not possible when there is a self joinmulti-mv query rewrite not possible when there is an RLS viewmulti-mv query rewrite not possible when there is an unsupported aggregate ? & ? l ? ? ? &? ? ?multi-mv query rewrite not possible when there is a user bind variablemulti-mv query rewrite not possible when an ORDER BY column is not found in the SELECT listmulti-mv query rewrite not possible when an ORDER BY expression is not found in the SELECT listmulti-mv query rewrite not possible when a WHERE clause column comes from an innerquery blockquery rewrite not possible when Fine Grain Auditing is present on a base table ? 8 ? w ? ? ??? ??? D? ~? ? ?query rewrite not possible for a CREATE or ALTER VIEW statementquery rewrite not possible when OPTIMIZER_MODE is set to rule basedquery rewrite not possible on DDL queriesquery rewrite not possible before view mergingquery rewrite not possible when query has slave SQLquery rewrite not possible when query has a NOREWRITE hintquery rewrite not possible for update queriesquery rewritten with materialized view, %s, using text match algorithm ? & ? ? ? ? ? ? ? ?query rewrite not possible because no common table(s) found between materialized view %s and queryquery rewrite not possible when stored outline does not have a rewrite hintquery rewrite not possible when SAMPLE clause is present in FROMquery rewrite not possible when nested aggregates or CONNECT BY clause or START WITH clause or recursive WITH clause is presentquery rewrite not possible if OR is the top level operator in query WHERE clause ? 2 ? w ? ? ? ? K? w? ? ?query rewrite not possible when query GROUP BY clause has non-columnsquery rewrite is likely more expensive due to a single table match between materialized view and queryno suitable materialized view found to rewrite this querymaterialized view, %s, is disabled, stale or unusablematerialized view %s is less optimal than %squery measure cannot be derived from the materialized view %sjoin back could not be done on a view for %s ? 2 ? b ? ? ? ? ? =? n? ? ?join back on correlated columns not allowed (%s)join back cannot be done on a materialized view that does not have an aggregate (%s)materialized view does not have the join back level(s) (%s)query rewrite cannot perform rollup due to the presence of a window functionquery rewrite not possible for this DDL statementquery rewrite not possible for this DML statementquery rewrite not possible when query references a dictionary table or view ? ? ? ? ? ? ^ ?query rewrite not possible because a join in materialized view %s with table %s has eliminated some rows found in queryquery rewrite not possible because materialized view %s has a join not found in queryquery rewrite not possible because materialized view %s and query have different number of joins between tables %squery rewrite not possible because DML operation occurred on a table referenced by materialized view %s & ? ? N ?query rewrite not possible because either a primary key or a row id is required to join table %s with MV %smaterialized view %s has an anchor table %s not found in queryanti-join marker not found in materialized view with joinsno suitable grouping_id found in materialized view with grouping setsquery rewrite not possible because materialized view contains duplicate grouping sets , ? ? d ? ?query rewrite not possible because materialized view with grouping sets has more than 176 different keysmaterialized view %s clause more restrictive than query %s clausequery rewrite not possible because materialized view %s is partially stalequery rewrite not possible because query references a remote table %squery rewrite not possible because query is using flashbackPartition Containment Tracking (PCT) rewrite is not allowed , $ b ) ? 4 5 Q6 ? ?number of 'OR's in query exceeded the maximum value %swindow function could not be computed from materialized view %squery rewrite not possible because materialized view %s has TRUSTED constraints in ENFORCED integrity modequery rewrite not possible because query has a named array type columnquery rewrite not possible because query has an ADT columnquery rewrite not possible because query has a hidden or nested table column 7 2 8 l ; ? < ? = %> l? ? ?query rewrite not possible because query has an LOB columnthe materialized view you specified (%s) was not used to rewrite the queryrewrite not supported on inline view aggregateno inline view match found between query and materialized view(s)joins between materialized view %s and query inline views are differentquery rewrite not possible because query has full outer joingeneral inline view rewrite not possible on remote objects @ 2 A y B ? C D OE F ? ?general inline view rewrite not possible on this WHERE clause constructgeneral inline view rewrite not possible when inline view has subquerygeneral inline view rewrite not possible with nested inline viewsa query inline view could not be matched with any materialized view inline viewan invalid predicate was found in an inline viewgeneral inline view cannot be supported on this inline viewquery rewrite cannot support this inline view G 2 H ? I ? J K J? ?? ? ?query inline view has no matching objects with any materialized view inline viewsSELECT lists of the query and materialized view inline views do not matchno query rewrite on remote objects unless integrity mode is set to stale_toleratedquery rewrite is disabled for remote objectsmulti-mv rewrite not possible in the presence of remote objectsequivalence, %s, matched query texta more optimal equivlanece than %s was used to rewrite ? 8 ? e ? ? $ ? . 90 nA ? ?query rewrite is disabled for equivalence, %squery rewritten with equivalence, %sequivalence, %s, cannot compute measure, %s, in the queryequivalence, %s, cannot support the query measure, %sequivalence, %s, and query have different joins between tables, %sJoining equivalence, %s, with table, %s, not possibleequivalence, %s, has anchor, %s, not found in queryrollup(s) took place on equivalence, %s B 8 J w Q ? R ? S U L? ?? ? ?equivalence, %s, requires join back to table, %s, on column, %sa lossy join in equivalence, %s, between tables, %s, not found in queryequivalence definition is disabledequivalence, %s, is enabled for text match rewrite onlyequivalence cannot be used in ENFORCED integrity modejoin backs to base tables not allowed with an equivalence query rewritten with equivalence, %s, using text match algorithmequivalence %s has an anchor table %s not found in query - J . ? ? ? ? ? ? ? ? +? S? j? ? ?? ? ?recursive query rewrite on equivalence, %s, not permitted semijoin transformation not supported on equivalenceclustered mv container tableDISTINCT aggregate measure in SELECT listaggregate function nested within an expressiongrouping column omitted from SELECT listnamed view in FROM listsubquery in FROM listmultiple instances of the same table or viewnon-join filter condition in WHERE or HAVING clausenon-inner join ? D ? v ? ? ? ? ? ? ? ? 4? P? u? ? ?join predicate with operator other than equals (=)a HAVING clause is presenta CONNECT BY clause is presentSELECT list includes a RAW data type expressionGROUP BY expression other than a columnIndex Organized Table (IOT) present in FROM listclustered table in FROM listsubquery present in the HAVING clausesubquery present in the WHERE clausemv references another mv in FROM clause ? V ? ? ? ? ? ? ? ? ? ? ? ? ? ? +? 8? R? }? ? ?container column not in SELECT list with NOT NULL constraintset operator encountered in mvaggregate selectionsnested cursorno GROUP BY clauseno aggregate functionsnon-AND conjunction in WHERE clausegroup by ROLLUPgroup by CUBEPL/SQL function invocationreduced precision specified for prebuilt mvmaterialized view cannot support any type of query rewriteno joins are present in the WHERE clause ? J ? ~ ? ? ? ? ? ? ? $? N? s? ?? ?? ? no filter conditions are present in the WHERE clauseno joins are present in the HAVING clauseno filter conditions are present in the HAVING clausein-list present in mvcannot evaluate constant expression at compile timePartition Change Tracking (PCT) is enabledtop level mv query uses grouping setstop level query contains GSets and the key is too long for rewritenested aggregate functionview or subquery in from listORDER BY clause in mv ? P ? g | ? ? ? ? 7 [ ? ? ?START WITH clause in mvwindow function in mvouter join in mvsubquery using the ANY clause in mvsubquery using the ALL clause in mvsubquery using the NOT EXISTS clause in mvsubquery using a select list in mvcollection subquery in mvDISTINCT clause in select list in mvmv references a packed object table or viewcorrelated variable and outer join in mvROWNUM referenced in mv D ~ ? ? ? ? ? 7 ~ ? ?set operator in mv and compatibility mode is less than 9.0join may produce duplicate rows in mvone or more joins present in mvGROUP BY clause in mvaggregate function in mvsubquery in mvOracle error: see RELATED_NUM and RELATED_TEXT for detailsno partition key or PMARKER or join dependent expression in select listrelation is not a partitioned tablePCT not supported with multi-column partition key D t ? ? 9 U ? ? ? ?PCT not supported with this type of partitioninginternal error: undefined PCT failure coderequirements not satisfied for fast refresh of nested mvnon-primary key RepAPI mv is not fast refreshablematerialized view over Heterogeneous Services linkmaterialized view on synonymsequence number in the mv log is newer than last refreshmv log is newer than last full refreshmv log must have new valuesmv log must have ROWID D ! ` " ? # ? $ ? & ( 4* k+ ?, ? ?mv log must have primary keymv log does not have all necessary columnsproblem with mv logmv references PL/SQL function that maintains stateDISTINCT clause on a duplicate sensitive aggregate functionmv uses the MIN or MAX aggregate functionsmv omits at least one grouping key from the select listSELECT includes an expression that is not just a columnmv references a non-repeatable or session-sensitive expressionmv references a sequence number - > 0 Z 3 t 5 ? 6 ? 8 : B@ zA ? ?mv uses an object REF clausemv references a named viewmv references a remote table or view in the FROM listmv references a synonym in the FROM listmv FROM list references an object in the SYS schema aggregate function in a filter condition in the HAVING clausemv uses a filter condition in the WHERE or HAVING clausetop level query has LEFT OUTER, RIGHT OUTER or FULL OUTER joinexpression in select list references multiple tables or views B > C | D ? E ? F G H ]I ?J ? ?no GROUP BY clause, no aggregates and not >= 9.0 compatibilitymv references a remote object and is refreshed ON COMMITmupltiple master sitesmissing GROUPING_ID or GROUPING functions on GROUP BY column(s)duplicate grouping setsinternal error while analyzing required supporting aggregatescompatibility mode must be 9.0 or higherset operator in a context not supported for fast refreshcompatibility mode must be 8.1 or higher K > L n M ? N ? O ? P Q PR wS ? ?subquery and UNION mv's must be primary key mv'sobject type in WHERE clausesubquery join conditions don't meet requirements for capabilityno rowid at master sitenot supported for this type mv by Oracle version at master sitedoes not meet the requirements of a primary key mvjoin or filter condition(s) are complexexpression not supported for fast refreshagg(expr) requires correspondng SUM(expr) function T 8 U l V ? W ? X Y 9Z n[ ? ?agg(expr) requires correspondng COUNT(expr) functionagg(expr) requires correspondng MIN(expr) functionagg(expr) requires correspondng MAX(expr) functionagg(expr) requires correspondng AVG(expr) functionagg(expr) requires correspondng VARIANCE(expr) functionagg(expr) requires correspondng STDDEV(expr) functionagg(expr) requires correspondng agg(expr*expr) functionagg(expr) requires correspondng agg(expr+expr) function \ 8 ] o ^ ? _ ? ` ? a -b kc ? ?agg(expr) requires correspondng SUM(expr*expr) functionthe reason why the capability is disabled has escaped analysisCOUNT(*) is not present in the select listSUM(expr) without COUNT(expr)aggregate functions are present without a GROUP BY clauseGROUP BY clause is present but no aggregate functions are usedsee the reason why REFRESH_FAST_AFTER_INSERT is disableddefault date format is sensitive to session settings d 2 e q f ? g ? h i Zj ? ?many to many subquery joins require 9.0 compatibility or higherON COMMIT with this MV requires 9.0 compatibility or higherselect lists must be identical across the UNION operatorsubquery or named view in FROM list and < 9.0 compatibilitysubquery or named view in FROM list even after view merginginline view or subquery in FROM list not supported for this type MVMV is not fast refreshable even with view merging k 2 l r m ? n ? o :p lq ? ?top level query with GSETS does not contain a proper grouping_idtop level query with GSETS contains duplicatesPCT is not possible on any of the detail tables in the materialized viewgeneral rewrite is not possible or PCT is not possible on any of the detail tablesquery rewrite is disabled on the materialized viewthe materialized view is specified as NEVER REFRESHsee the reason why REFRESH_FAST_AFTER_ONETAB_DML is disabled r 8 s n t ? u ? v ? w x Uy ? ?the detail table does not have a materialized view logcannot use object id columns from materialized view logthe materialized view is BUILD DEFERREDmv log does not have sequence #problem with loader logthe materialized view is upgraded from a previous version that does not support PCTthe materialized view has a WITH clause in the top level querythe materialized view contains partition extended table name z 2 { d | ? } ? ~ 4 q? ? ?tables must be identical across the UNION operatorthe materialized view has a join operation in the outer UNION blockthe SELECT list does not have the rowids of all the detail tablesthe unique constraints does not exist on the join columns of the inner tablethe materialized view does not have a UNION ALL marker columnsome query block in UNION ALL MV is not fast refreshableMV with UNION ALL in a view is too complex ? > ? { ? ? ? ? ? ? /? W? ?? ? ?MV with UNION ALL in a view must match the view's SELECT listMV has a view with UNION ALL that is not fast refreshableMV with UNION ALL requires compatibility >= 9.2no primary key constraint in the master tablea SPREADSHEET clause is presentPCT is enabled through a join dependencyExpression to enable PCT not in PARTITION BY of analytic function or SPREADSHEETExpression to enable PCT cannot be rolled upno partition key or PMARKER in select list ? P ? q ? ? ? ? ? ? ? ? 0? b? ?? ?? ?? ? ?PARTITIONED OUTER JOIN is presentmaterialized view on external tablenamed view in FROM list not supported for this type MVmaterialized view definition changesSQL PIVOT or UNPIVOT is presenttypes of MV logs are not compatiblecommit SCN based MV log is not in consistent stateunsupported MV on commit SCN based MV logsCASE expressions present in materialized viewSpecifies logging of messages to the advisor journalUnused ? & ? ? ? ? Q? ? ?When enabled, the SQL Access Advisor will weigh the cost of creation of the access structure against the frequency of the query and potential improvement in the query execution timeThe expiration time in days for the current SQL Access Advisor taskThe default owner for the new index recommendationsThe default tablespace for new index recommendationsThe default owner for the new materialized view recommendations ? 2 ? r ? ? ? I? o? ?? ? ?The default tablespace for new materialized view recommendationsThe default tablespace for new materialized view log recommendationsWhen enabled, the SQL Access Advisor will consider the impact of index maintenance and materialized view refresh in determining the recommendationsThe end time filter for selecting dataDeprecated. Please use ANALYSIS_SCOPEDeprecated. Please use ANALYSIS_SCOPEThe format SQL Access Advisor uses to construct new index names ? , ? ? ? ? 8? `? ? ?Specifies either a limited or comprehensive analysis operation, where limited runs in less time but may produce slightly lower quality resultsSpecifies the types of recommendations generated by SQL Access AdvisorThe format used to construct new materialized view namesDeprecated. Please use RANKING_MEASURE.Specifies whether materialized views should be refreshed ON_DEMAND or ON_COMMITThe default date and time format when displayed in scripts and reports ? , ? _ ? ? ? ? ? *? p ?The maximum number of SQL statements to be analyzedThe start time filter for selecting dataContains the amount of space adjustment that can be consumed by SQL Access Advisor recommendationsThe database version under which the recommendations must be usedContains a fully qualified list of tables that are eligible for tuningContains a fully qualified list of tables that are NOT eligible for tuning ? , ? o ? ? ? ? ? <? ? ?Describes the level of application coverage the workload representsContains a list of application actions that are eligible for tuningContains a list of application actions that are NOT eligible for tuningContains a list of application modules that are eligible for tuningContains a list of application modules that are NOT eligible for tuningContains a list of users who execute SQL statements that are eligible for tuning ? & ? z ? ? ?? ? ?Contains a list of users who execute SQL statements that are NOT eligible for tuningContains a list of text items that can appear in SQL statements. If a statement does not contain one the specified items, then it is not eligible for tuningContains a list of text items that can appear in SQL statements. If a statement contains one the specified items, then it is not eligible for tuningUnusedDeprecated. Please use VALID_ACTION_LIST ? 8 ? e ? ? ? ? ? ? ? @? ?? ? ?The maximum time that an analysis can executeThe default tablespace for new partition recommendationsUnsupportedWhen enabled, an IMPLEMENT_TASK operation will stop processing on the first errorThe starting point for the Enterprise Manager SQL Access Advisor WizardThe default workload source for the Enterprise Manager SQL Access Advisor WizardDeprecated. Please use VALID_MODULE_LISTWhen enabled, all user-specified workload filtering will be disabled ? & ? ? ? ? ? &? d ?When enabled, RETAIN actions will be displayed in scripts and within the Enterprise Manager SQL Access Advisor Wizard task resultsSpecifies how the STORAGE_CHANGE parameter is interpretedWhen enabled, exact text match materialized views will be recommendedValue used to indicate acceptable overall workload performanceValue used to indicate significant potential improvement of overall workload performance ? 2 ? y ? ? ? ? L? y? ? ?Weighted value used to indicate acceptable overall workload performanceWeighted value used to indicate significant potential improvement of overall workload performanceMaximum number of partitioning schemes to investigateMaximum number of partitions for any particular target objectFormat used to construct new partition names.Approach used when recommending partitions.Permitted partition types for recommendations. ? 2 ? ? ? ? ? ? X? ?? ? ?Primary natural order in which the SQL Access Advisor processes workload elements during an analysis operationRecommend optimal tablespaces for partitioning recommendationsDerive secondary structures from existing base table partitionsHonor Information Lifecycle Management partitioning schemesPlace new partitions into separate tablespacesUse sampling to avoid scanning a very large workloadUse compression to reduce a large target workload. 8 a ? ? ? ! -" n# ? ?Start of hypothetical workload generationHypothetical workload generation completed succesfully.Hypothetical workload generation completed with errors.Dimension %s.%s is loaded.Fact-key between table %s.%s and dimension-table %s.%s is discarded.Fact-key between table %s.%s and dimension-table %s.%s is loaded.Dimension %s.%s is defined on table %s.%s.There are no valid dimensions present in the user-specified scope. $ 8 % { & ? ' ? ( 8) e* ?+ ? ?There are no valid fact-tables present in the user-specified scope.The Hypothetical Workload Generator has run out of memory.The Hypothetical Workload Generator encountered an OCI error: %s.Dimension table %s.%s does not have a primary or unique-key level.Invalid CREATE MATERIALIZED VIEW statement %sCannot tune the MATERIALIZED VIEW statement %sCannot tune FOR UPDATE materialized viewCannot tune materialized view ON PREBUILT table , & - n . ? / ? 0 SThe materialized view is already optimal and cannot be tuned any furtherCannot tune the materialized view to be fast refreshableCannot tune the materialized view for general rewriteThe WHERE/HAVING clause is too complex for general query rewriteCannot create materialized view log on encrypted columns ?? ??
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de