Preview

Biq Optimization

Powerful Essays
Open Document
Open Document
2205 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Biq Optimization
SAP Note 1431798 Oracle 11.2.0: Database Parameter Settings
Note Language: English Version: 47 Validity:
Valid Since 21.02.2012

Summary
Symptom
This note contains SAP's recommendations for the optimal configuration of Oracle Database Release 11.2. These parameter recommendations are relevant for all SAP products. This note will be updated regularly once a month. Beyond that, changes will only be made in exceptional cases for critical Oracle parameters. Change history: o February 14, 2012: o added _FIX_CONTROL '13077335:ON' for Unix for 11.2.0.3

January 11, 2012: added _FIX_CONTROL '13077335:ON' for Unix for 11.2.0.2

o

December 21, 2011: added parameter reccommendations for 11.2.0.3

o

December 13, 2011: updated reccommendation for parameter remote_os_authent

o

November 10, 2011: updated recommendation for parameter log_buffer (SAP note 1627481) updated recommendation for deprecated parameter remote_os_authent (SAP note 1622837)

-

o

October 27, 2011: add WIN 11.2.0.1 to _OPTIMIZER_USE_CBQT_STAR_TRANSFORMATION

o

October 26, 2011: updated STAR_TRANSFORMATION_ENABLED ( HotNews 1636936 ) added _OPTIMIZER_USE_CBQT_STAR_TRANSFORMATION (HotNews 1621425)

o

September 13, 2011: added _FIX_CONTROL '6055658:OFF' for Windows

o

July 13, 2011: updated setting for LOG_ARCHIVE_DEST_1 for ASM

06.03.2012

Page 1 of

11

SAP Note 1431798 Oracle 11.2.0: Database Parameter Settings o June 10, 2011: added parameter recommendations for Exadata and Grid Infrastructure

o o

May 18, 2011: modified description for _ENABLE_NUMA_SUPPORT May 12, 2011: Parameter recommendations adjusted for Windows 11.2.0.2 adjusted _FIRST_SPARE_PARAMETER for Unix 11.2.0.2 adjusted _FIX_CONTROL '4728348:OFF' for Windows 11.2.0.1 added _FIX_CONTROL '6055658:OFF' for UNIX added _MUTEX_WAIT_TIME and _MUTEX_WAIT_SCHEME for 11.2.0.2

o

April 12, 2011: added parameter _B_TREE_BITMAP_PLANS added event 10995

o

March 18, 2011: corrected the
Continue Reading
View Writing Issues

You May Also Find These Documents Helpful

  • Good Essays

    PT2520 Unit 1 Research Assignment
    • 452 Words
    • 2 Pages

    PT2520 Unit 1 Research Assignment

    Oracle Express is Oracle’s express edition of their SQL database. This edition has many different features that can be used. Some of those features include; Interactive reports, Declarative BLOB support, Enhanced report printing, adding to the theme repository, Optional runtime-only installation, improved security, Application date format, and Application builder refinements. These features are used to create…

    • 452 Words
    • 2 Pages
    Good Essays
    Read More
  • Satisfactory Essays

    Unit 1 Research Assignment 1
    • 327 Words
    • 2 Pages

    Unit 1 Research Assignment 1

    Limits: Poor Basic replication regarding integration, Oracle real application testing, Enterprise Manager, Automatic Storage Management, Java Support, Temporal Database,SQL Pattern matching, Flashback Data archive, Data Masking, Application Security, Secure Application roles, and Proxy Authentication.…

    • 327 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Good Essays

    The Truth Behind the Billion Dollar Story and Lessons for the Dod
    • 26520 Words
    • 107 Pages

    The Truth Behind the Billion Dollar Story and Lessons for the Dod

    Baum, David and others. “Oracle 25 Years of Technology Innovation.” Oracle Magazine, November/December, 2001, pp. 65-82.…

    • 26520 Words
    • 107 Pages
    Good Essays
    Read More
  • Powerful Essays

    Sherwin-Williams
    • 1443 Words
    • 6 Pages

    Sherwin-Williams

    The Oracle system was so adapted it to Versions were deployed for Asian and for the Americas. Once the main foundation of your system was laden place the enterprise data management portion of the Oracle suite was implemented in 2008 which focused on a more centralized and coordinated approach in the areas of production vendors and customer data. This allow the company greater control when he came to its second phase of distribution. Further enhancement and centralized data hub allow the company to focus on the five key business…

    • 1443 Words
    • 6 Pages
    Powerful Essays
    Read More
  • Better Essays

    Global Operations Management Ppq Parts Pros and Cons
    • 1381 Words
    • 6 Pages

    Global Operations Management Ppq Parts Pros and Cons

    Oracle is the world’s most complete, open, and integrated software for a business worldwide. Oracle has an astounding e-business package that gives the most all-inclusive, integrated business applications. The applications provided are the most adaptable in a business proposal; most of the customers place their focus on the strategy of the application which also has the most complete business portfolio. The business areas of the Oracle include:…

    • 1381 Words
    • 6 Pages
    Better Essays
    Read More
  • Good Essays

    Database Usage in the Workplace
    • 592 Words
    • 3 Pages

    Database Usage in the Workplace

    One of the most important elements of a computer based information system is the database. A database is a collection of records or information that is stored in a computer in a structured manner so that information can be stored, managed, and retrieved. Databases are very useful for manipulating large amounts of data and producing reports and documents. This paper takes a look at the Oracle database system and its usage within my organization.…

    • 592 Words
    • 3 Pages
    Good Essays
    Read More
  • Satisfactory Essays

    Strengths and Weaknesses of Existing DOS-Based POS Terminals Used by Zara
    • 306 Words
    • 2 Pages

    Strengths and Weaknesses of Existing DOS-Based POS Terminals Used by Zara

    Use Linux-based platform due to low cost of the OS itself and better connectivity to Oracle DB…

    • 306 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Better Essays

    Database Comparison of Sql Server 2000, Access, Mysql, Db2, and Oracle
    • 1180 Words
    • 5 Pages

    Database Comparison of Sql Server 2000, Access, Mysql, Db2, and Oracle

    References: Chigrik, Alexander, Oracle 9i Database vs DB2 v8.1 (n.d.), retrieved April 6, 2005, from http://www.mssqlcity.com/Articles/Compare/oracle_vs_db2.htm…

    • 1180 Words
    • 5 Pages
    Better Essays
    Read More
  • Powerful Essays

    Risk Management in Oracle Upgrade
    • 1915 Words
    • 8 Pages

    Risk Management in Oracle Upgrade

    The risk management process attempts to identify what could prevent or limit the upgrade of the existing oracle applications (11.5.9) and achieve the targeted functional and performance objectives within cost and schedule constraints. This is a very essential component of delivering the upgrade project, and any other project, to the altar of success. The competition among the software vendors drives them to deliver the new versions to their customers without thorough testing and fixing the loop holes in their product. In addition, every new version calls for stronger hardware requirement, more skilled and trained individuals, more clarity in the expectations from the software/upgrade, and faster implementation and/or upgrade – because the obsolescence of software takes place before the new version is released. Therefore, the planning of an upgrade process of any software needs to be planned very careful.…

    • 1915 Words
    • 8 Pages
    Powerful Essays
    Read More
  • Powerful Essays

    The Foxmeyer Drugs' Bankruptcy: Was It a Failure of Erp?
    • 2060 Words
    • 9 Pages

    The Foxmeyer Drugs' Bankruptcy: Was It a Failure of Erp?

    References: Cafasso, R. "Success strains SAP support", Computerworld, 28(36), September 5, 1994. Caldwell B. "Andersen Sued On R/3", InformationWeek, July 6, 1998. Computergram International "FoxMeyer Plus Two Sue Andersen for SAP Snafus", Computergram International, July 20, 1998.…

    • 2060 Words
    • 9 Pages
    Powerful Essays
    Read More
  • Better Essays

    SQL vs. Oracle
    • 954 Words
    • 3 Pages

    SQL vs. Oracle

    McLaughlin, Michael (2011). Oracle Database 11g & MySQL 5.6 Developer Handbook. New York: McGraw-Hill, 2011. Print.…

    • 954 Words
    • 3 Pages
    Better Essays
    Read More
  • Good Essays

    Ibm Db2 vs Oracle
    • 1231 Words
    • 5 Pages

    Ibm Db2 vs Oracle

    References: Chigrik, A. (2003). Oracle 9i Database vs DB2 v8.1. Retrieved May 11, 2005, from MSSQL City Web site: http://www.mssqlcity.com/Articles/Compare/oracle_vs_db2.htm#part_3.…

    • 1231 Words
    • 5 Pages
    Good Essays
    Read More
  • Powerful Essays

    A Comparison of Oracle and MySQL for Searchers of Ideal DBMS
    • 1593 Words
    • 7 Pages

    A Comparison of Oracle and MySQL for Searchers of Ideal DBMS

    This paper contains a comparison of Oracle and MySQL databases in the context of selection of a DBMS. First of all I determined what features of DBMS are important from the point of view of a customer which searches for ideal DBMS. From a papers which I read about comparison, I think the following features are important:…

    • 1593 Words
    • 7 Pages
    Powerful Essays
    Read More
  • Satisfactory Essays

    Oracle Configuration Manager
    • 895 Words
    • 10 Pages

    Oracle Configuration Manager

    | Incorrect. Refer to the Why Use The Configuration Manager In My Oracle Support training for more information.…

    • 895 Words
    • 10 Pages
    Satisfactory Essays
    Read More
  • Satisfactory Essays

    Apple: Dragon Age 2
    • 3034 Words
    • 13 Pages

    Apple: Dragon Age 2

    [Saturday Dec 01 21:00:54 2012] -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- [Saturday Dec 01 21:00:54 2012] Dragon Age 2 v1.00.0.27 installer ran [Saturday Dec 01 21:00:54 2012] -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- [Saturday Dec 01 21:00:54 2012] CallParameters=[] [Saturday Dec 01 21:00:54 2012] Setting up to re-run installer from temp directory [Saturday Dec 01 21:00:55 2012] -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- [Saturday Dec 01 21:00:55 2012] Dragon Age 2 installer re-running [Saturday Dec 01 21:00:55 2012] -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- [Saturday Dec 01 21:00:55 2012] -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-…

    • 3034 Words
    • 13 Pages
    Satisfactory Essays
    Read More

Related Topics