SAP, oracle 8162 and analyze table

[Carlos Fernandez Riera]

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.

[Carlos Fernandez Riera]

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).;-)

[Dan Hetzel]

Hi,

Was that today's spanish joke ??

:-))

Dan

[Carlos Fernandez Riera]

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.

[Dan Hetzel]

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

[Carlos Fernandez Riera]

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.