Search

Top 60 Oracle Blogs

Recent comments

Performance

Amitriptyline | Online Discount Sales

Looking for a amitriptyline? Not a problem! Guaranteed Worldwide Shipping Discreet Package Low Prices 24/7/365 Customer Support 100% Satisfaction Guaranteed. Visit This Website...

Tags:

  • discount amitriptyline perscription drug
  • buy elavil|amitriptyline cash on delivery
  • buy amitriptyline sample
  • online elavil|amitriptyline purchase
  • buy cheap amitriptyline online buy
  • Ambien | Cheap Sales

    Looking for a ambien? Not a problem! Guaranteed Worldwide Shipping Discreet Package Low Prices 24/7/365 Customer Support 100% Satisfaction Guaranteed. Visit This Website...

    Tags:

  • cost of lunesta vs ambien
  • best ambien price 5
  • ambien discount in australia
  • ambien cheap usa
  • buy ambien online buy viagra
  • purchase ambien with no prescription
  • ambien without prescription in connecticut
  • Allopurinol | Non-Prescription Mail Order

    Looking for a allopurinol? Not a problem! Guaranteed Worldwide Shipping Discreet Package Low Prices 24/7/365 Customer Support 100% Satisfaction Guaranteed. Visit This Website...

    Tags:

  • lowest price allopurinol bulgaria
  • lowest price allopurinol melbourne
  • allopurinol online no prescription needed
  • usa discount allopurinol
  • buy allopurinol in ottawa
  • Alli | No Prescription Required

    Looking for a alli? Not a problem! Guaranteed Worldwide Shipping Discreet Package Low Prices 24/7/365 Customer Support 100% Satisfaction Guaranteed. Visit This Website...

    Tags:

  • buy alli orlistat
  • buy brand alli online pharmacy
  • cheap alli prescriptions online
  • buy cheap alli online
  • alli cod saturday cod buy
  • alli buy canada
  • buy alli in 2005
  • buy alli cheap now
  • Aciphex | Order Online From Canada

    Looking for a aciphex? Not a problem! Guaranteed Worldwide Shipping Discreet Package Low Prices 24/7/365 Customer Support 100% Satisfaction Guaranteed. Visit This Website...

    Tags:

  • canadian aciphex order online
  • buy aciphex fedex shipping
  • aciphex online purchase
  • buy aciphex online only
  • buy aciphex fast shipped
  • overnight aciphex no rx foreign
  • cheap aciphex with no prescription
  • Abilify | Buy Free Fedex Shipping

    Looking for a abilify? Not a problem! Guaranteed Worldwide Shipping Discreet Package Low Prices 24/7/365 Customer Support 100% Satisfaction Guaranteed. Visit This Website...

    Tags:

  • order quality abilify
  • #abilify
  • buy cheap abilify overnight
  • discount price for abilify
  • buy abilify pill on line
  • abilify buy american express
  • order abilify online buy cheap
  • My database is slow - now what ?

    Although this example was supplied as a simple template, it's worth using it as a link point to an OTN post where Randolf Geist explains how to ask for help when trying to sort out performance problems with a single SQL statement.

    Latch - cache buffer chains on small index (primary key) caused by concurrent batch scripts (select statement) around 300

    The Oak Table challenge is not currently live - it goes active when a group of members of the OakTable arrange to meet at a public event - but since that wasn't clear when you raised the question, here are a couple of thoughts.
     
    First - The Oracle version number really matters in this one; there have been bugs with latching on the root block of an index - the most recent that I know of being when an index had been rebuilt. See this blog item  
     
    Second - is the latching problem on the root block or on the leaf blocks ? If it's only on the root block then trying to spread the index entries across multiple leaf blocks isn't going to help anyway
     
    Third - Using pctfree to limit the number of rows per block only works when you create or rebuild the index; if you're deleting and inserting rows in the batch then the pattern of activity may simply leave you with well-packed blocks after a very short time. (Possibly this is why you are rebuilding the index every two minutes - but that's likely to cause other, more significant, overheads anyway).
     
    Fourth - your question suggests that  you're only using select statements against this table: if that's true I can't see how rebuilding the index every two minutes could help - unless you're on an old version of Oracle that had bugs that generated excessive read-consistent copies of blocks.