Apr 22: How to generate more Logical Reads

(With my tongue starting to feel a little tired ...)

Mmmm, there’s a table that the application is accessing extremely frequently, called R_DUMMY. I wonder what data it contains?

SQL> SELECT dummy_key FROM r_dummy;

DUMMY
-----
DUMMY

Mmmm, that looks familiar, doesn’t it? It’s almost like the DUAL table, isn’t it?

 

FAST DUAL optimisation? We don’t need no stinkin’ FAST DUAL optimisation.

Sigh.

Posted by Doug Burns Comments: (2) Trackbacks: (0)
Defined tags for this entry:
Related entries by tags:
How to induce log file sync waits
"People like to have one number they can believe in."
A Miracle Masterclass ...
bstat/estat Fun
Sigh

Trackbacks
Trackback specific URI for this entry

No Trackbacks

Comments
Display comments as (Linear | Threaded)

#1 - Jeff Moss said:
2009-04-22 15:04 - (Reply)

Can you please get me a job there...I could do with a darn good laugh pal!

Cheers
Jeff

#2 - Doug Burns said:
2009-04-22 15:12 - (Reply)

Who said it's at the workplace - this is a home-developed system!

LOL


Add Comment

Standard emoticons like :-) and ;-) are converted to images.
E-Mail addresses will not be displayed and will only be used for E-Mail notifications.
BBCode format allowed