Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Dynamically update statistic for an db instance

Re: Dynamically update statistic for an db instance

From: <Jim.Pickett_at_cubic.com>
Date: 1998/03/19
Message-ID: <Forum.890328609.6505.Pickett@ferret.corp.cubic.com>#1/1

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';



In Article Dynamically update statistic for an db instance , Geir Warhaug <Geir.Warhaug_at_alcatel.no> wrote: Does somebody have a script that updates the statistic (ANALYZE) for every table in the db instance? I need a bourne shell script...

Thanks in advance!

Geir Warhaug   Received on Thu Mar 19 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US