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
  • 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
  • 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

    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
  • 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

    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
  • 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
  • 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

    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
  • Powerful Essays

    Introduction to Oracle 9i: Sql Chapter 4-10
    • 1047 Words
    • 5 Pages

    Introduction to Oracle 9i: Sql Chapter 4-10

    Introduction to Oracle 9i: SQL Name: _______ Junel L Cofino Table of Contents Introduction: I-7 - Relational and Object Relational Database Management System I-10 - System Development Life Cycle I-12 - Relational Database Concept I-20 - Relational Database Properties I-24 - Tables used in the course Chapter 1: Writing Basic SELECT SQL Statements 1-4- Basic Select Statement 1-5- Selecting All Columns 1- 6- Selecting Specific Columns 1-7- Writing SQL Statements 1-8- Column Heading Defaults 1-9- Arithmetic Expressions 1-15- Null Values in Arithmetic Expressions 1-16- Defining A Column Alias 1-17- Using Column Alias 1-18- Concatenation Operator 1-19- Using Concatenation Operator 1-22- Duplicate Rows 1-23- Eliminating Duplicate Rows Chapter 2: Restricting and Sorting Data 2-4-Limiting the Rows Selected 2-5-Using WHERE Clause 2-6- Character Strings and Dates 2-7- Comparison Conditions 2-8- Using Comparison Conditions 2-9- Other Comparison Conditions 2-10- Using the BETWEEN Condition…

    • 1047 Words
    • 5 Pages
    Powerful Essays
    Read More
  • Powerful Essays

    Dba Check List
    • 2848 Words
    • 12 Pages

    Dba Check List

    This document gives details for performing daily, weekly, and monthly checks of the status of one or more Oracle databases. All SQL and PL/SQL code for the listed checks can be found in the appendix.…

    • 2848 Words
    • 12 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
  • Powerful Essays

    Sap for Atlam
    • 1692 Words
    • 7 Pages

    Sap for Atlam

    The conversation between Zulkifli and Sani, the Project Manager; Gopal, the User Project Manager; Lim, User Representative; and Kamal, the Functional Analyst has come to the several issues to be considered. Most of the issues arise are from Lim such as SAP is more suitable for manufacturing industry not education industry. Other issue is ATLAM is lack of equipment and facilities. According to Lim, the department does not have enough personal computers and if they have they do not have enough space available for the personal computer in their department.…

    • 1692 Words
    • 7 Pages
    Powerful Essays
    Read More

Related Topics