Databases

Migration Summary

Query Results (3rd Nov 2009)

Dashboard	Account	Tables Size (GB)	Indexes Size (GB)	Total Size (GB)	Expected migration
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	atlas_dashboard_dm@atlas_dashboard	136.903	140.839	277.742	Table dependent (see here)

DDM Dashboard

Account: atlas_dashboard_dm@atlas_dashboard (ATLR)

Plus atlas_dashboard_dm_writer, atlas_dashboard_dm_reader

Tables

Query Results (3rd Nov 2009)

Big Indexes

Query Results (3rd Nov 2009)

Prodsys Dashboard

Account: atlas_dashboard_prod@atlas_dashboard (ATLR)

Plus atlas_dashboard_prod_w, atlas_dashboard_prod_r

Tables

Big Indexes

Analysis Dashboard

Account: atlas_dashboard_job@atlas_dashboard (ATLR)

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;