Do you already use 11g?

[Former Member]

Just out of curiosity:

1.) do you already have SAP systems running on 11g?

2.) until when are you planning to completely move to 11g?

3.) which new 11g functions do you already use?

4.) personal experience/impression with 11g so far?

Hoping to get as many replies as possible...

Cheers Michael

PS: here are my answers:

1.) not yet, but next week we will have a test system running

2.) roughly be the end of 2011

3.) i will certainly checkout adv. compression, partitioning, deferred segment creation

4.) none

[former_member204746 · Accepted solution]

1.) 2 sandbox system were updated, they work well so far.

2.) spring 2011

3.) I am not looking too much to begin with. I will upgrade first and check these new options afterward

4.) works fine so far, but only on sandbox systems will little activity.

[Former Member · Accepted solution]

1.) sadndbox,dev and IST systems are upgraded to 11g

2.) end of this year

3.) tbl/index compression , RMAN compression , secure files

4.) so far so good. however the systems we upgraded are kind of small and less activity.

will let you know more after our QA upgrade . We had some issues with new SAPCTL

though.

[Former Member]

Hi,

1. so far only one productive SAP BW system

2. July 2011, just like most people I guess

3. SecureFiles, Advanced Compression, Transparent Data Encryption

4. a) 11g is running stable

b) it seems that for my average BW query the DB time is reduced by ~20% on 11g, but so far I only have relatively few performance data available

c) defered segment creation is nice to have, but doesn't make a big difference

d) implementing Advanced Compression via brspace is tedious, buggy and slow, I believe R3load will be the way to go (available in mid November I hope)

Regards,

Mark

[Former Member]

Thanks you all.

I hope SAP releases the patchset 11.2.0.2 soon. and also the 11g dvd's for new installions.

Cheers Michael

[fidel_vales]

>

> I hope SAP releases the patchset 11.2.0.2 soon. and also the 11g dvd's for new installions.

It seems that will be release next month.

This month there is "kind of" release, see notes 1431799 and 1503709

[Former Member]

1.) do you already have SAP systems running on 11g?

Yes: Solution Manager 7.1, and our Dev and Quality ECC 6.0 EhP4 systems.

2.) until when are you planning to completely move to 11g?

Production will be upgraded before the end of October 2010.

3.) which new 11g functions do you already use?

Table compression feature enabled on Solution Manager, and on a couple of ECC 6.0 sandboxes.

4.) personal experience/impression with 11g so far?

We saved a lot of storage, Iu2019ll implement that feature in all the other SAP/Oracle 11g systems very soon.

Regards,

Federico Biavati

[stefan_koehler]

Hello Michael,

1.) do you already have SAP systems running on 11g?

Yes - most of them (when the kernel release is allowed with 11g R2). Only our logistic landscape with 3 databases is still on 10g R2.

2.) until when are you planning to completely move to 11g?

Already done. The logistic system will be done in next year, because of its complex system landscape (including data guard, etc.) and testing effort.

3.) which new 11g functions do you already use?

Advanced compression, RMAN enhancements - unfortunately most of the funny stuff (like ACS, etc.) is not supported by SAP until yet.

4.) personal experience/impression with 11g so far?

Great stuff )

Regards

Stefan

[audunlea_hansen]

1.) do you already have SAP systems running on 11g?

Yes, upgraded a SolMan system earlier this week. By the way, I'm also running 11gR2 on non-SAP databases, including 2 RAC clusters with 9 databases.

2.) until when are you planning to completely move to 11g?

Latest nov 2010 (in approx 2 months)

3.) which new 11g functions do you already use?

None of them that are new in 11g in SAP db's yet. But there are many good new things in 11gR2 for DBA's.

- Key sensitive passwords are one of the big security reasons

- Flashback are nice when developers do wrong things.

- rman cloning block recover are much better.

- Better audit by default

4.) personal experience/impression with 11g so far?

Only good. Seems like exec plans are bether generated, and statistics are better. Bether memory management too.

Regards

Audun

[Former Member]

Hi,

If you go through the Note 1431800 - Oracle 11.2.0: Central Technical Note, should clear your all questions.

Cheers,

-Sunil