/       !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~contents[[Ljava/lang/Object;()VCodeLineNumberTable getContents()[[Ljava/lang/Object; SourceFileVdktItwMsg.java [Ljava/lang/Object;java/lang/Object3001Oracle Index Tuning Wizard3002Index Tuning Wizard3006 Welcome 3007The Index Tuning Wizard helps you proactively optimize the indexes in your database environment. Use the Index Tuning Wizard to evaluate your indexes when:3008%- SQL statement response time is slow3009>- New applications have been added to the database environment3010A- The SQL statements for existing applications have been modified3011YIndex recommendations and supporting details are provided. If you agree with a recommendation, the Index Tuning Wizard will help you implement the change. NOTE: The Index Tuning Wizard is designed to tune indexes used by the Oracle cost-based optimizer. You should not use this wizard to tune indexes used by the Oracle rule-based optimizer.3012Display this page next time.3031Application Type3032OThe Index Tuning Wizard bases recommendations on your primary application type.3033EWhat is the primary type of application used within the {0} database?3034$Online Transaction Processing (OLTP)3035Many concurrent users will perform numerous transactions requiring rapid access to data. Availability, speed, concurrency, and recoverability are the key issues.3036Data Warehousing3037Users will perform numerous, complex queries that process large volumes of data. Response time, accuracy, and availability are the key issues.3038 Multipurpose30395Both types of applications will access this database.3050Schema Selection3051The Index Tuning Wizard evaluates the tables in schemas referenced by the worst performing SQL statements and identifies index optimizations that have the highest impact on overall database performance.3052&Which schemas do you want to consider?3053 Any schema3054]Considers any schema having a table referenced by one of the worst performing SQL statements.3055Selected schemas3056iConsiders the selected schema(s) having a table referenced by one of the worst performing SQL statements.3057Available Schemas: 3058Selected Schemas: 3071Index Recommendations3072Press the Generate button to start the evaluation process. Upon completion, a list of index recommendations will be displayed. Clear the check box for any recommendations you do not want to implement at this time.3073Generate3075 Details...3076/ Press Generate to start the evaluation.30770 No indexing problems have been detected.3078Generating Recommendations...3079dStarting a new evaluation purges all existing data. Are you sure you want to start a new evaluation?3080Generating Reports...3081Loading Reports...3082*** Operation Complete ***3083&All table recommendations are checked.3084%No table recommendations are checked.3085'Some table recommendations are checked.3086This recommendation is checked.3087#This recommendation is not checked.3088Recommendation Details3090Analysis Report and Script3091Analysis Report3092Report3093Script3094Print...3095 Save as...3096;You have no recommendations, so a script was not generated.3097A report was not generated.3098The file {0} could not be read.3141Finish3142OCheck the actions you want the Index Tuning Wizard to perform and click Finish.3144Implement Recommendations3145Executes the script immediately. This may take some time depending on the number of recommendations and the size of the tables.3146 Save as an Implementation Script3147'Save as an Oracle Expert Tuning Session3148qAllows you to modify this tuning session in Oracle Expert. Oracle Expert provides additional tuning capabilities.3149 (Done)3150 Filename: 3151 Name: 3152...3161&Index Tuning Wizard: Work In Progress3162 Canceling...3163 Error completing current process3164Initializing application3165*Connecting to the Oracle Management Server3166Connecting to repository3167Validating repository3168!Connecting to {0} target database3169 Initializing backend rule engine3170Processing done.3171Error on step: 3172Processing failed.3173Processing cancelled by user.3174#Processing was forcibly terminated.3175Cancel Processing3176Close3177 Show Details3178 Hide Details4003 OK 4004 St&op 5000-Cancel the Index Tuning Wizard. Are you sure?5002XYou have not selected any schema. Select the schema you want to focus the evaluation on.5003jYou have not generated any recommendations. Press the Generate button to begin generating recommendations.5004An error occured while generating recommendations. Press the Generate button to try generating recommendations again, or press Cancel to leave the Index Tuning Wizard.5005mGenerating recommendations may take some time. Are you sure you want to begin generating recommendations now?5006eYou have not specified a name for each item you wish to save. Enter a name for each item to be saved.5007#Error connecting to target database5008$Error obtaining list of schema names5009&Error initializing backend rule engine5010Error connecting to repository5011Unknown Exception5012 Error generating recommendations5013"Error implementing recommendations5014Error validating repository5015{You have recommendations and have not selected any finish options. Are you sure you want to close the Index Tuning Wizard?50167Are you sure you want to close the Index Tuning Wizard?5017*Error initializing the Index Tuning Wizard5018ZThe tuning session name, {0}, has more than 48 characters.Shorten the tuning session name.5019s Implementation failed. Save the implementation script, fix the error, then use the script to implement manually.6000Oracle Index Tuning Wizard Help6002vdktitw"oracle/sysman/resources/VdktItwMsgjava/util/ListResourceBundle$oracle/sysman/resources/VdktItwMsgID!*/=}eiYYSYSSYYSYSSYY SY SSYY SY SSYY SYSSYYSYSSYYSYSSYYSYSSYYSYSSY YSYSSY YSYSSY YSYSSY YSYSSY YSY SSYY!SY"SSYY#SY$SSYY%SY&SSYY'SY(SSYY)SY*SSYY+SY,SSYY-SY.SSYY/SY0SSYY1SY2SSYY3SY4SSYY5SY6SSYY7SY8SSYY9SY:SSYY;SYSSYY?SY@SSYYASYBSSYYCSYDSSY YESYFSSY!YGSYHSSY"YISYJSSY#YKSYLSSY$YMSYNSSY%YOSYPSSY&YQSYRSSY'YSSYTSSY(YUSYVSSY)YWSYXSSY*YYSYZSSY+Y[SY\SSY,Y]SY^SSY-Y_SY`SSY.YaSYbSSY/YcSYdSSY0YeSYfSSY1YgSYhSSY2YiSYjSSY3YkSYlSSY4YmSYnSSY5YoSYpSSY6YqSYrSSY7YsSYtSSY8YuSYvSSY9YwSYxSSY:YySYzSSY;Y{SY|SSY<Y}SY~SSY=YSYSSY>YSYSSY?YSYSSY@YSYSSYAYSYSSYBYSYSSYCYSYSSYDYSYSSYEYSYSSYFYSYSSYGYSYSSYHYSYSSYIYSYSSYJYSYSSYKYSYSSYLYSYSSYMYSYSSYNYSYSSYOYSYSSYPYSYSSYQYSYSSYRYSYSSYSYSYSSYTYSYSSYUYSYSSYVYSYSSYWYSYSSYXYSYSSYYYSYSSYZYSYSSY[YSYSSY\YSYSSY]YSYSSY^YSYSSY_YSYSSY`YSYSSYaYSYSSYbYSYSSYcYSYSSYdYSYSSYeYSYSSYfYSYSSYgYSYSSYhYSYSS@