Daily Roundup of News, Tips and Tricks for 2010-02-02

Tweet

• Book: Expert Oracle Practices: Oracle Database Administration from the Oak Table
  This book is an anthology of effective database management techniques representing the collective wisdom of the OakTable Network. With an emphasis upon performance—but also branching into security, national language, and other issues—the book helps you deliver the most value for your company’s investment in Oracle Database technologies. You’ll learn to effectively plan for and monitor performance, to troubleshoot systematically when things go wrong, and to manage your database rather than letting it manage you.
• Lessons from ERP Software Implementation Failures
  Five trends we see in most troubled enterprise software implementations: Lack of software fit, unrealistic implementation expectations, lack of executive buy-in and support, propensity to customize software rather than leverage standard functionality and lack of ERP software implementation expertise.
• Setback for SAP in Oracle suit
  Oracle has won a battle regarding the way damages can be calculated in its intellectual property lawsuit against SAP, according to a ruling filed January 28 in US District Court for the Northern District of California.
• How can a session be killed within a RAC cluster without causing automatic failover to second instance?
  Use the resource manager. With that you can either set up a proactive rule or use a resource plan that limits the amount of resources they can use.
• Oracle ADF Faces Cheat Sheets
  These cheat sheets will help you get started using ADF Faces rich client components. The cheat sheets are grouped by component type and/or functionality, and work together with the Web User Interface Developer's Guide for ADF and the ADF Faces Tag Library documentation and ADF Faces demo application.
• Can I use the Function Result Cache with an application built on Oracle VPD?
  You certainly can use Function Result Cache to optimize retrieval of data from tables on which you have specified access control through Oracle VPD. You will, however, likely need to change the parameter list of your function to ensure that the correct data is always returned by Function Result Cache.
• Send HTML data with the POST method from APEX
  Example of how to send data from your APEX application to an external website (like PHP) through the POST method.
• If you are allowed to keep only one book on Oracle – Which book will it be?
  Hmm!
• Oracle’s SQL Performance Analyzer White Paper
  The SQL Performance Analyzer offers a comprehensive solution to enable users to forecast and analyze how a system change will impact SQL query plans and run time performance, so they can tune their system before they make the change in production. The SQL Performance Analyzer identifies potential problems that may occur and makes suggestions for avoiding any SQL performance degradation. It provides quantitative estimates of the system’s performance in the new environment with high confidence and performs a comparative analysis of the response time of the SQL workload thus allowing for an easy assessment of the change. In this paper we describe the architecture of the SQL Performance Analyzer, its usage model, and its integration points with other Oracle database components to form an end-to-end change management solution.

Related articles:

• Daily Roundup of News, Tips and Tricks for 2010-02-04
• Daily Roundup of News, Tips and Tricks for 2010-02-06
• Daily Roundup of News, Tips and Tricks for 2010-02-09