Database Growth Report
From: Sanjay Mishra <smishra_97_at_yahoo.com>
Date: Fri, 8 Nov 2013 12:11:43 -0800 (PST)
Message-ID: <1383941503.29802.YahooMailNeo_at_web122101.mail.ne1.yahoo.com>
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
Date: Fri, 8 Nov 2013 12:11:43 -0800 (PST)
Message-ID: <1383941503.29802.YahooMailNeo_at_web122101.mail.ne1.yahoo.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Nov 08 2013 - 21:11:43 CET