AtlasDashboards < ArdaGrid

ArdaGrid Web>Dashboard>AtlasDashboards (2009-11-11, RicardoRocha) (raw view)
%TOC%

---+ Databases

---++ Migration Summary

*Query Results* (3rd Nov 2009)

|  *Dashboard*  |  *Account*  |  *Tables Size (GB)*  |  *Indexes Size (GB)*  |  *Total Size (GB)*  |  *Expected migration*  |
|  DDM Dashboard  |  atlas_dashboard_dm@atlas_dashboard  |  136.903  |  140.839  |  277.742  |  Table dependent ([[#DdmTables][see here]])  |
|  Prodsys Dashboard  |  atlas_dashboard_prod@atlas_dashboard  |  53.039  |  61.242  |  114.282  |  Full database migration  |
|  Analysis Dashboard  |  atlas_dashboard_job@atlas_dashboard  |  |  |  |  Full database migration  |

---++ DDM Dashboard

*Account:* atlas_dashboard_dm@atlas_dashboard (ATLR)

%T% Plus atlas_dashboard_dm_writer, atlas_dashboard_dm_reader

#DdmTables
---+++ Tables

*Query Results* (3rd Nov 2009)

|  *Table Name*  |  *Size (GB)*  |  *Migration Needs*  |
|  OLD_T_SITE_DATA_STATS  |  .027  |  Data & Metadata  |
|  T_DATASET  |  .547  |  Data & Metadata  |
|  T_DATASET_FILE  |  3.95  |  Metadata Only  |
|  T_DATASET_LOCATION  |  1.625  |  Data & Metadata  |
|  T_DOMAIN  |  0  |  Data & Metadata  |
|  T_FILE  |  4  |  Metadata Only  |
|  T_FILE_LOCATION  |  26.688  |  Metadata Only  |
|  T_FILE_PLACEMENT  |  97.736  |  Metadata Only  |
|  T_SCHED_DOWNTIME  |  .002  |  Metadata Only  |
|  T_SCHEMA_VERSION  |  0  |  Data & Metadata  |
|  T_SERVICE_ERROR  |  .002  |  Metadata Only  |
|  T_SERVICE_METRICS  |  0  |  Metadata Only  |
|  T_SERVICE_STATUS  |  .027  |  Metadata Only  |
|  T_SITE  |  0  |  Data & Metadata  |
|  T_SITE_DATA_STATS  |  .07  |  Data & Metadata  |
|  T_SITE_SNAPSHOT  |  .006  |  Metadata Only  |
|  T_STATS_DATA_SITE_PAIR  |  .44  |  Data & Metadata  |
|  T_STATS_DATA_SITE_PAIR2  |  .211  |  Data & Metadata  |
|  T_STATS_DATA_SITE_SINGLE  |  .218  |  Data & Metadata  |
|  T_STATS_DATA_SITE_SINGLE2  |  .106  |  Data & Metadata  |
|  T_STATS_ERROR_SITE_PAIR  |  .271  |  Data & Metadata  |
|  T_STATS_ERROR_SITE_PAIR2  |  .928  |  Data & Metadata  |
|  T_STATS_ERROR_SITE_SINGLE  |  .002  |  Data & Metadata  |
|  T_STATS_ERROR_SITE_SINGLE2  |  .046  |  Data & Metadata  |

---+++ Big Indexes

*Query Results* (3rd Nov 2009)

|  *Index Name*  |  *Size (GB)*  |
|  FILE_PLACEMENT_PK  |  22.236  |
|  FILE_PLACEMENT_SITE  |  12.486  |
|  FP_CREATION_TIME  |  11.938  |
|  FP_MODIFIED_TIME  |  11.762  |
|  FILE_PLACEMENT_STATE  |  9.569  |
|  FL_SITE_MODIFIED_TIME  |  7.971  |
|  FILE_PLACEMENT_ACTIVITY  |  7.357  |
|  FILE_LOCATION_PK  |  6.875  |
|  FILE_LOCATION_UPDATE_TIME  |  6.463  |
|  FL_MODIFIED_TIME  |  6.067  |

---++ Prodsys Dashboard

*Account:* atlas_dashboard_prod@atlas_dashboard (ATLR)

%T% Plus atlas_dashboard_prod_w, atlas_dashboard_prod_r

---+++ Tables

|  *Table Name*  |  *Size (GB)*  |
|  CLUSTER_INFO  |  0  |
|  EJOBDEF  |  8.682  |
|  EJOBDEF_SUMMARY  |  28.578  |
|  EJOBEXE  |  13.459  |
|  EJOBEXE_SUMMARY  |  2.131  |
|  ETASK  |  .025  |
|  TABLE_COPY  |  0  |
|  TASKINPUTS  |  0  |
|  TASKOUTPUTS  |  0  |
|  T_SERVICE_STATUS  |  .164  |

---+++ Big Indexes

|  *Index Name*  |  *Size (GB)*  |
|  EJOBDEF_SUMMARY_UNIQ  |  40.04  |
|  EJOBEXE_ENDTIME  |  12.057  |
|  EJOBEXE_SUMMARY_UNIQ  |  3.125  |
|  EJOBDEF_TASK_CURRENTSTATUS_IDX  |  1.626  |
|  EJOBEXE_TASKFK  |  1.125  |
|  EJOBEXE_JOBDEFFK  |  1.125  |
|  EJOBEXE_UNIQUE_ID  |  1.069  |
|  EJOBDEF_UNIQUE_ID  |  .875  |
|  SERVICE_STATUS_PK  |  .18  |
|  EJOBEXE_ACTIVE  |  .019  |

---++ Analysis Dashboard

*Account:* atlas_dashboard_job@atlas_dashboard (ATLR)

%T% Plus atlas_dashboard_job_w, atlas_dashboard_job_r

---+++ Tables

---+++ Big Indexes

---++ Useful Queries

---+++ Individual Table Sizes

<verbatim>
SELECT '|  ' || segment_name || '  |  ' || size_gb || '  |'
FROM (
    SELECT segment_name, ROUND(SUM(bytes) / 1024.0 / 1024.0 / 1024.0, 3) size_gb
    FROM user_segments
    WHERE segment_type IN ('TABLE', 'TABLE PARTITION')
    GROUP BY segment_name
    ORDER BY segment_name ASC
);
</verbatim>

---+++ Big Indexes Sizes

<verbatim>
SELECT '|  ' || segment_name || '  |  ' || size_gb || '  |'
FROM (
    SELECT segment_name, ROUND(SUM(bytes) / 1024.0 / 1024.0 / 1024.0, 3) size_gb
    FROM user_segments
    WHERE segment_type IN ('INDEX', 'INDEX PARTITION')
    GROUP BY segment_name
    ORDER BY size_gb desc
)
WHERE rownum <= 10;
</verbatim>

---+++ Size of all tables

<verbatim>
SELECT ROUND(SUM(bytes) / 1024.0 / 1024.0 / 1024.0, 3) size_gb
FROM user_segments
WHERE segment_type IN ('TABLE', 'TABLE PARTITION');
</verbatim>

---+++ Size of all indexes

<verbatim>
SELECT ROUND(SUM(bytes) / 1024.0 / 1024.0 / 1024.0, 3) size_gb
FROM user_segments
WHERE segment_type IN ('INDEX', 'INDEX PARTITION');
</verbatim>

---+++ DB Size

<verbatim>
SELECT ROUND(SUM(bytes) / 1024.0 / 1024.0 / 1024.0, 3) size_gb
FROM user_segments;
</verbatim>
Topic revision: r3 - 2009-11-11 - RicardoRocha
ArdaGrid
ArdaGrid Web
ArdaGrid Web Home
Changes
Index
Search
Public webs
Welcome Guest
- Cern Search
- TWiki Search
- Google Search
ArdaGrid All webs
Copyright &© 2008-2023 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
or Ideas, requests, problems regarding TWiki? use Discourse or Send feedback