Search

OakieTags

Who's online

There are currently 0 users and 32 guests online.

Recent comments

Affiliations

Oakies Blog Aggregator

Book Review: Oracle PL/SQL Performance Tuning Tips & Techniques

“Oracle PL/SQL Performance Tuning Tips & Techniques” by Michael Rosenblum and Dr. Paul Dorsey is a book you should read soon. A quote from Oracle’s Bryn Llwellyn in the book’s forward says it all “Every professional PL/SQL programmer should study this book and act upon its teachings.”
Misha and Paul take the scientific route to performance, providing readers the how-and-why of effective performance. The first chapter sets the tone showing how performance is an aggregate typically of nine-steps from execution of code on the client side, through middleware, to server, and back again to the client. Learn how PL/SQL works from two of the best whose shared stories of actual issues underline the importance of performance planning and thinking.
Oracle database professionals rely upon PL/SQL to accomplish many important tasks. This book presents numerous opportunities to improve PL/SQL performance offering more than just code suggestions. Perhaps most importantly, each unit steps the reader through how to test and prove if an actual improvement has been made. Code examples include explanations of how to test results so that you know the impact of your actions. For each topic highlighted, the authors provide discussions of the tradeoffs being made; for instance, did CPU improve at the expense of I/O or vice-versa? Performance-related Oracle tools and instrumentation are explained and demonstrated clearly to illustrate and confirm results.
You can read this book straight through as I did, or, pick a specific topic like caching and skip around. However you choose to read this book you’re sure to learn lots about PL/SQL performance and how you can improve your systems.

Windows 7 error “key not valid for use in specified state”

When you see that error upon trying to install or upgrade something on your Windows 7 64-bit machine, chances are that it is caused by a Windows Security update that you need to uninstall. There is probably no point in messing around with the registry or the application that you want to upgrade. Instead, remove the Windows update KB2918614 like this:

Open the control panel, then click  Windows Update

Windows 7 control panelClick Update History and then Installed Updates:

Update HistoryScroll down to Microsoft Windows and look for KB2918614 (I have removed it already before I took the screenshot):

Uninstall KB2918614Finally, hide that update so you don’t get it installed later on again:

Hide KB2918614I’m using a corporate notebook with automatic Windows security updates coming from time to time and encountered that problem while trying to upgrade VirtualBox to version 4.3.12. It is not a VirtualBox issue, though, other installs or upgrades may fail for the same reason. For me, this was a serious problem, because I rely on virtual machines for many demonstrations. Kudos to the virtualbox.org forums! They helped me resolve that problem within a day. Thank you once again, guys! :-)

Tagged: #KB2918614

SLOB Failing To Generate AWR Reports? Red Hat Bug 919793!

This is a quick blog post to help folks that are testing with SLOB at high user (session) counts. The situation may arise where you are testing SLOB on a large configuration, with or without SQL*Net, and the SLOB driver (runit.sh) is failing to produce Automatic Workload Repository (a.k.a AWR) reports.

This problem will generally be seen on RHEL 6 variants that implement the much maligned /etc/security/limits.d/90-nproc.conf method of preventing fork bombs. For more information on this configuration file please refer to Red Hat bug 919793.

If you are not getting AWR reports under the condition I describe then the problem is most likely due to 90-nproc.conf short circuiting the ulimit(3) tuning you’ve established.

As an example remedy, please consider the following settings I recommended to my colleagues at VCE for performance testing of the vBlock Specialized System for High Performance Databases:

SS-HPDB-fork-bomb

 

 

Filed under: oracle

XtremIO @ Tech Field Day 2014

kevinclosson:

As scientists, interested in what’s happening in platform technology, readers of my blog will find my colleague Itzik Reich’s recent blog on EMC XtremIO to be very informative. Enjoy!

Originally posted on Itzikr's Blog:

image

Hi,

during the week of VMworld 2014, we had the pleasure of presenting in front of the audience of the tech field day delegates.

attached below are the links to the session Josh Goldstein delivered, enjoy!

EMC XtremIO Introduction

EMC XtremIO Architecture – Consistent and Predictable Performance

EMC XtremIO Data Services

View original

Filed under: oracle

Coloring Page Sections in Squarespace

A useful technique in web design is the use of distinctive background
colors to provide visual separation between sections in a page. Squarespace
customers can implement the technique using...



Read the full post at www.gennick.com/database.

Coloring Page Sections in Squarespace

A useful technique in web design is the use of distinctive background
colors to provide visual separation between sections in a page. Squarespace
customers can implement the technique using...



Read the full post at www.gennick.com/database.

Webinar Followup (Aug. 27): In Search of Plan Stability - Part 1

Thanks to everyone who attended my August 27th webinar entitled In Search of Plan Stability - Part 1. You can download the presentation materials from these links:

Presentation PDF
Scripts
Q&A

I'll update this post to provide a link to the recording shortly.

Come back in November for Part 2. Hope to see you then!

Thanks!

The 7 Deadly Sins of Cloud Computing

As if anyone needs to be reminded, there’s a ridiculous amount of hype surrounding clouds and big data. There’s always oodles of hype around any new technology that is not well understood—I believe the correct term for this is product marketing. There are at least seven deadly sins that can be committed when determining a […]

The Big Data Job Gap: Where are the Platform Scientists?

Big data continues to live up to its reputation for disruption as it gnaws away at all of the entrenched constituencies – IT silos, vendors, pricing models and now, careers; it’s about to get very personal. On the possibility side, there is a massive skills gap that needs to be filled. Everybody knows there aren't […]

7 Ways Data Virtualization Helps CIOs

IDC study found that Delphix

  1. Pays for itself in 4.3 months
  2. ROI 461% over 5 years
  3. $1 Million storage and hardware savings
  4. $50 Millionannual  savings for companies over 75,000 employees
  5. $78,500 saved per year per 85 employees
  6. $85,000 annua lIT efficiency per 100 employees
  7. 98.6% storage reduction on a 2.42 TB database footprint

Delphix_IDCReport_Infographic

Screen Shot 2014-08-12 at 10.26.54 AM

Screen Shot 2014-08-12 at 10.27.20 AMScreen Shot 2014-08-12 at 10.27.29 AM