Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Dynamically update statistic for an db instance
Geir -
I do it this way by owner via dbms_utility :
exec dbms_utility.analyze_schema('SCOTT','compute'); SELECT table_name, num_rows, blocks, empty_blocks, avg_space,
chain_cnt, avg_row_len
FROM dba_tables
WHERE owner = 'SCOTT';
Thanks in advance!
Geir Warhaug Received on Thu Mar 19 1998 - 00:00:00 CST