Newsletter-18_ aktuell - Oracle

76 Pages·2009·1.99 MB·English

Oracle SAP
® r ®
o
f
T E C H N O L O G Y U P D A T E
g
11
N E W
D A T A B A S E
Oracle Index Compression for SAP Customers
No.18 Oracle for SAP, May 2009
www.oracle.com/sap
Oracle database for SAP
is safe, reliable and scalable
– the Grid enabled platform
11g
DATABASE
C O N T E N T S
3 Editorial
4 Oracle 11goutlook and10gsupported features for SAP
10 Manageability of VLDB, Oracle Index Comression
24 Oracle 10gRAC for SAP at NSW Fire Brigades
26 Oracle 10gRAC for SAP at Kuwait Oil, Q8
28 Oracle RAC for SAP at National Gas Company of Trinidad and Tobago
31 Certified SAP on RAC Configurations for Windows and Linux
32 Oracle 10gRAC for SAP at Gottwald Port Technology GmbH
36 Oracle 10gRAC for SAP at German Telekom, “Computerwoche”
38 Oracle 10gRAC for SAP at Indian Express
42 Oracle 10gRAC for SAP at ASE Taiwan
46 Oracle 10gRAC for SAP at Diehl Informatik
48 Oracle Index Key Compression at Bauerfeind
52 Oracle Table Compression at CAPCOM, Japan
56 SGI and SAP on Oracle database at MTU
60 Oracle 10gfor SAP at Chevron
64 All4IT France, SAP on Oracle database Consulting
65 Delta Consulting
66 IOUG SAP Special Interest Group (SAP SIG)
67 SAP Press: SAP Database administration with Oracle
68 Advanced Customer Services for SAP customers
73 IS4IT, SAP on RAC Implementation Partner
74 Useful links Oracle database for SAP customers
76 Imprint
Oracle Database for SAP – The #1 Database safe, reliable, scalable, optimized for SAP customers 3
D E A R S A P C U S T O M E R ,
Oracle Corporation and SAP AG have an ongoing commitment to our joint customers and have long-standing
reseller and customer support agreements in place, which provide enhanced access to Oracle database
technology and improved customer support.
For 20 years Oracle has been the safe, reliable, and scalable database of choice for SAP customers.
The Oracle database is constantly optimized for SAP applications and around the world more than two
thirds of all mid-size to high-end SAP customers in every industry, entrust their application deployments
to Oracle databases. Customers are running SAP applications with Oracle databases on all major
operating systems.
In this edition, we focus on the most important technologies that uniquely benefit SAP on Oracle database
customers. Only the Oracle database provides SAP customers the following advantages:
Best Performance & Scalability, Superior Locking & Concurrency, Real Application Clusters (RAC)
Oracle has world record SAP SD benchmark results, with exceptional scaling across SMP and Cluster environments.
Multi-version Read Consistency means that readers don’t block writers and writers don’t block readers, a key component for the highest
possible database performance. Oracle Real Application Clusters (RAC) provides a flexible way to achieve near linear scalability of SAP
applications. Now with RAC, customers have a choice to either scale up or scale out the database server layer. Since all RAC nodes are
active, it helps SAP customers to meet the demands of production workload requirements. Widely adopted by customers, Oracle RAC is
theonly generally available clustered database solution certified for all SAP products.
Best Deployment Flexibility
Widest range of supported platforms; Unix – Linux – Windows – “Oracle is Oracle is Oracle”. The same code base across all operating
systems means, Oracle has the same features, tools and functionality on all hardware platforms and operating systems, so our customers
can choose the most cost effective platform for their implementations. Should customers require a change in operating systems, Oracle
offers fast and efficient Oracle-to-Oracle (O2O) migration services. An automatic “Fast Start” install of Oracle database technology for
SAP Business All-in-One is currently implemented with Hewlett Packard for all major platforms.
Best Availability & Reliability, Real Application Clusters (RAC), Data Guard (DG)
RAC for SAP removes the database server as a single point of failure and delivers enhanced performance & scalability adopted across
platforms by many customers in various industries. Oracle Data Guard (DG) complements Oracle RAC and Flashback technologies as the
preferred disaster recovery solution it’s used by SAP customers around the world. Together RAC and Data Guard ensure your SAP data
will be safe from hardware failures and data center disasters.
Best Support for Very Large Databases
The Oracle database is well known for providing the most efficient use of disk space. This is extremely important to SAP customers as the
size of their databases continue to grow dramatically. Unicode is now required by new SAP products and Unicode migrations require a
complete unload and load of data. Oracle optimizations result in the fastest SAP Unicode Migrations, with up to 1 terabyte/hour data transfer
rates and it’s fully integrated in SAP products. Even the largest multi terabyte databases have been migrated in one weekend.SAP customers
using Oracle databases also take advantage of Index Key Compression to save disk space at no additional costs. Huge and increasing
amounts of data continue to stress system performance, Oracle offers a rich collection of partitioning strategies to reduce I/O and improve
performance. Hewlett Packard Oracle Exadata Storage Server deployment under SAP will be evaluated after the official shipment of Oracle
11gRelease 2 by SAP.
Best Database Security
Compliance and security are more important now than ever before. Oracle’s Advanced Security Transparent Data Encryption (TDE) makes
encryption of sensitive data simple by transparently encrypting data when it is written to disk. Oracle database Vault helps customers
meet regulatory compliance requirements by enforcing separation of duties (please see Edition 17).
Best Database Manageability & Self-Management for SAP
SAP DBA Cockpit, SAP BR*Tools for Oracle uses the Oracle Automatic Workload Repository (AWR). AWR automatically stores workload
and performance statistics so administrators and support engineers can analyze and quickly resolve performance issues, whether the
root cause happened hours or days before.
In this edition, you will learn more about these features and selected customer success stories. Please see also more about the Oracle
Advanced Customer Services (ACS) for SAP customers, including: database migrations, performance tuning, health check and internal
training work shops. For more information or to see current and previouseditions go to:www.oracle.com/sap. We welcome your com-
ments and questions, please contact us at: [email protected]
Sincerely
Gerhard Kuppler
Senior Director Corporate SAP Account,
Oracle Corporation
4
O U T L O O K O R A C L E D ATA B A S E 1 1 g
F O R S A P C U S T O M E R S
Oracle database Release 11gis currently being tested • OLTP Table Compression
by SAP. As part of the Advanced Compressed Option table,
As with previous certifications, SAP will certify Oracle data may be compressed reducing disk space and
database 11gRelease 2 with their products. There are improving query performance. In combination
features of Oracle 11gwhich will greatly benefit SAP with index key compression and Secure File com-
customers. Below you find a list of features which are pression every type of data in the Oracle database
currently planned by SAP to be used once 11ggets can be stored in a compressed way.
certified by SAP or shortly thereafter:
• Secure File Compression
• Secure Files
In addition to relational table data, unstructured
Secure Files implement a new architecture for
data may also be compressed in the Oracle database.
storing unstructured data and will replace the LOB
Secure File compression is part of the Advanced
datatypes of previous database versions. Secure Files
Compression Option. Oracle 11gis the only
deliver improved performance and scalability over
database which is able to compress every type of
LOBs and offers reduplicaton functionality to save
data used by SAP named tables, indexes and
disk space.
unstructured data stored in Secure Files.
• Optimizer Enhancements and Statistics Maintenance
• Online Patching
The 11gOptimizer provides performance enhance-
This unique and patented technology of Oracle
ments for complex SAP BI queries and better
allows single and bundle patches to be applied
recognizes value changes in R/3 sql statements.
while the database is running reducing downtimes
Statistics maintenance especially for partitioned
dramatically. Online Patching is available for
objects is improved and calculation of statistics
Single Instance and RAC installations, even with
is more accurate and faster compared to previous
shared Oracle Homes required by SAP.
database versions.
• Dictionary Only Add Column
• Automatic Interval Partitioning
Within the SAP application new columns may have
Maintenance of partitioned objects is now fully
to be added. Prior to 11g, an add column activity
automatic as the database server will manage parti-
would rquire significant and time intensive update
tions on the fly.
statements to be generated for each row of the table.
With Oracle 11gthis is not the case anymore.
The data for the new column is only populated if
the row is accessed by the application. So any add
column from the SAP application will be executed
within seconds and not minutes or hours that are
required prior to Oracle 11g.
Oracle 11goutlook and10gsupported features for SAP 5
g
11
• No Segment Allocation for empty Objects
Before Oracle 11gan initial extent was always allo-
D A T A B A S E
cated for each object (index, table, partition) even
if the object did not contain any data. With Oracle
11gan extent is allocated if data is being inserted
into the object. Empty objects will not have any
extent allocated. This is very beneficial for a SAP
installation as many objects are empty after the
installation. This feature will make the SAP instal-
lation faster and reduce substantially the initial
disk space requirements.
• Direct NFS
Oracle 11gincludes functionality to directly mount
NFS filesystems from certified NAS systems into
the database kernel. Through this optimization
the traditional overhead of NFS clients is avoided
delivering better throughput of the Oracle database
on certified NAS systems.
• Tablespace Encryption
Included within the Advanced Security Option is
the technology to encrypt all data in a tablespace.
Especially for SAP systems it is now very easy to
encrypt sensitive data.
6
U P D AT E O N O R A C L E D ATA B A S E F U N C T I O N A L I T Y W I T H
S A P P R O D U C T S
g
10
DATABASE INTRODUCTION Calculation of a start and end point for the WHERE
clause of each table portion is very expensive as you
Oracle database 10gis the first database designed for
need to scan either the whole table or to scan a com-
Enterprise Grid Computing to lower hardware costs
pleteindex. The R3load export using the WHERE
by leveraging low cost components and by greatly
clausewith column values again is very expensive
increasing resource utilization levels, therefore com-
as you need to access both index and table data.
plementing the Advanced Computing Infrastructure
The unique rowid splitting technology of Oracle
concept of SAP. Oracle database 10gRelease 2 is avai-
avoids any index access and generates rowid ranges
lableto SAP customers and it is being adopted rapidly
so that data can be physically read from disk. Rowid
by SAP customers. Oracle 10gRAC is general available
splitting provides two important advantages. First,
as of January 2009 on all platforms for SAP versions
ranges can be calculated in a few seconds by using
4.6C moving forward.
the physical structure information of the table stored
in the Oracle Data Dictionary compared to minutes
The following provides a list of important features
or hours using WHERE clauses on columns. Second,
available to SAP customers today.
the actual R3load export is dramatically faster as it
reads data in physical order from disk and not using
Multiple Oracle Patch (MOPatch) Utility an index. Customer experiences show that R3load
exportsusing rowid ranges are between 10-20 times
The Maintenance of single patches for databases on
faster using less CPU, memory and IO resources.
Unix and Linux platforms can be a time-consuming
A Unicode migration using rowid splitting has
and complex job when dealing with many SAP
achived export and import rates up to data per hour.
installations. Also the experience from many support
calls especially in the area of database performance
shows that many databases are not always at a recom- Index Key Compression
mended patch level. To help database administrators This feature allows B*Tree Indexes to be stored more
in these areas a new patch utility MOPatch was deve- efficiently on disk and in main memory reducing
loped to guarentee that an Oracle database for the disk space and improving query performance. Up to
SAP application always uses the most current set of 70% of space for indexes can be saved on disk and
patchescertified by SAP. SAP note 1027012 provi- query performance may improve by up to 30%.
des more details on how to use MOPatch. SAP Note 1109743 provides more details on how the
indexcompression feature should be used in SAP
environments.
ROWID Splitting
An SAP Unicode Migration requires a complete export
and import of the whole database through R3load. Instant Client
Typically the time for doing an export or import is Instant Client allows you to run your applications
dominated by a few single large tables like RFBLG, without installing the standard Oracle client or
COEP or GLPCA as these table are substantially having an ORACLE_HOME. OCI-based applications
bigger than any other table in the database. To reduce like SAP work without modification, while using
the export and import times is possible to break significantly less disk space than before.
these tables into smaller portions and have one With the release of new SAP kernels 4.6D_EX2 and
R3load job work per table portion.Without ROWID 6.40_EX2 the Instant Client is now available to all
splitting is very time consuming and resource inten- SAP versions starting from 4.6C on. Please refer to
sive tocalculate the ranges for each portion. SAP Notes 1086956 and 1058988 for more details.
Oracle 11goutlook and10gsupported features for SAP 7
Advanced Security Network Encryption ChCaOngNeC-LAUwSaIrOeN Incremental Backup
Oracle Advanced Security Network Encryption pro- ByO ursaicnlge 1a 0ngewD attyapbea soef plorogv fiidlee st oth ter ancekc ebslsoacrky si nthfraat-
vides an easy-to-deploy and comprehensive solution hasvter uchctaunrgee fdo ri nm tahkei ndgat athbea sSeA, RPM laAndNs caavpoei dms osrcea nrnesinpgon-
for protecting bidirectional communication to and thesi veen ttior et hdea tcahfailneg dinugri nbgu sainne isns cernevmireonntmale bnat.c kOurpa.cle 10g
from the Oracledatabase using both standards based InsDteaatdab, atshee gaimveosu ynotu o tf hdea tflae xscibanilniteyd yios up rnoepeodr ttioo nimalple-
network encryption, and robust native encryption/- to mtheen ta mEnoutenrtp roifs ed aGtar icdh Canogmepdu.ting, even using low
integrity algorithms. cost servers and disks. The design of Enterprise Grid
Network Encryption between ABAP and Java FlaCshobmapcku tDinatga bcoasmeplements the Adaptive Computing
Application Servers and the Oracle database is ThIen fFrlaassthrubcatcukr eD caotnabceapset sf eoaft uSAreP p. rOovraidclees 1a0 wgaDy attoabase
available for all SAP products based on NW2004s. qupicrkovlyid reesv ethrte tbheen eenfitti roef Olorwacelrei ndga traibskass ew tiot ht hleo wstearte
it mwaasn iang eaatb ai lpitayst c poostins,t ginre taitmere .s cAallsaob ipliotsys iabnled b prrinedgicta-
Advanced Security Transparent Data Encryption a sbinilgitlye taanbdl et hbea chki gihne tsitm leev. eSlAs oPf Navoatiela 1b1il2it5y9.23
(TDE) provides more detail on the usage of this feature in
Makes encryption of sensitive data simple by trans- SAP environments.
parently encrypting data when it is written to disk.
Data Pump Export and Import Utilities
Rename Tablespace The Data Pump Export and Import utilities provide
You can now rename a tablespace. You no longer very high-speed bulk movement of data and meta-
have to create a new tablespace, copy the contents data from one database to another. These utilities offer
from the old tablespace, and drop the old tablespace. several significant advantages over the original Export
This feature makes it easier, for example, to convert a and Import utilities, including: The ability to com-
dictionary-managed tablespace to a locally managed pletely restart export and import jobs; the ability to
tablespace, or to add a tablespace to a database that detach from and reattach to long-running jobs; the
already contains a tablespace with the same name, ability to estimate how much space an export job
an operation being used in a MCOD environment. would consume; support for export and import ope-
rations over the network; and support for fine-grained
Online Segment Shrink object selection, based upon objects and objects types.
This feature shrinks segments of tables and indexes This feature will initially not be integrated within
online and in-place that have free space, thereby the SAP administration tools.
enhancing efficiency of space utilization. The new Data Pump Export and Import utilities can
each be run in parallel, resulting in better performance
in loading and unloading data and metadata.
End-to-End Application Tracing
The feature simplifies the debugging of performance
Cross-Platform Transportable Tablespaces
problems in multi-tier environments. It will only be
available for new versions of the SAP software and The transportable tablespace feature now enables
not for existing versions. tablespaces to be transported across different plat-
forms, therefore, making a platform migration for
a SAP customer much faster.
Online LONG to LOB Migration
In this release tables with LONG and LONG RAW
Full Database Begin Backup Command
data, still used by many SAP applications, can now
It is no longer necessary to issue a separate command
be migrated online to LOB data from within the
to place each tablespace in hot backup mode. You can
BR*SPACE utility of SAP.
now use the ALTER DATABASE statement to place
all tablespaces in backup mode. Also, the BEGIN
Automatic Optimizer Statistics Collection
BACKUP command now runs faster than before.
This feature automates the collection of optimizer
statistics for objects. Objects with stale or no statistics
are automatically analyzed, so administrators no longer
need to keep track of what does and what does not
need to be analyzed, nor to perform analysis manually.
8
N E W F U N C T I O N A L I T Y O R A C L E 1 0 g R E A L
W I T H S A P B I 7 . 0 A P P L I C AT I O N C L U S T E R S
g
10
( R A C )
SAP BW users will benefit most from the new
features described in this section. These features are Oracle Real Application Clusters (RAC) allows Oracle
DATABASE immediately available to all SAP BI customers. Database to run any packaged or custom application,
unchanged across a set of clustered servers. This
Faster Drop and Truncate Table provides the highest levels of availability and the
most flexible scalability. To keep costs low, even the
These two operations perform substantially faster by
highest end systems can be built out of standardized,
using improved algorithms in accessing the database
commodity parts. Oracle 10gRAC provides a foun-
buffer cache. In particular small tables, often used by
dation for Oracle’s Enterprise Grid Computing
SAP BW, benefit the most.
Architecture.
Oracle RAC technology enables a low-cost hardware
IN MEMORY UNDO
platform to deliver the highest quality of service that
Block changes by short transactions are now managed
rivals and exceeds the levels of availability and scala-
better by the database server resulting in less CPU
bility achieved by the most expensive, mainframe
cycles.
SMP computers. Oracle 10gRAC is available on all
platforms for SAP versions 4.6C and subsequent
Improved Scalability for Partitioned Objects
versions.
Dropping partitioned tables and indexes is now
substantially faster by using a new algorithm for
Integrated Clusterware
identifying the blocks of a partitioned object in the
Oracle 10g RAC offers a complete clusterware manage-
buffer cache and for cleaning these blocks in the
mentsolution as an integral component of Oracle
buffer cache. The SAP BW application benefits the
10g RAC available on all platforms Oracle 10g
most, as dropping partitioned objects is a frequently
Database runs on. This clusterware functionality
used operation in SAP BW.
includes mechanisms for cluster connectivity, messa-
Tests performed using a query on a table with 1,000
ging and locking, cluster control and recovery, and a
partitions show that Oracle 10g’s new strategy of
services provisioning framework. No 3rd party clu-
sharing partitioning metadata results in less SQL
sterware management software need to be purchased.
memory usage in the SGA (9.2.0.6: 52KB, 10.2:
Oracle will, however, continue to support select 3rd
11KB – this means that every single query on this
party clusterware products on specified platforms.
table will use 5 times less memory).
With Oracle 10gDatabase Release 2, Oracle provides
a High Availability API so that non-Oracle processes
ODM Connector 2.1
can be put under the control of the high availability
Oracle Data Mining Connector 2.1 leverages all framework within Oracle Clusterware.
advanced Data Mining algorithms from Oracle data-
base 10gData Mining Option. Oracle Data Mining
Connector 2.1 is fully integrated with the Analysis
Process Designer providing a secure, scalable and
indatabase analytics engine for both BW 3.5 and
BI 7.0 customers.
Oracle 11goutlook and10gsupported features for SAP 9
SAPCTL Data Guard Integration for Disaster Recovery
Oracle Clusterware does provide high availability With Oracle 10gEnterprise Manager, the manage-
for SAP resources just as it does for Oracle resources. ment component of Oracle Data Guard, Data Guard
Oracle has created an Oracle Clusterware tool, SAP Broker, is now completely integrated with RAC.
Control (SAPCTL), to enable you to easily manage Data Guard disaster recovery environments involving
SAP high availability resources. SAPCTL provides Oracle RAC databases can now be as easily managed
an easy-to-use interface to administer the resources, as those employing single instance databases.
scripts, and dependencies of Oracle Clusterware
and SAP high availability components. SAPCTL
consolidates the functionality of the Oracle command- F E AT U R E S T O B E
line tools by enabling you to easily manage the SAP R E L E A S E D S O O N B Y S A P
Enqueue Service for ABAP and JAVA, the SAP
Replication Service for ABAP and JAVA, and the Database Vault
additional virtual IP addresses used by the SAP Database Vault provides strong internal controls for
Enqueue Service for ABAP and/or JAVA. In Addition regulatory compliance and protection against insider
the message server and the dialog instance are covered threats. By implementing Database Vault a DBA is
by SAPCTL. no longer able to view user data.
With the introduction of SAPCTL, no 3rd party Database Vault will be available to all SAP customers
software is needed to manage and control the critical in the second half of 2009 with 10.2.0.4 running
SAP services, from 6.40 based systems of SAP and 700 kernel based applications of SAP such as ECC
upwards (as of today, available only for Linux and 6.0 or BI 7.0.
AIX).
CONCLUSION
Additional Support for EMC Celerra NFS Servers
Oracle database 10g provides the necessary infrastruc-
In addition to the already SAP certified NetApp ture for making the SAP landscape more responsive
NFS servers for SAP/RAC deployments on Linux to the changing business environment. Oracle data-
platforms now SAP customers can use EMC NAS base 10ggives you the flexibility needed to implement
Celerra systems using NFS. Enterprise Grid Computing, even using low cost
servers and disks. The design of Enterprise Grid
Single System Image Management Computing complements the Adaptive Computing
Oracle 10gEnterprise Manager has been significantly Infrastructure concepts of SAP. Oracle database 10g
enhanced to enable true single system image manage- provides the benefit of lowering risks with lower
ment of cluster database deployments. Enterprise manageability costs, greater scalability and predicta-
Manager’s Cluster Database Page provides a single bility and the highest levels of availability.
view of system status across multiple nodes. It also
enables direct drill down to individual instances
when needed.
A new cluster configuration verification tool and
improvements in the diagnostic tools first introduced
in the Oracle9idatabase release help users both
avoid problems and resolve problems more quickly
should they occur.
10
M A N A G E A B I L I T Y O F V E RY L A R G E D ATA B A S E S
– Oracle Index Compression, SAP Partioning Engine, Backup Technologies
INTRODUCTION The second problem is a special one: the possible threat
of large amounts of data was more or less neglected
Not too long ago, a phrase that could be heard and
by many designers of ERP systems, so the “beasts”
read frequently went like this: Only the top 10
tend to behave nastier in these environments.In other
databases worldwide have a size of one Terabyte or
words: The monsters became real, and the nightmares
more. True, a few scientists published papers in
of database administrators became true.
journals such as the Proceedings of the International
Conference on Very Large Databases (VLDB), and every
Or did they?
now and then an article about Taming the Beasts
appeared in the Internet, but almost nobody had
GENERAL CONSIDERATIONS
ever seen giants and monsters in real life, so all this
was supposed to be only a fairy tale.
Reasons for Database Growth
Today, the world is full of giants and monsters. In the Why do databases grow that much and that fast?
SAP world, a one Terabyte (1 TB) database is almost The question seems to be trivial. Everybody is familiar
considered low end, with high-end customers currently with the main reasons:
managing 20 to 50 TB databases, and some of them
• More and more detailed information is stored in
expecting to reach the 100 TB range in the very near
OLTP systems. Retailers literally follow every
future.
single bottle of beer, transportation companies
trace the way of every single parcel. Web-based
Recent developments also quashed the firm conviction
commercerequires that all details of a transaction
that Decision Support (DSS) databases are always
are stored in the database.
considerably larger than OLTP databases. The silent
assumption was that in the unlikely event of one of
•Another reason of database growth is consolidation.
your databases becoming a very large one, it would
Previously independent, local or departmental sys-
necessarily – and could only – be the DSS database.
tems are consolidated in order to create a global
And the obvious conclusion seemed to be that only
system as one single source of truth. Many companies
designers of DSS systems needed to worry about
also acquire other companies and need to consolidate
technologies that can help handle large amountsof
old and new systems.
data, whereas for OLTP systems there is no problem
at all.
•Regulatory requirements force companies to keep
historical data in the database for many months or
Today, customers in many industries (e. g. Retail,
even years.
Utilities) find that the database size of their SAP ERP
systems is equal to or even greater than the database
• Customers need to store more and more unstructured
size of their SAP BI systems. And they also find that
data such as emails or PDF files.
their ERP systems are not as well prepared for hand-
ling large amounts of data as their BI systems. Nevertheless, it is important to ask the question
“Why is my database growing that much?”, because
All this means that many SAP customers today face in most cases the answer already implies a hint at
two closely related problems. The first problem is a possible solutions. If, e. g., it turns out that the
general one: databases are growing faster than ever amount of historical data is the main reason,
before and there is an urgent need for technologies database administrators should look for strategies
and tools that help customers “taming the beasts.” about how to minimize the impact of historical data