Total number of records for all tables under current user
- 2020-06-15 10:24:56
- OfStack
Analyze the total number of records for all tables under the current user
It's guaranteed to work!
It's guaranteed to work!
begin
dbms_utility.analyze_schema(user,'COMPUTE');
end;
select t.table_name,t.num_rows,t.blocks,t.empty_blocks from user_tables t