Oracle数据库查询所有表以及数据量_oracle查询所有表的数据量

数据库查看所有表以及表的数据量：
这个不准：

select u.TABLE_NAME,u.NUM_ROWS 
	from user_tables u 
	order by u.NUM_ROWS desc;
1
2
3

创建函数查询（准确的）：

create or replace function count_rows(table_name in varchar2,owner in varchar2 	default null)
	return number authid current_user IS
		num_rows number;
		stmt varchar2(2000);
	begin
		if owner is null then
			stmt := 'select count(*) from "' || table_name || '"';
		else
			stmt := 'select count(*) from "' || owner || '"."' || table_name || '"';
		end if;
			execute immediate stmt
			into num_rows;
	return num_rows;
	end;
select table_name,count_rows(table_name) nrows
	from user_tables
	order by nrows asc
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17