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.
You can view this data in a tabular format by clicking the Latest Collection legend or Baseline legend and looking at the General Information area in the SQL Response Time page can also use this page to view all SQL statements included in the baseline, and to view all the collections that exceed the threshold.
If the reference collection is empty, click Reset Reference Collection to create another collection. If the collection is not empty, you can view the contents of the collection by clicking Edit Reference Collection. The Edit SQL Response Time Reference Collection page appears. You can use this page to remove SQL statements from the collection.
参照収集が空の場合は、≪参照収集のリセット|Reset Reference Collection|emdw≫をクリックして別の収集を作成します。収集が空でない場合は、≪参照収集の編集|Edit Reference Collection|emdw≫をクリックすれば収集の内容を表示できます。≪SQLレスポンス時間の参照収集の編集|Edit SQL Response Time Reference Collection|emdw≫ページが表示されます。このページを使用して、収集からSQL文を削除できます。
Percentage of SQL response time
SQLレスポンス時間の割合
Because of baseline configuration, there will be a delay between the time the database is configured and the value of the metric is displayed. During this period, the message of the collection status will be displayed for SQL Response Time.
SQL Response Time is the average elapsed time per execution of a representative set of SQL statements, relative to a baseline. It is expressed as a percentage.
Some tables and a PL/SQL package must be installed on the monitored can be done by going to the database targets page and pressing the Configure button for your a database has not been configured, the message "Not configured" will be displayed for SQL Response Time.
The baseline is configured on demand, first time the agent calls the stored procedure to get the value of the metric, a snapshot of V$SQL is taken. The second time, another snapshot is taken. Then the representative statements are picked and stored in a table. The next time the agent requests the value of the metric, we are able to calculate and return the relative SQL response time.
If the SQL Response Time is less than 100%, then SQL statements are taking less time to execute when compared to the baseline. Response Time greater than 100% indicates that the database is not performing well when compared to the baseline.
You can use SQL Performance Analyzer to test the impact on SQL response time of a database upgrade from Oracle Database 10g Release 2 or a newer release to any later release by capturing a SQL tuning set on the production system, then executing it twice remotely over a database link on a test system-first to create a pre-change SQL trial, then again to create a post-change SQL trial.
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.