6.7

2 Determine the core table size by running the following script.
SELECT ROUND(SUM(s.bytes)/(1024*1024)) SIZE_MB
FROM user_segments s
WHERE (s.segment_name,s.segment_type)
IN (SELECT seg_name, seg_type FROM
(SELECT t.table_name seg_name, t.table_name tname,
'TABLE' seg_type
FROM user_tables t
UNION
SELECT i.index_name, i.table_name,
'INDEX'
FROM user_indexes i
) ti
WHERE (ti.tname LIKE 'VPX_%'
OR ti.tname LIKE 'CL_%'
OR ti.tname LIKE 'VDC_%')
AND ti.tname NOT LIKE 'VPX_SAMPLE_TIME%'
AND ti.tname NOT LIKE 'VPX_HIST_STAT%'
AND ti.tname NOT LIKE 'VPX_TOPN%'
AND ti.tname NOT LIKE 'VPX_SDRS_STATS_VM%'
AND ti.tname NOT LIKE 'VPX_SDRS_STATS_DATASTORE%'
AND ti.tname NOT LIKE 'VPX_TASK%'
AND ti.tname NOT LIKE 'VPX_EVENT%'
AND ti.tname NOT LIKE 'VPX_PROPERTY_BULLETIN%');
The script returns the database storage size in MB.
3 Determine the events and tasks table size by running the following script.
SELECT ROUND(SUM(s.bytes)/(1024*1024)) SIZE_MB
FROM user_segments s
WHERE (s.segment_name,s.segment_type)
IN (SELECT seg_name, seg_type FROM
(SELECT t.table_name seg_name, t.table_name tname,
'TABLE' seg_type
FROM user_tables t
UNION
SELECT i.index_name, i.table_name,
'INDEX'
FROM user_indexes i
) ti
WHERE
ti.tname LIKE 'VPX_TASK%'
OR ti.tname LIKE 'VPX_EVENT%');
The script returns the events and tasks storage size in MB.
4 Determine the statistics table size by running the following script.
SELECT ROUND(SUM(s.bytes)/(1024*1024)) SIZE_MB
FROM user_segments s
WHERE (s.segment_name,s.segment_type)
IN (SELECT seg_name, seg_type FROM
vCenter Server Upgrade
VMware, Inc. 151