Wednesday, November 3, 2010

Oracle Infogram This Week: Hyperion, MySQL, Search Filter, SQL Injection, Data Modelling, Time


Hyperion

Timeouts don't always happen on the server side. Here's a posting over at In 2 Hyperion on the browser factor: Why Does Workspace Log You Out?

MySQL

Some tips on MySQL at Net tuts+: Top 20+ MySQL Best Practices

OBIEE 11g

Over at Ritmann Mead Consulting, one of the best blogs out there, is: A Quick Recap on “The Best of” our OBIEE 11g Postings, so that's the best of the best. Definitely worth a look.

Search Filter

I've read and enjoyed the work of various members of Miracle, a company based in Denmark, for years. The legendary Oak Table is owned by its founder (the Oak Table is somewhat like the Round Table. Only it's not round. And has nothing to do with chivalry. And is all about Oracle performance experts. And has a lot more beer stains on it.). So when I stumbled across this search engine from Miracle Finland I thought I'd pass it along: Miracle Finland search engine.

SQL Injection

You've heard me speak (well, preach, more like) about the need for continued vigilance to eliminate SQL injection vulnerabilities. Here is a good cheat sheet I came upon about SQL injection. There are links to other vulnerability references at the bottom of the posting:

Data Modelling

Speaking of thorough lists, this is the most comprehensive list of data modelling tools I've seen: Data Modelling Tools over at Database Answers

Time Marches On

And everything gets old. That includes software. Please have a look a the dates for the RDBMS and plan accordingly:

Please see details in MOS Note : Release Schedule of Current Database Releases [ID 742060.1]

The patching end dates for the different release/patch levels are as follows unless noted otherwise in the table:

Release

Patching Ends

11.2.0.1

13-Sep-2011

11.1.0.6

18-Sep-2009

10.2.0.4

30-APR-2011

10.2.0.3

22-Feb-2009

10.1.0.4

30-Jan-2007


Click here to view the dates. Note that although 10.2 Extended Support begins in August 2010, Extended Support fees have been waived for the first year for all customers - for more information see the Oracle Technical Support Policy document section 6 (d).

Notes:

  • 111.1.0.7 is the last patch set for Release 11.1. Future integrated error correction will come in the form of Patch Set Updates. Please see Patch Set Updates for Oracle Products (Doc ID 854428.1) for current details.
  • 211.2.0.1 is a base release.
  • 310.2.0.5 is the last patch set for Release 10.2. Once patching ends for 10.2.0.4, future integrated error correction will come in the form of Patch Set Updates. Please see Patch Set Updates for Oracle Products (Doc ID 854428.1) for current details.
    • The start of Extended Support no longer forces customers to run the last patch set in order to receive new fixes (such as PSU or CPU) - 10.2.0.4 will be patched up until the end date listed above.

No comments:

Official, Youbetcha Legalese

This blog is provided for information purposes only and the contents hereof are subject to change without notice. This blog contains links to articles, sites, blogs, that are created by entities other than Oracle. These links may contain advice, information, and opinion that is incorrect or untested. This blog, links, and other materials contained or referenced in this blog are not warranted to be error-free, nor are they subject to any other warranties or conditions, whether expressed orally or implied in law, including implied warranties and conditions of merchantability or fitness for a particular purpose. We specifically disclaim any liability with respect to this blog, links and other materials contained or referenced in this blog, and no contractual obligations are formed either directly or indirectly by this blog, link or other materials. This blog may not be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose, without our prior written permission. The opinions and recommendations contained in this blog(including links) do not represent the position of Oracle Corporation.

Oracle, JD Edwards, PeopleSoft, and Siebel are registered trademarks of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.