Database Growth Report
- From: Sanjay Mishra <smishra_97@xxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 8 Nov 2013 12:11:43 -0800 (PST)
Hi Everyone
Creating a report for Database growth using AWR and need some SQL expert advice
to create report in tabular format. What I need is
Hourly ---> Sanpshot time Hourly like 01:00 02:00 03:00.......
Downward or can say Vertically is the list of tablespace like
USER
SYSTEM
SYSAUX
ABC
....
I had created the following query which need to be refined using some function
or query reformatting or if there is any more effecient way to query the same
results
SELECT b.name, to_char(c.end_interval_time,'dd-mm hh:mi'),
sum(round((a.tablespace_usedsize*8192)/1024/1024))
FROM dba_hist_tbspc_space_usage a,
v$tablespace b,
dba_hist_snapshot c
WHERE b.ts#=a.tablespace_id
AND a.snap_id=c.snap_id
group by b.name,to_char(c.end_interval_time,'dd-mm hh:mi')
ORDER BY 1
/
TIA
Sanjay
Other related posts:
- » Database Growth Report - Sanjay Mishra
