Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

SAP, oracle 8162 and analyze table

Carlos Fernandez Riera
Honored Contributor

SAP, oracle 8162 and analyze table


We have upgrade our SAP to 8.1.6.2 64 bit.

After few days analyze table validate structure cascade left a CPU in 100% usr mode.

Glance shows wait for PRI and 32000 call to gettimeofday in 3 minutes.

Has anybody suffer something like this?

NOTE: Today is the joke's day in Spain, but i am still sitting lookinkg for any solution.


Thanks in advance.



unsupported
5 REPLIES
Carlos Fernandez Riera
Honored Contributor

Re: SAP, oracle 8162 and analyze table

There is a bug on 8.1.6.2 when seting:

max_dump_file_size = unlimited

avoid this and set to:

max_dump_file_size = 1024k

( 10 points for me).;-)
unsupported
Dan Hetzel
Honored Contributor

Re: SAP, oracle 8162 and analyze table

Hi,

Was that today's spanish joke ??

:-))

Dan
Everybody knows at least one thing worth sharing -- mailto:dan.hetzel@wildcroft.com
Carlos Fernandez Riera
Honored Contributor

Re: SAP, oracle 8162 and analyze table

HI Dan:

I think yours is 1st of April.

The joke was... Work until 21:30 h for me, for my peers to 05:00 AM.

Good Joke.
unsupported
Dan Hetzel
Honored Contributor

Re: SAP, oracle 8162 and analyze table

Hi Carlos,

You're right, our joke's day is on 1st of april.

You're still lucky because this happened on 28th of december, instead of 31st.
I sincerely hope that you'll be able to enjoy New Year's eve without pager or mobile phone.

All the best

Dan

PS: well done for the bug discovery ! Don't assign points when people don't deserve them. ;-)
Cheers


Everybody knows at least one thing worth sharing -- mailto:dan.hetzel@wildcroft.com
Carlos Fernandez Riera
Honored Contributor

Re: SAP, oracle 8162 and analyze table

Dan:
3 point is : Thank you. Your response did not help to resolve my problem, but thanks.

Enjoy New Year's eve without pager or mobile phone.
unsupported