Database » August 11, 2008

Feeds

14827 items (1495 unread) in 26 feeds

Database (1495 unread)

• DBA's notes (111 unread)
• $Pete Finnigan's Oracle security weblog (56 unread)
• Ask Tom MOST RECENT ARTICLES (350 unread)
• Databases News (83 unread)
• DBAzine.com - Oracle Articles Archive (4 unread)
• Eddie Awad's Blog (31 unread)
• FeuerThoughts (36 unread)
• Mark Rittman's Oracle Weblog
• MR. ED's blog (1 unread)
• MySQL Performance Blog (133 unread)
• Niall's Oracle Pages (17 unread)
• OraBlogs
• Oracle + Open Source
• Oracle HTML DB Studio Recent Additions (20 unread)
• Oracle Security Alerts (2 unread)
• Oracle Software Downloads (62 unread)
• Oracle Technology News (34 unread)
• Oracle's OTN TechCasts (21 unread)
• Orawin.Info
• OTN TechBlog (72 unread)
• OTN/DBA
• Published Security Alerts
• The Dizwell Blog
• The Tom Kyte Blog (18 unread)
• TheServerSide.com (444 unread)
• Upcoming Security Alerts

(4 unread)

• August 12, 2008
• 0:22

  Oracle WebLogic Server 10g Rel 3: Good for the Goose

   » ‎ OTN TechBlog

  Despite the fact it has been available for download from OTN since last week, Oracle WebLogic Server 10g Rel 3 (10.3) was officially announced in a social PR today. (Download link and other supporting info here; there is also a very complete description in this post at the Oracle Developer Tools Blog.)

  Released by BEA in tech preview in November 2007, 10.3 is the first "Oracle-compliant, feature-bearing" release - meaning: it now functions as official JDeveloper/ADF/TopLink runtime, and it has lots of new stuff in it. Workshop for WebLogic is still in there for all platforms and it's now free, to boot.

  If you're a former BEA customer, you've probably been waiting for this for a while. If you're a longstanding Oracle one; well, this is your chance to get your feet wet with what is now Oracle's strategic Java platform.

  I feel compelled to add that despite what you may have read elsewhere, the WLS install is fairly lightweight (154MB) when the a-la-carte approach is taken. Or, you can choose to download the entire entree (WLS, drivers, plugins, JDKs, samples) at about 735MB.

• August 11, 2008
• 21:33

  Wonderfull World of MySQL Storage Engines slides are now published

   » ‎ MySQL Performance Blog

  I should be faster with publishing slides but things are how they are. The slides from my OSCON2008 talk are now published at Percona Presentation Pages.
  Enjoy

  Entry posted by peter | 4 comments

  Add to: | | | |

• 20:39

  Oracle removes licensing for Workshop Eclipse plug-ins

   » ‎ TheServerSide.com
  Oracle is also delivering the Eclipse tools for Oracle WebLogic Server 10gR3 with a simpler packaging (just one, with all features), and a new price (free!). This release of Workshop for WebLogic 10g R3 combines all the features of the other products.

  

  

• 11:51

  Effective Testing

   » ‎ Niall's Oracle Pages

  I've been following a number of threads on forums.oracle.com recently - the quality of discussion seems to have improved markedly there since I gave up on it in 2001. Anyway there was a thread about interpreting the AWR report that Oracle provides (at extra cost) and which is very smilar to the Statspack report. The report in question comes from a siebel system and there were some interesting snippets of information from Joe Coffey about the specifics of working with SIEBEL which would likely trap the unwary (like me) when using sqlplus to investigate an application performance problem. The specifics are in this post but are that siebel specifically alters the standard oracle environment on login with 4 ALTER SESSION statements - namely

  • alter session set optimizer_mode = first_rows_10;
  • alter session set hash_join_enabled = false;
  • alter session set "_optimizer_sortmerge_join_enabled" = false;=
  • alter session set "_optimizer_join_sel_sanity_check" = true;

  Now first_rows_10 is rather sensible for a reporting application where the end user is going to look at pages of results - I'm rather less convinced about the wisdom of avoiding hash_joins and sortmerge joins altogether, but the base point to remember here - for myself as much as any reader - is that when conducting tests using sqlplus (or toad or any other query environment ) it matters that you ensure that your session mimics effectively the one the users will be using.