Examples with "use the sql performance analyzer" and their translation in Japans
We konden deze vermelding niet vinden. Er worden benaderende resultaten weergegeven. Controleer je spelling of stel voor deze term aan het woordenboek toe te voegen.
To use the SQL Performance Analyzer parameter change workflow
You can use the SQL Performance Analyzer to ensure that an upgrade or other changes do not regress the application SQL. Figure 7-1 shows the suggested workflow to test and tune an existing version 10.2 production database for migration as a new version 11.1 production database.
You can use the SQL Performance Analyzer Report to obtain detailed statistics for the SQL workload comparison. The details chart enables you to drill down into the performance of SQL statements that appears in the report. Use the information in this section to investigate why the performance of a particular SQL statement regressed.
Use the SQL Performance Analyzer report to compare a SQL tuning set from a workload capture to another SQL tuning set from a workload replay, or two SQL tuning sets from two workload replays.
Use the SQL Performance Analyzer Task page to see the results of a specific SQL Performance Analyzer task that has executed for a SQL Tuning Set. A SQL Performance Analyzer task enables you to execute a specific SQL Tuning Set under changed environmental conditions. After you have executed the task, you can assess the impact of these changes on the performance of the SQL Tuning Set.
SQL Performance Analyzer can automatically simulate the effect of a database upgrade on SQL performance. All SQL statements use the optimizer, which is a part of Oracle Database that determines the most efficient means of accessing the specified could use the SQL Performance Analyzer to compare the performance of SQL execution when using the 10.2.0.2 and 11.1.0.1 versions of the optimizer.
Create a pre-change SQL trial before making the system change. You can use the following methods to generate the performance data needed for a SQL trial with SQL Performance Analyzer
If you chose to generate explain plans only in the SQL trials, then SQL Performance Analyzer will use the optimizer cost stored in the SQL execution plans.
Er worden alleen voorbeelden gegeven om u te helpen het woord of de woordcombinatie waarop u hebt gezocht, te vertalen. Deze worden niet door ons geselecteerd of gevalideerd en kunnen ongepaste taal bevatten. Wij vragen u melding te maken van voorbeelden die dienen te worden aangepast of verwijderd. Vertalingen met grof of informeel taalgebruik worden meestal rood of oranje gemarkeerd.