Descriptions Oracle SAP Administration Free Ebook
Tailored to the needs of people who know Oracle, SAP R/3, or a little of both, Oracle SAP Administration explains the conventions and utilities that integrate these software tools before getting into optimisation techniques and strategies for achieving increased data safety. Appropriately, author Donald Burleson emphasises optimisation of disk-access operations. He relates two methods for identifying I/O hotspots--specifically, he shows how to examine the Oracle file statistics and how to use Unix's iostat utility to get a picture of what's going on. He then describes strategies for restructuring tablespaces to minimise hold-ups. He also discusses RAID implementations, with an eye towards their performance penalties as well as the increased level of reliability they provide.
Beyond file system considerations, Oracle SAP Administration describes how to reorganise tables, tablespaces and indexes to bring about top performance. You will find explicit listings of SQL statements and Korn shell scripts that restructure databases, and a wealth of diagrams that illustrate how inefficient databases differ from optimised ones (a concept that is not always easy to communicate with text). The author tackles Oracle's parallel-processing solutions and explains how they (particularly the ones that came before Oracle8) interact with SAP. A quick discussion of how very large Oracle/SAP databases behave rounds out this coverage of a robust enterprise duo. --David Wall, Amazon.com
Topics covered: Naming conventions, SAPDBA, SAPGUI, optimising file access, reorganising Oracle objects for better performance, administration tasks and utilities, and Oracle Parallel Server (OPS) as it applies to SAP. Burleson uses SAP R/3 and Oracle versions 7 and 8 in his documentation., Second Grade Reading Books .
CLICK HERE TO DOWNLOAD THIS BOOK FOR FREE