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 (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)

TIP Plus atlas_dashboard_dm_writer, atlas_dashboard_dm_reader

Tables

Query Results (3rd Nov 2009)

Table NameSorted ascending 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)

TIP 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)

TIP Plus atlas_dashboard_job_w, atlas_dashboard_job_r

Tables

Big Indexes

Useful Queries

Individual Table Sizes

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
);

Big Indexes Sizes

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;

Size of all tables

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

Size of all indexes

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

DB Size

SELECT ROUND(SUM(bytes) / 1024.0 / 1024.0 / 1024.0, 3) size_gb
FROM user_segments;
Edit | Attach | Watch | Print version | History: r3 < r2 < r1 | Backlinks | Raw View | WYSIWYG | More topic actions
Topic revision: r3 - 2009-11-11 - RicardoRocha
 
    • Cern Search Icon Cern Search
    • TWiki Search Icon TWiki Search
    • Google Search Icon Google Search

    ArdaGrid All webs login

This site is powered by the TWiki collaboration platform Powered by PerlCopyright & 2008-2022 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