<ROOT>
 <APPS_INITIALIZE_DATA>
  <USER_NAME>ENGINATICS</USER_NAME>
  <RESPONSIBILITY_KEY>SYSTEM_ADMINISTRATOR</RESPONSIBILITY_KEY>
  <APPLICATION_SHORT_NAME>SYSADMIN</APPLICATION_SHORT_NAME>
 </APPS_INITIALIZE_DATA>
<REPORTS>
<!-- loader xml for Enginatics Blitz Report: DBA SGA Target Advice -->
 <REPORTS_ROW>
  <GUID>72273AD8EA3E1642E0530100007F2322</GUID>
  <SQL_TEXT>select
gsta.inst_id,
gsta.sga_size_factor,
gsta.sga_size/1024 sga_size,
gsta.estd_db_time_factor*100 estd_db_time_percent,
gsta.estd_physical_reads_factor*100 estd_physical_reads_percent
from
(
select
gsta.*,
gsta.estd_physical_reads/max(decode(gsta.sga_size_factor,1,gsta.estd_physical_reads)) over (partition by gsta.inst_id) estd_physical_reads_factor
from
gv$sga_target_advice gsta
) gsta</SQL_TEXT>
  <ENABLED>Y</ENABLED>
  <NUMBER_FORMAT>#,##0.00;[Red]-#,##0.00</NUMBER_FORMAT>
  <REPORT_TRANSLATIONS>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>AR</LANGUAGE>
    <REPORT_NAME>DBA SGA Target Advice</REPORT_NAME>
    <DESCRIPTION>عرض المشورة الهدف SGA في Orace.
يُظهر تقديرًا لكيفية تأثير تغيير حجم SGA على الوقت الإجمالي لقاعدة البيانات وعمليات الإدخال والإخراج.</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>D</LANGUAGE>
    <REPORT_NAME>DBA SGA Target Advice</REPORT_NAME>
    <DESCRIPTION>Die Ansicht &quot;SGA-Zielberatung&quot; von Orace.
Sie zeigt eine Schätzung, wie sich eine SGA-Größenänderung auf die gesamte Datenbankzeit und die IO auswirken würde.</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>E</LANGUAGE>
    <REPORT_NAME>DBA SGA Target Advice</REPORT_NAME>
    <DESCRIPTION>Vista de asesoramiento de la SGA de Orace.
Muestra una estimación de cómo un redimensionamiento de la SGA afectaría al tiempo total de la base de datos y al IO.</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>F</LANGUAGE>
    <REPORT_NAME>DBA SGA Target Advice</REPORT_NAME>
    <DESCRIPTION>Le point de vue de la SGA d&apos;Orace sur les conseils en matière de cibles.
Il montre une estimation de la manière dont un redimensionnement de la SGA affecterait le temps global de la base de données et les OI.</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>I</LANGUAGE>
    <REPORT_NAME>DBA SGA Target Advice</REPORT_NAME>
    <DESCRIPTION>Vista del consiglio sull&apos;obiettivo SGA di Orace.
Mostra una stima di come un ridimensionamento dell&apos;SGA influenzerebbe il tempo complessivo del database e l&apos;IO.</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>JA</LANGUAGE>
    <REPORT_NAME>DBA SGA Target Advice</REPORT_NAME>
    <DESCRIPTION>Orace の SGA ターゲットアドバイスビュー。
これは、SGA のサイズ変更がデータベース全体の時間と IO にどのような影響を与えるかの推定を示しています。</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>KO</LANGUAGE>
    <REPORT_NAME>DBA SGA Target Advice</REPORT_NAME>
    <DESCRIPTION>Orace의 SGA 목표 조언보기.
SGA 크기 조정이 전체 데이터베이스 시간 및 IO에 미치는 영향에 대한 추정치를 보여줍니다.</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>PTB</LANGUAGE>
    <REPORT_NAME>DBA SGA Target Advice</REPORT_NAME>
    <DESCRIPTION>A visão SGA da Orace de aconselhamento de alvos.
Ela mostra uma estimativa de como um redimensionamento SGA afetaria o tempo total do banco de dados e o IO.</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>RU</LANGUAGE>
    <REPORT_NAME>DBA SGA Target Advice</REPORT_NAME>
    <DESCRIPTION>Взгляд на цель SGA Ораса.
Он показывает оценку того, как изменение размера SGA повлияет на общее время базы данных и IO.</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>S</LANGUAGE>
    <REPORT_NAME>DBA SGA Target Advice</REPORT_NAME>
    <DESCRIPTION>Oraces SGA-målrådsvy.
Det visar en uppskattning av hur en SGA-storlek skulle påverka den totala databastiden och IO.</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>TR</LANGUAGE>
    <REPORT_NAME>DBA SGA Target Advice</REPORT_NAME>
    <DESCRIPTION>Orace&apos;ın SGA hedef tavsiyesi görünümü.
Bir SGA yeniden boyutlandırmasının genel veritabanı süresini ve GÇ&apos;yi nasıl etkileyeceğine dair bir tahmin gösterir.</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>US</LANGUAGE>
    <REPORT_NAME>DBA SGA Target Advice</REPORT_NAME>
    <DESCRIPTION>Orace&apos;s SGA target advice view.
It shows an estimation of how an SGA resize would affect overall database time and IO.</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>ZHS</LANGUAGE>
    <REPORT_NAME>DBA SGA Target Advice</REPORT_NAME>
    <DESCRIPTION>Orace 的 SGA 目标建议视图。
它显示了SGA大小调整对整个数据库时间和IO影响的估计。</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
  </REPORT_TRANSLATIONS>
  <CATEGORY_ASSIGNMENTS>
   <CATEGORY_ASSIGNMENTS_ROW>
    <CATEGORY>Enginatics</CATEGORY>
   </CATEGORY_ASSIGNMENTS_ROW>
  </CATEGORY_ASSIGNMENTS>
  <ANCHORS>
  </ANCHORS>
  <PARAMETERS>
  </PARAMETERS>
  <PARAMETER_DEPENDENCIES>
  </PARAMETER_DEPENDENCIES>
  <TEMPLATES>
  </TEMPLATES>
  <DEFAULT_TEMPLATES>
  </DEFAULT_TEMPLATES>
  <UPLOAD_COLUMNS>
  </UPLOAD_COLUMNS>
  <UPLOAD_PARAMETERS>
  </UPLOAD_PARAMETERS>
  <UPLOAD_SQLS>
  </UPLOAD_SQLS>
  <UPLOAD_DEPENDENCIES>
  </UPLOAD_DEPENDENCIES>
 </REPORTS_ROW>
</REPORTS>
</ROOT>
