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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Growth pattern statistics collection after analyzing

Re: Growth pattern statistics collection after analyzing

From: rjamya <rjamya_at_gmail.com>
Date: Tue, 26 Jul 2005 10:03:36 -0400
Message-ID: <9177895d0507260703f939d93@mail.gmail.com>


After collecting stats, I export them to a user table. Then I can analyze a whole bunch of things like which segments allocate blocks at what frequency etc.

Raj

On 7/26/05, Johnson, George <GJohnson_at_gam.com> wrote:
>
>
> We are currently using the traditional analyze command for both
> tables and indexes once a week. I have the job of converting our shell
> script based analyze scripts to in DB pl\sql based mechanisms.
>
> On the subject of statistics collection, we currently seem to spend
> and inordinate amount of time collecting all sorts of obscure statistics
> about tables and indexes, I would like to simplify this to keep a more
> simple set of statistics, to determine our growth patterns. The dbms_stats
> package doesn't seem to support options like the use of the old
> index_stats
> table, so I was wondering what other people were doing in terms of stats
> collection for monitoring growth patterns, when using dbms_stats.
>
> Any thoughts you could share, would be most welcome
>
> Rgds
>
>
>
> ****************************************************************************
> This message contains confidential information and is intended only
> for the individual or entity named. If you are not the named addressee
> you should not disseminate, distribute or copy this e-mail.
> Please notify the sender immediately by e-mail if you have received
> this e-mail by mistake and delete this e-mail from your system.
> E-mail transmission cannot be guaranteed to be secure or error-free
> as information could be intercepted, corrupted, lost, destroyed, arrive
> late or incomplete, or contain viruses. The sender therefore does not
> accept liability for any errors or omissions in the contents of this
> message which arise as a result of e-mail transmission.
> If verification is required please request a hard-copy version.
> This message is provided for informational purposes and should not
> be construed as an invitation or offer to buy or sell any securities or
> related financial instruments.
> GAM operates in many jurisdictions and is
> regulated or licensed in those jurisdictions as required.
>
> ****************************************************************************
>
> --
> http://www.freelists.org/webpage/oracle-l
>

-- 
------------------------------
select standard_disclaimer from company_requirements where category = 
'MANDATORY';

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jul 26 2005 - 09:05:33 CDT

Original text of this message

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