Re: help

Daniel - I use Oracle 8i (version...8.17)

 Each month, at the start of end of month processing we analayze all our main tables:

 analyze table XXX compute statistincs;

Youi said....

Analyze table, analyze schema etc are there for backward compatibility and
> should not be used.

So we should use the dbms_stats package instead? If so, when I go and tell my Boss this Monday morning....he will ask me what benifts will he see if we change.

[Quoted]  What can I tell him?

 Thanks

"DA Morgan" <damorgan_at_exesolutions.com> wrote in message news:3E4457AD.3001B29E_at_exesolutions.com...
> Alden Huen wrote:
>
> > How do you give a user the ability to use sql loader and to analyze
tables?
> >
> > thanks
>
> To use SQL*Loader you must give them access to the bin directory at
ORACLE_HOME
> on the server. Something that should never be done. Consider alternatives.
>
> To analyze a table requires knowing what version you have which, to quote
so
> many, of course wasn't posted. Since you didn't volunteer the information
I
> will assume 8i or 9i in which case you should use the built-in DBMS_STATS
> package.
>
> Information on this package can be found at http://tahiti.oracle.com
>
> Analyze table, analyze schema etc are there for backward compatibility and
> should not be used.
>
> Daniel Morgan
>
Received on Sun Feb 09 2003 - 13:41:37 CET