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