indexes love big blocks

Quote:

---

Originally posted by Tarry
Also to note that reply from mike ault's on the oracle app dba forum, it's a copy/paste from metalink.
Is that allowed?

---

A good question. We have talked about "acceptable/fair use" before. e.g. http://www.dbasupport.com/forums/sho...0&pagenumber=3

I doubt if Oracle would be able to maintain that it is losing support fees because of that post. On the other hand Rampant Techpress has taken the high moral ground on this issue: http://www.rampant-books.com/t_plagi..._detection.htm

Most people accept that a short quote, which acknowledges its source, is fair use. Arguably that's the case here.

P.S. . . . and if it's "for nonprofit educational purposes" it's fair use: http://www.copyright.gov/title17/92chap1.html#107

Quote:

---

Originally posted by gandolf989
Yeah, it's a good thing he didn't see you tag when it was "Tom Kyte's love child!"
We should really keep that a secret. ;)

---

Well gee thanks Gandolf lol :p
I knew eventually Tom would show up here with all the hoopla going on and I didn't know how he'd take it seeing someone with a tag that they were his illegitimate son.

Quote:

---

Originally posted by OracleDoc
Well gee thanks Gandolf lol :p
I knew eventually Tom would show up here with all the hoopla going on and I didn't know how he'd take it seeing someone with a tag that they were his illegitimate son.

---

que sera sera

Quote:

---

Originally posted by simply_dba
que sera sera

---

Whatever will be, will be! :D

Quote:

---

Originally posted by OracleDoc
Well gee thanks Gandolf lol :p
I knew eventually Tom would show up here with all the hoopla going on and I didn't know how he'd take it seeing someone with a tag that they were his illegitimate son.

---

You brought it up and I just couldn't resist. In fact you gave me the idea to do it. :D

At first, I thought the tagline was a joke, made up....

A quick search on google and looking at the cached page -- I see it was for real:

OracleDoc
Tom Kyte's love child
Registered: Sep 2003
Location: over the hill and through the woods
Posts: 514

Now, I'm just hoping my wife doesn't google me to see what I've been up to now....

Quote:

---

Originally posted by TomKyte
At first, I thought the tagline was a joke, made up....

A quick search on google and looking at the cached page -- I see it was for real:

OracleDoc
Tom Kyte's love child
Registered: Sep 2003
Location: over the hill and through the woods
Posts: 514

Now, I'm just hoping my wife doesn't google me to see what I've been up to now....

---

In OracleDoc's defense, I would say that that is the highest form of flattery! ;)
Well, ok, maybe there is a higher form of flattery! :D

Quote:

---

Originally posted by TomKyte
Now, I'm just hoping my wife doesn't google me to see what I've been up to now....

---

Shame you don't remember the guy "with his pocket protector, bow-tie, huge overbite .. about 4'6" and 210lbs. Bald .. drove a corvette." If he were older than you, that would be a cast-iron defense. :)

Well Gee lets just get all the skeletons out of the closet now. lol

Quote:

---

Originally posted by DaPi
Shame you don't remember the guy "with his pocket protector, bow-tie, huge overbite .. about 4'6" and 210lbs. Bald .. drove a corvette." If he were older than you, that would be a cast-iron defense. :)

---

DaPi, fess up! I bet you own a Citron! Either that or an AMC Gremlin!!! :D
Either way, you definitely seem like the bow tie type!!!

Quote:

---

Originally posted by gandolf989
DaPi, fess up! I bet you own a Citron! Either that or an AMC Gremlin!!! :D
Either way, you definitely seem like the bow tie type!!!

---

OK, if its "kiss and tell time":

I've never used a pocket protector. I often wear a bow tie, but only with DJ (smoking/tuxedo or whatever it's called in your part of the world) or tails. Moderate over-bite. 5'10" 70Kg. Hair thining but no bald patch yet - getting a bit grey around the temples. Previous car was an Irmscher Opel i200 (blissful engine/gear-box combination) . . . the one in process of reconstruction is a 1929 Riley "9", in the family since 1933.

The only Citroën I've driven was a 1923 model (I think). Very slow, very exciting because the accelerator and brake pedals were the other way round!

P.S. No I don't own a lemon :)

P.P.S. I'll take this opportunity to plug a motor meeting arranged by a buddie each year: http://www.british-cars.ch/images2.html
Etrance free, 1'500 cars . . .

Quote:

---

Originally posted by DaPi
OK, if its "kiss and tell time":

I've never used a pocket protector. I often wear a bow tie, but only with DJ (smoking/tuxedo or whatever it's called in your part of the world) or tails. Moderate over-bite. 5'10" 70Kg. Hair thining but no bald patch yet - getting a bit grey around the temples. Previous car was an Irmscher Opel i200 (blissful engine/gear-box combination) . . . the one in process of reconstruction is a 1929 Riley "9", in the family since 1933.

The only Citroën I've driven was a 1923 model (I think). Very slow, very exciting because the accelerator and brake pedals were the other way round!

P.S. No I don't own a lemon :)

P.P.S. I'll take this opportunity to plug a motor meeting arranged by a buddie each year: http://www.british-cars.ch/images2.html
Etrance free, 1'500 cars . . .

---

Now this is a nice family car!

http://www.dbasupport.com/forums/ima.../2005/04/1.jpg

I don't know what a 1929 Riley "9" is, but can you post a picture?

Nope, haven't had time to do the 32k trial, especially since I don't have a 64 bit server to play with (yet). As soon as I can I will look into it.

Mike

Quote:

---

Originally posted by gandolf989
Don't know what a 1929 Riley "9" is, but can you post a picture?

---

None of these mine (it's in bits at the moment):

http://web.ukonline.co.uk/rileyrob/i...rer_pn3026.jpg

http://web.ukonline.co.uk/rileyrob/i...rer_vp8554.jpg

P.S. there was a racing "9" - some people still race them: http://web.ukonline.co.uk/rileyrob/i...pec_ww9736.jpg
OUCH!

Quote:

---

Originally posted by mikerault
Nope, haven't had time to do the 32k trial, especially since I don't have a 64 bit server to play with (yet). As soon as I can I will look into it.

Mike

---

Do you think that there could be a problem with an article that over generalizes a rule of thumb?

Quote:

---

Originally posted by mikerault
Nope, haven't had time to do the 32k trial, especially since I don't have a 64 bit server to play with (yet). As soon as I can I will look into it.

Mike

---

Quote:

---

One other thing about Mikes "Rules" for large blocksizes paper. He says

This is very true. All temp segment access is sequential and 32k blocksizes greatly reduce logical I/O and disk sort times. I'm working an a benchmark right now that shows a one-third speed improvement of disk sorts in a 32k vs. an 8k blocksize.

---

Mike, thought you were working on that benchmark for a while. but anyway, can you explain what that paragraph means?

Why is it better to read

4x32k blocks for 128k versus
16x8k blocks for 128k

since temp is read just using multi-block IO's like a full scan? It reads N kb of information, it does not read a block (so, it boils down to 6 one way and 1/2 dozen the other, we read 128k -- or Nk in general)


And also, since TEMP does not do LIO at all, what is the comment about LIO? what does that mean exactly.

See this posting for the entire discussion.

Quote:

---

Originally posted by TomKyte
Now, I'm just hoping my wife doesn't google me to see what I've been up to now.... [/B]

---

May be she has and waiting for the right moment:D

Quote:

---

Originally Posted by DaPi
P.P.S. I'll take this opportunity to plug a motor meeting arranged by a buddie each year: http://www.british-cars.ch/images2.html

---

http://www.dbasupport.com/forums/ima.../2005/04/2.jpg

Thats the car I have hired for my wedding later in the year!!

Quote:

---

Originally posted by TomKyte
since temp is read just using multi-block IO's like a full scan? It reads N kb of information, it does not read a block (so, it boils down to 6 one way and 1/2 dozen the other, we read 128k -- or Nk in general)


And also, since TEMP does not do LIO at all, what is the comment about LIO? what does that mean exactly.

See this posting for the entire discussion.

---

Don't hold your breath ... I asked Mike about this on Mar 8th http://dba.ipbhost.com/index.php?showtopic=1239&st=30

Quote:

---

Originally posted by slimdave
Don't hold your breath ... I asked Mike about this on Mar 8th http://dba.ipbhost.com/index.php?showtopic=1239&st=30

---

Watch out or he'll take you to task

Based on that I'm sure he'll be back to answer.

Quote:

---

Originally posted by mikerault
Nope, haven't had time to do the 32k trial, especially since I don't have a 64 bit server to play with (yet). As soon as I can I will look into it.

Mike

---

Mike, this comment intrigues me, as it implies to me that you believe that a test on a 32bit version of Oracle would not be valid, or something?

Quote:

---

Originally posted by slimdave
Mike, this comment intrigues me, as it implies to me that you believe that a test on a 32bit version of Oracle would not be valid, or something?

---

it is that you cannot create 32k blocks on 32 bit OS's (I cannot :(

but it does beg the question how he knows it'll show a 1/3 increase in performance but that is another story. (usually you run a benchmark to discover the results, not announce the results you'll BE benchmarking in the future? that is how it has worked for me in the past, that the results were found after the benchmark was run)

Once upon a time ago, these 32k blocks had a special name...

BOB - the Big Oracle Block, it was for the incredible addressing space of 64bit.

if you google for

"big oracle block"

you'll get one hit (like magic, until and if this page gets indexed).

We used to have an option call the VLM option (Very Large Memory) for this support -- not around anymore, but you need 64bit to get 32k blocks.

I think though that Microsoft came out with MS Bob and we backed off. Something like that.

Ya know Tom, if you're going to hang out here you might want to consider changing your userid. People may start to single you out to ask questions then the next thing you know your PM folder is flooded. It's not that I care (or anyone else for that matter)if they single you out, I was thinking it's a nice break to get away from your site and come here to just "hang out" without getting hassled all the time.

Quote:

---

Originally posted by OracleDoc
People may start to single you out to ask questions then the next thing you know your PM folder is flooded.

---

f.y.i. you can disable PM (Oh! Is that another option not available to "junior" :) - this might be more evidence for that conspiracy theory!)

Quote:

---

Originally posted by OracleDoc
I was thinking it's a nice break to get away from your site and come here to just "hang out" without getting hassled all the time.

---

Yup. No obligation to answer anything here. Just choose the ones that look like fun.