thank you for all your hints.
I reindexed database. Afterwards statistic for Oracle was
recalculated using the class mentioned.
But I�ve still a problem with the performance - do you have any idea
how to solve?
BTW - when starting statistic job again without reindexing database
before I get the same error message as in the dataupgradejob - do
you have any further hints for me?
Many thanks.
With best regards,
Elia
--- In [EMAIL PROTECTED], "Torgeir Toms"
<[EMAIL PROTECTED]> wrote:
> reindexing and statistics is two different things. Reindexing will
NOT
> update the statistics info. You must run this or your system will
go
> veery veery slllllllllllloooooooooowwww.
>
>
> Med vennlig hilsen
> Torgeir Toms
> Systemkonsulent Teknisk IT
>
> ==================================
> Good Judgment Comes From Experience. Experiences Comes From Bad
> Judgment.
> =====================================
>
> -----Opprinnelig melding-----
> Fra: elianill [mailto:[EMAIL PROTECTED]
> Sendt: 2. januar 2004 18:04
> Til: [EMAIL PROTECTED]
> Emne: Re: SV: SV: [development-axapta] Upgrade oracle database
from 2.5
> to 3.0 SP2 - Error
>
>
> Hi,
> thank you for all your hints! Reindexing of database using SQL-
> Administrator succeded. Oracle-Administration was not necessary
> anymore.
> Thank you!
> Best regards,
> Elia
>
> --- In [EMAIL PROTECTED], "Torgeir Toms"
> <[EMAIL PROTECTED]> wrote:
> > Hi
> > There is a job in axapta 3.0 who collects statistics for Axapta.
> You
> > find it under administrator/setup/Oracle-Setup/statistics - Run
it
> form
> > there with compute.
> > if this does not work - i will help you doing it directly in
> oracle
> >
> > Statistics are info about datadistribution for the optimizer in
> Oracle -
> > It tells Oracle how to fetch data in the most effician way.
Which
> index
> > to use etc....
> >
> >
> > Med vennlig hilsen
> > Torgeir Toms
> > Systemkonsulent Teknisk IT/OracleDBA
> >
> > ==================================
> > Good Judgment Comes From Experience. Experiences Comes From Bad
> > Judgment.
> > =====================================
> >
> > -----Opprinnelig melding-----
> > Fra: elianill [mailto:[EMAIL PROTECTED]
> > Sendt: 2. januar 2004 16:55
> > Til: [EMAIL PROTECTED]
> > Emne: Re: SV: [development-axapta] Upgrade oracle database from
> 2.5 to
> > 3.0 SP2 - Error
> >
> >
> > Hi!
> > Thank you for answering! I am using 9204 - but I am new to
oracle.
> > Can you explain me a bit in detail how to go on?
> > Should I do this all using SQL*Plus with sysdba? Do I have it
> during
> > upgradejob of Axapta or before?
> > Thanks for all hints.
> > Best regards,
> > Elia
> > --- In [EMAIL PROTECTED], "Torgeir Toms"
> > <[EMAIL PROTECTED]> wrote:
> > > What oracle version are you on?
> > > If 9202 there is a bug regarding DBMS_STATS using "Estimate
> > statistics"
> > >
> > > if it is just the statistics who fails, use DBMS_Stats to
first
> > delete
> > > and then recreate the statistics on your tables using "compute
> > > statistics" and cascade=True and generate histogramms for your
> > columns
> > >
> > > Med vennlig hilsen
> > > Torgeir Toms
> > > Systemkonsulent Teknisk IT/Oracle DBA
> > >
> >
>
_____________________________________________________________________
> > ___
> > > ____________________________
> > > ==================================
> > > Good Judgment Comes From Experience. Experiences Comes From Bad
> > > Judgment.
> > > =====================================
> > >
> > > -----Opprinnelig melding-----
> > > Fra: elianill [mailto:[EMAIL PROTECTED]
> > > Sendt: 2. januar 2004 16:06
> > > Til: [EMAIL PROTECTED]
> > > Emne: [development-axapta] Upgrade oracle database from 2.5 to
> 3.0
> > SP2 -
> > > Error
> > >
> > >
> > > Hallo,
> > >
> > > when upgrading oracle database from 2.5 to 3.0 SP2 dataupdate-
> > > job "updateOracleStatistics" is always terminated with
following
> > > error-message:
> > >
> > > SQL-error: ORA-00904: invalid columne name
> > > ORA-06512: in "SYS.DBMS_STATS", row 9375
> > > ORA-06512: in "SYS.DBMS_STATS", row 9857
> > > ORA-06512: in "SYS.DBMS_STATS", row 10041
> > > ORA-06512: in "SYS.DBMS_STATS", row 10095
> > > ORA-06512: in "SYS.DBMS_STATS", row 10072
> > > ORA-06512: in "BMSSA.AXAPTA", row 8
> > > ORA-06512: in row 1
> > >
> > > How to go on? Any help appreciated!
> > > Thank you in advance!
> > > Best regards,
> > > Elia
> > >
> > >
> > >
> > >
> > >
> > >
> > > Yahoo! Groups Sponsor
> > > ADVERTISEMENT
> > >
> > >
> > >
> > >
> > >
> > >
> > > Yahoo! Groups Links
> > >
> > > To visit your group on the web, go to:
> > > http://groups.yahoo.com/group/development-axapta/
> > >
> > > To unsubscribe from this group, send an email to:
> > > [EMAIL PROTECTED]
> > >
> > > Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> > Service.
> >
> >
> >
> >
> > Yahoo! Groups Links
> >
> > To visit your group on the web, go to:
> > http://groups.yahoo.com/group/development-axapta/
> >
> > To unsubscribe from this group, send an email to:
> > [EMAIL PROTECTED]
> >
> > Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service.
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
>
>
>
>
>
>
> Yahoo! Groups Links
>
> To visit your group on the web, go to:
> http://groups.yahoo.com/group/development-axapta/
>
> To unsubscribe from this group, send an email to:
> [EMAIL PROTECTED]
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
