RE: [development-axapta] Upgrade oracle database from 2.5 to 3.0 SP2 - Error

Wed, 14 Jan 2004 07:33:55 -0800

Title: Message

[Pieter] 
Try with -hint=0 as a axapta startup parameter, this will disable axapta generated hints, and might point to bad index hint usage
also check the "special first row fix for oracle" as the firstfast hint tends to use the "wrong index" & they never implemented firstonly hint anyway (uses firstfast)
else you might want to do a "analyze table ... list chained rows" to check for row migration
also make sure no storage options are set for your tables & indexes in axapta when using locally managed tablespaces
running Oracle Statspack can also help + using the advisories in Enterprise manager
There are "umpteen" different parameters that affect how Oracle performs
Other possibliities include how many you have & how you use your hard-disks.
 
In short contact a Oracle DBA to help you out ;-)
 
 
 -----Original Message-----
From: elianill [mailto:[EMAIL PROTECTED]
Sent: 14. januar 2004 15:18
To: [EMAIL PROTECTED]
Subject: Re: [development-axapta] Upgrade oracle database from 2.5 to 3.0 SP2 - Error

Hi,
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


Yahoo! Groups Links

Reply via email to