Sizing Exadata - Oracle Exadata Recipes: A Problem-Solution Approach - page 125

(ts.BLOCKSIZE * u.tablespace_usedsize) / 1024 / 1024 / 1024
tablespace_usedsize,
(RANK () OVER (PARTITION BY t.tsname ORDER BY s.snap_id ASC)
) latest,
s.end_interval_time endtime
FROM dba_hist_snapshot s,
v$instance i, v$database d,
dba_hist_tablespace_stat t,
dba_hist_tbspc_space_usage u,
SYS.ts$ ts
WHERE s.snap_id = t.snap_id
AND s.dbid=d.dbid and s.dbid=t.dbid and s.dbid=u.dbid
AND i.instance_number = s.instance_number
AND s.instance_number = t.instance_number
AND ts.ts# = t.ts#
AND t.snap_id = u.snap_id
AND t.ts# = u.tablespace_id)
WHERE latest = 1) tsmin,
(SELECT *
FROM (SELECT TRUNC (s.begin_interval_time) snaptime,
t.tsname,
(ts.BLOCKSIZE * u.tablespace_size) / 1024 / 1024/ 1024
tablespace_size,
(ts.BLOCKSIZE * u.tablespace_usedsize) / 1024 / 1024 / 1024
tablespace_usedsize,
(RANK () OVER (PARTITION BY t.tsname ORDER BY s.snap_id DESC)
) latest,
s.end_interval_time endtime
FROM dba_hist_snapshot s,
v$instance i, v$database d,
dba_hist_tablespace_stat t,
dba_hist_tbspc_space_usage u,
SYS.ts$ ts
WHERE s.snap_id = t.snap_id
AND s.dbid=d.dbid and s.dbid=t.dbid and s.dbid=u.dbid
AND i.instance_number = s.instance_number
AND s.instance_number = t.instance_number
AND t.snap_id = u.snap_id
AND ts.ts# = t.ts#
AND t.ts# = u.tablespace_id)
WHERE latest = 1) tsmax
WHERE tsmin.tsname = tsmax.tsname and tsmax.snaptime > tsmin.snaptime)
/
Curr Growth Rate 1-year 2-year 3-year 5-year
Alloc (GB) GB/day Size (GB) Size (GB) Size (GB) Size (GB)
----------- ----------- ----------- ----------- ----------- -----------
303.84 .96 561.34 911.73 1262.11 1962.88