SELECT *
FROM table(
DBMS_SPACE.OBJECT_GROWTH_TREND (
object_owner =>’SYS’,
object_name =>’SIZET’,
object_type =>’TABLE’,
start_time =>NULL,
end_time =>NULL,
interval =>to_dsinterval(‘180 00:00:00’) ,
skip_interpolated => ‘TRUE’,
timeout_seconds =>NULL,
single_datapoint_flag =>’TRUE’) )
order by 1
/
SQL> SELECT *
2 FROM
3 table(
4 DBMS_SPACE.OBJECT_GROWTH_TREND (
5 object_owner =>’BILLING’,
6 object_name =>’TBL_BACKUPSMTPFAX’,
7 object_type =>’TABLE’,
8 start_time =>NULL,
9 end_time =>NULL,
10 interval =>to_dsinterval(’10 00:00:00′) ,
11 skip_interpolated => ‘FALSE’,
12 timeout_seconds =>NULL,
13 single_datapoint_flag =>’TRUE’))
14 order by 1
15 /
TIMEPOINT SPAC
E_USAGE SPACE_ALLOC QUALITY
————————————————————————— —-
——- ———– ——————–
22-6月 -14 05.56.09.899000 下午 83
0497586 830497586 INTERPOLATED
02-7月 -14 05.56.09.899000 下午 83
0497586 830497586 INTERPOLATED
12-7月 -14 05.56.09.899000 下午 83
0497586 830497586 INTERPOLATED
22-7月 -14 05.56.09.899000 下午 83
0497586 830497586 INTERPOLATED
01-8月 -14 05.56.09.899000 下午 83
0497586 830497586 INTERPOLATED
11-8月 -14 05.56.09.899000 下午 83
0497586 830497586 INTERPOLATED
21-8月 -14 05.56.09.899000 下午 83
0497586 830497586 INTERPOLATED
31-8月 -14 05.56.09.899000 下午 83
0497586 830497586 INTERPOLATED
10-9月 -14 05.56.09.899000 下午 83
0497586 830497586 INTERPOLATED
20-9月 -14 05.56.09.899000 下午 83
0497586 830497586 INTERPOLATED
30-9月 -14 05.56.09.899000 下午 83
0497586 830497586 INTERPOLATED
10-10月-14 05.56.09.899000 下午 83
0497586 830497586 INTERPOLATED
20-10月-14 05.56.09.899000 下午 83
0497586 830497586 INTERPOLATED
30-10月-14 05.56.09.899000 下午 83
0497586 830497586 INTERPOLATED
09-11月-14 05.56.09.899000 下午 83
0497586 830497586 INTERPOLATED
19-11月-14 05.56.09.899000 下午 83
0497586 830497586 INTERPOLATED
29-11月-14 05.56.09.899000 下午 83
0497586 830497586 INTERPOLATED
09-12月-14 05.56.09.899000 下午 83
0497586 830497586 INTERPOLATED
19-12月-14 05.56.09.899000 下午 83
0497586 830497586 INTERPOLATED
29-12月-14 05.56.09.899000 下午 83
0497586 830497586 INTERPOLATED
08-1月 -15 05.56.09.899000 下午 83
0497586 830497586 INTERPOLATED
18-1月 -15 05.56.09.899000 下午 83
0497586 830497586 INTERPOLATED
28-1月 -15 05.56.09.899000 下午 83
0497586 830497586 INTERPOLATED
07-2月 -15 05.56.09.899000 下午 83
0497586 830497586 INTERPOLATED
17-2月 -15 05.56.09.899000 下午 83
0497586 830497586 INTERPOLATED
27-2月 -15 05.56.09.899000 下午 83
0497586 830497586 INTERPOLATED
09-3月 -15 05.56.09.899000 下午 83
0497586 830497586 INTERPOLATED
19-3月 -15 05.56.09.899000 下午 83
0497586 830497586 INTERPOLATED
29-3月 -15 05.56.09.899000 下午 83
0497586 830497586 INTERPOLATED
08-4月 -15 05.56.09.899000 下午 83
0497586 830497586 INTERPOLATED
18-4月 -15 05.56.09.899000 下午 644
7606206 6820659200 GOOD
28-4月 -15 05.56.09.899000 下午 648
1580653 6859524162 PROJECTED
08-5月 -15 05.56.09.899000 下午 651
5555100 6898389124 PROJECTED
18-5月 -15 05.56.09.899000 下午 654
9529548 6937254086 PROJECTED
28-5月 -15 05.56.09.899000 下午 658
3503995 6976119048 PROJECTED
07-6月 -15 05.56.09.899000 下午 661
7478442 7014984010 PROJECTED
已选择36行。
select ‘select ”’||num_rows||”’ num_rows,”’||OWNER||”’ owner,”’||TABLE_NAME||”’ table_name,’||’to_char(A.timepoint,”YYYY-MM”) ,A.space_usage/1024/1024,A.space_alloc/1024/1024,A.quality from TABLE(dbms_space.object_growth_trend(”’||OWNER||”’, ”’||TABLE_NAME||””||’, ”TABLE”,interval =>to_dsinterval(”100 00:00:00”) )) A;’ from dba_tables where owner=’BILLING’ order by num_rows desc;