[ Pobierz całość w formacie PDF ]
.Examples of these parameters include the checkpoint_process anddb_file_multiblock_read_count parameters.These parameters can be selected as acategory to be tuned as part of an instance tuning session.See also instance tuningsession, parallel query parameters, SGA parameters, sort parameters, Oracle Parallel Serverparameters, and operating system-specific parameters.operating system-specific parametersThese instance parameters affect performance and are specific to certain hardwareplatforms.Examples of these parameters include the async_write and thedb_writers parameters.These parameters can be selected as a category to be tunedas part of an instance tuning session.See also instance tuning session, I/O parameters,SGA parameters, parallel query parameters, sort parameters, and Oracle Parallel Serverparameters.Oracle Parallel Server parametersThese parameters influence the performance or configuration of the parallel serverenvironment.Selecting the Oracle Parallel Server parameters category for tuning isrelevant only if the Oracle Parallel Server option is installed.These parameters canbe selected as a category to be tuned as part of an instance tuning session.See alsoinstance tuning session, I/O parameters, SGA parameters, sort parameters, parallel queryparameters, and operating system-specific parameters.Glossary-5 parallel query parametersThese instance parameters are specific to the parallel query behavior for theinstance.Examples of these parameters include the parallel_min_servers andparallel_max_servers parameters.Selecting the parallel query parameters categoryfor tuning is relevant only if the parallel query option is installed.These parame-ters can be selected as a category to be tuned as part of an instance tuning session.See also instance tuning session, I/O parameters, SGA parameters, sort parameters, OracleParallel Server parameters, and operating system-specific parameters.parallel server parametersSee Oracle Parallel Server parameters.placementA category of structure tuning.Oracle Expert makes recommendations about place-ment of structures, such as segment partitioning and placement of database files.Oracle Expert may recommend separating segments into different tablespaces tominimize tablespace free space fragmentation and maximize administrative flexibil-ity.Oracle Expert may also recommend distributing database files across drives,which reduces the service and queue times per I/O and the number of I/Os.Seealso sizing.Recommendation Summary reportA report that lists the Oracle Expert tuning recommendations.It provides the rea-sons why you received the recommendations.relative importanceA value that ranks a workload element s importance compared to all the otherworkload elements.Oracle Expert computes the relative importance for each work-load element.The factors that Oracle Expert takes into account when computing arelative importance value for a workload element are the element s workload cate-gory (Application, Business Unit, Transaction, or Request), importance value, andfrequency value.See also importance.reportsInformation that Oracle Expert can generate about the collected data for a tuningsession (Session Data report) or the recommendations it has generated (Analysisreport or Recommendation Summary report).See also Analysis report, Session Datareport, and Recommendation Summary report.Glossary-6 repositoryA schema in an Oracle database that stores the data associated with each OracleExpert tuning session.representative workloadA workload that includes a representative set of the SQL statements that executeduring a period for which you want Oracle Expert to optimize database perfor-mance.You would typically provide valid importance values for the elements in arepresentative workload to allow Oracle Expert to optimize performance for thestatements with the highest relative importance.RequestA SQL statement.Requests are the elements at the lowest level of the workloadhierarchy, below Transactions.See also Application, Business Unit, and Transaction.rulesPieces of knowledge used by Oracle Expert to analyze collected data for a tuningsession.Oracle Expert allows you to view some of its rules, and you can modifythe value of any rule you view.Modifying rule values may change the behavior ofOracle Expert during an analysis and also its recommendations.See also advancedrules and default rules.scopeA setting that determines the categories of database tuning Oracle Expert willaddress for a given tuning session.You choose the scope when you create a newtuning session, and you can modify the scope for a tuning session.You can chooseone or more tuning categories from one or more of the tuning types: instance tun-ing, application tuning, and structure tuning.See also instance tuning session, appli-cation tuning session, and structure tuning session.sessionSee tuning session.Session Data reportA report that describes all the collected data for an Oracle Expert tuning session.You can read this report before starting an analysis of the collected data to confirmthat you provided Oracle Expert with all the data it expects for your tuning session.Glossary-7 SGA parametersThese instance parameters affect the total size of the instance s System Global Area(SGA) [ Pobierz całość w formacie PDF ]

  • zanotowane.pl
  • doc.pisz.pl
  • pdf.pisz.pl
  • hanula1950.keep.pl

    		•