[ Pobierz całość w formacie PDF ]
.XDL file, 5-13instance parameters category, 5-10Instance Statistics category, 5-10Iparameters tuned, 5-15I/O parameterSample Frequency list box, 5-12in instance tuning, 1-3, 4-6tuning multiple instances, 5-12Implement page.See tuning session window.when to collect, 5-14implementation filesinstance object, 6-10description, 9-1attribute, 6-10how to use, 9-2rule, 6-10implementation scripts, 2-4, 2-7statistics attribute, 6-10location, 9-1Instance Parameters category of Instance class, 5-tuning output, 2-710implementation scripts, 2-4, 2-7instance recommendationsimplementing recommendations, 2-4, 9-1implementing, 9-2importanceinstance rules, 6-10used in workloadinstance statisticsdescription, 6-13canceling collection of multiple samples, 5-13importance valuecollecting multiple samples, 5-12in workload class, 5-27how instance is performing, 5-12in workload data, A-7maintaining history of, 5-12possible values for, A-7sample, 5-12specifying for workload elements, A-7Instance Statistics categoryIndex-4of Instance class, 5-10 used in Environment class, 5-23instance tuning, 1-3 menudescription, 1-3, 4-6 Edit pull-down, 6-1I/O parameter, 1-3, 4-6 messagesOS specific parameter, 4-7 Work in Progress dialog box, 1-5parallel query parameter, 1-4, 4-7 methodologyparallel server parameter, 4-7 steps in Oracle Expert, 2-1recommendations, 5-13, 5-14 modifying object rules, 6-3SGA parameter, 1-3, 4-6sort parameter, 1-4, 4-7NinstantiationName/Version categoryof a rule, 6-5of Database class, 5-6removing, 6-6naming of workload elements, A-6invalid dataNew Tuning Session dialog boxapplication, 5-34Control Parameters page, 4-9purging invalid requests from, 6-7Scope page, 4-5cluster, 5-34collecting, 5-34deleting, 6-7Odiscovered during a collection, 5-34objectdiscovered during an analysis, 7-6adding, 6-2excluding from an analysis, 5-35children of, 6-5, 6-7index, 5-34deleting, 6-7request, 5-34excluding from an analysis, 7-4schema, 5-34, 7-6exporting, 6-8symbol used to mark, 5-34invalid, 5-34table, 5-34validating, 6-7invalid requestsobject rulesdeleting as part of validation, 6-7modifying, 6-3removing during workload collection, 5-30, 5-opening31, 5-32an existing tuning session, 4-9saving during workload collection, 5-30, 5-31, 5-operating system data32used in Environment class, 5-23optimizerLcost-basedaccess method rules addressing, 4-8logical device datarules-baseddeleting previously collected, 5-26lack of rules addressing, 4-8keeping previously collected, 5-26option, A-9logical device object, 6-13Oracle Expertassigning names to workload elements, A-6MOracle Servermatching.See SQL statement matching.impact of installing new version of, 5-14memory data Oracle TraceIndex-5collecting frequency value, A-7 public synonymusing to collect workload data, 5-30, A-3 as database object, 6-12using to format raw data, A-4 Public Synonyms category of Database class, 5-6Oracle Trace databasecollecting workload data from, 5-30Rconnecting to, 5-30Recommendation Summary report, 2-7importing data from, A-4contents of, 10-3ORANT, 1-7generating, 10-2OS specific parameterRecommendation Summary Report dialog box, 10-in instance tuning, 4-73output.See tuning output.recommendationsOverwrite Existing option, 5-9, 5-20, 5-26, 5-32displaying index analysis, 7-2deleting previously collected workload data, A-effect of tuning categories on, 4-48for initial configuration, 12-5implementing, 2-4, 9-1Pin Analysis report, 10-2parallel query option obtaining less conservative, 5-14impact of enabling, 5-9, 5-14 reviewing, 2-4parallel query parameter reportsin instance tuning, 1-4, 4-7 generating, 10-1parallel server option reports.See also Session Data report, Analysis re-impact of enabling, 5-9, 5-14 port.parallel server parameter repository, 4-3in instance tuning, 4-7 connecting to, 3-1parameter file, 2-4 requesttuning output, 2-7 in workload hierarchy, A-5password invalid, 5-34for instances imported from.XDL files, 5-13 used in workload, 6-14performance Review Recommendations page.See tuning sessionexamples of poor, A-2 window.performance tuning reviewing recommendations, 2-4, 8-1comprehensive tuning, 1-5 Rulefocused tuning, 1-5 Index summary style, 7-2application tuning, 1-4 Tunable, 7-4instance tuning, 1-3 rules, 2-6structure tuning, 1-4 advanced, 6-6initial configuration, 1-5 general principles of instance, 6-10types of, 1-3 instantiating, 6-5performance tuning.See also database tuning.affect, 6-5Personnel session, 1-7 of a database object, 6-9placement of an instance object, 6-10in structure tuning, 1-4, 4-8 online description, 6-6privileges taking advantage of, 11-3required to access a database, 4-4 rules page, 6-5Index-6contents of, 10-1Sgenerating, 10-1Sample Frequency list boxSession Data Report dialog box, 10-1using during instance collection, 5-12session.See tuning session [ Pobierz całość w formacie PDF ]