RE: rebuilding indexes - sure to cause a ruckus

not to mention running 48 batch jobs on a 8CPU box with all of them committing after every record and using the table to generate keys (Cary would love this one) ;) They wanted to find other reasons and he conveniently ignored the real problem. Beautiful... Cary Millsap Hotsos

RE: rebuilding indexes - sure to cause a ruckus

You probably think you're joking. Unfortunately . . . We've been fighting with Oracle for several months about SEVERE performance degradation on an OpenVMS application after we upgraded the database to 8.1.7.4 One of Oracle's recommendations taken directly from our TAR just 2 weeks ago: o

RE: rebuilding indexes - sure to cause a ruckus

Ouch. Suddenly, it seems not so funny -Original Message- Sent: Friday, December 12, 2003 11:25 AM To: Multiple recipients of list ORACLE-L You probably think you're joking. Unfortunately . . . We've been fighting with Oracle for several months about SEVERE performance

Re: rebuilding indexes - sure to cause a ruckus

If it's from Oracle, I would believe it, i.e., I would believe somebody did actually say that ;) But it does not make it right. Now only if management knew/believed that. Some more from Oracle, - Oracle writes to one log member and then the other. So you need both log members for recovery.

Re: rebuilding indexes - sure to cause a ruckus

Can we, please, change terminology and use the term log file instead of log member. I distinctly remember backup recovery class in NYC when a guy with a heavy accent popped the following question: Can I recover the database if I lose my member? It was the time after lunch while we

RE: rebuilding indexes - sure to cause a ruckus

Mark, I just met Elvis behind local Wal-Mart parking lot, we discussed the same topics ... funny you mention them. Oh ans we did talk about investing in Enron too (got a hot tip, the stock is going to go up). Raj

Re: rebuilding indexes - sure to cause a ruckus

Thanks Raj, Unfortunately, in my rush to get the kids to school in time, I stuffed the formatting when my cut 'n' pasting got converted to plain text. Hope you found it all useful. Cheers Richard - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent:

Re: rebuilding indexes - sure to cause a ruckus

Hi Yong, One thing I should have mentioned when I posted my epic is that it not only attempts to correct the numerous technical errors in the article but also attempts to answer the various questions the article raises but totally fails to address. What I find most astonishing about the article

Re: rebuilding indexes - sure to cause a ruckus

Richard: I think that is the simple way of questioning other person's capacity. Remember this statment (borrowed from some one !!) If you are telling something is simple, you are questioning the other person's intelligence !!' KG -- Please see the official ORACLE-L FAQ:

RE: rebuilding indexes - sure to cause a ruckus

Richard, I found it immensely useful, that's why I created the tinyurl and went to c.d.o.s and read the whole thread, from first to last post. (man those people need to learn to weed out old comments in the replies). This is what I love about this forum, it comes with huge amount of knowledge,

OT Re: Re: rebuilding indexes - sure to cause a ruckus

Hi Richard, I think, there are 2 candidates for an answer. 1life (nothing is more difficult) 2...love (ever tried to read your madam's thoughts?) ;-) Corrections welcome (as always). Cheers, Guido [EMAIL PROTECTED] 10.12.2003 11.39 Uhr (snip) If I can convince anyone who makes it

Re: rebuilding indexes - sure to cause a ruckus

: rebuilding indexes - sure to cause a ruckus And in case you miss it in Richard's terse message, one of the big reasons that it is not 'rocket science' is that you can perform operations that modify the index(es), and perform block dumps of the index as you go. You can see exactly what

Re: rebuilding indexes - sure to cause a ruckus

Hi KG, O, you've got me thinking here !! I'm not too sure that I've really questioned anyone's intelligence. I've always measured someone's intelligence by: 1. How quickly the can learn and absorb new information 2. How much they know and appreciate the work of David Bowie A quick

RE: rebuilding indexes - sure to cause a ruckus

Richard Foote scribbled on the wall in glitter crayon: BTW, does anyone know what a rocket scientist refers to when they say Hey, this is all quite easy, it sure ain't ? ? the only two i know use theoretical physics.;-) -- Bill Shrek Thater ORACLE DBA I'm going to work my

RE: rebuilding indexes - sure to cause a ruckus

BTW, does anyone know what a rocket scientist refers to when they say Hey, this is all quite easy, it sure ain't ? ? Cheers ;) Richard Surely the Rocket Scientist version must be Hey, this is all quite easy, it sure ain't index rebuilding very evil grin Ciao Fuzzy :-) -- Please

RE: rebuilding indexes - sure to cause a ruckus

LOL, This made me think of the Simpson's Halloween episode where Monty Burns says, 'Smithers, this isn't rocket science, its brain surgery'. - Alan Davey Senior Analyst/Project Leader Oracle 9i OCA; 3/4 OCP w) 973.267.5990 x458 w) 212.295.3458

RE: rebuilding indexes - sure to cause a ruckus

I think this subject has been done to death. We should talk about less contentious issues such as: - The buffer cache hit ratio, your friend in expert Oracle tuning! - Rebuild your tables regularly to reduce the number of extents and improve performance! - Disk access is at least 10,000x

Re: rebuilding indexes - sure to cause a ruckus

How about: Keep re-analyzing your tables and indexes. Run gather_statistics (or whatever) all the time. Bobak, Mark wrote: I think this subject has been done to death. We should talk about less contentious issues such as: - The buffer cache hit ratio, your friend in expert Oracle tuning! -

Re: rebuilding indexes - sure to cause a ruckus

Hi Tanel, I recommend a strong cup of coffee and a small nap 1/2 way through ;) - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 7:44 AM Ouch, I gotta take a day off to read this one ;) -- Please see the official

Re: rebuilding indexes - sure to cause a ruckus

Hi Paul, The long one includes a discussion on why you should generally coalesce rather than rebuild indexes ;) Cheers Richard - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 8:44 AM somewhat on the longish side???

Re: rebuilding indexes - sure to cause a ruckus

Hi Steve, I agree completely, but the question is would you rebuild it afterwards ? Cheers ;-) - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 9:29 AM I think it needs an index. ;-) -Original Message-

RE: rebuilding indexes - sure to cause a ruckus

This message's a keeper! Thanks! :) Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- Sent: Monday, December 08, 2003 3:29 PM To: Multiple recipients of list ORACLE-L Hi Yong,

RE: rebuilding indexes - sure to cause a ruckus

Richard's explanation and example from c.d.o.s now has a permanent tinyurl link ... http://tinyurl.com/yflq if anyone is interested ... this might be better for bookmarks. Raj Rajendra dot Jamadagni at nospamespn

RE: rebuilding indexes - sure to cause a ruckus

What sort of Oak Table member are you, Richard? Any Oak Table member worth their weight in toilet paper would certainly execute DBMS_POWERNAP part way through, but the strong cup of coffee definitely needs a large shot of whiskey substituted for it! :) Pete Controlling developers is like

Re: rebuilding indexes - sure to cause a ruckus

Thanks, Richard. I'll read your long message more carefully later. I like your statement that rebuilding an index or not is not rocket science. One needs to measure the performance before and after the rebuild and make a conclusion himself. Many times we discuss performance issues and get very

Re: rebuilding indexes - sure to cause a ruckus

Huang [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/09/2003 11:44 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: rebuilding indexes - sure to cause a ruckus Thanks, Richard. I'll read your long message more

RE: rebuilding indexes - sure to cause a ruckus

Science is the belief in the ignorance of experts. --Richard Feynman Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Performance Diagnosis 101: 12/16 Detroit, 1/27 Atlanta - SQL Optimization 101: 12/8 Dallas, 2/16 Dallas - Hotsos Symposium 2004: March 7-10 Dallas

RE: rebuilding indexes - sure to cause a ruckus

Shh!! Nonsense! It's all black magic and conjecture! How else are we going to be highly paid Oracle consultants, if everyone knows all this stuff is provable and demonstrable?? ;-) -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Tuesday, December 09,

Re: rebuilding indexes - sure to cause a ruckus

Hi! Yes Yong I agree with you, that rebuilding may be beneficial in some cases, especially some tables/indexes become either logically or physically read only (btw, I was not speaking about coalescing in my post, it's a different story anyway). But the point I wanted to make is that single

Re: rebuilding indexes - sure to cause a ruckus

Ouch, I gotta take a day off to read this one ;) Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 08, 2003 11:29 PM Hi Yong, Saying there are a few errors is being a little kind to Don's Inside Oracle Indexing article.

Re: rebuilding indexes - sure to cause a ruckus

Hi Yong, Saying there are a few errors is being a little kind to Don's Inside Oracle Indexing article. In part, these are some of the issues I raised directly with Don in a number of emails (warning somewhat on the longish side ;): a.. There are no such things as star indexes. Star joins, yes,

Re: rebuilding indexes - sure to cause a ruckus

Tanel Poder wrote: Ouch, I gotta take a day off to read this one ;) http://www.netmeister.org/news/learn2quote.html It's all about optimization... -- Vladimir Begun The statements and opinions expressed here are my own and do not necessarily represent those of Oracle Corporation. -- Please see

Re: rebuilding indexes - sure to cause a ruckus

somewhat on the longish side??? I'd hate to see a long article! ;-) --- Richard Foote [EMAIL PROTECTED] wrote: Hi Yong, Saying there are a few errors is being a little kind to Don's Inside Oracle Indexing article. In part, these are some of the issues I raised directly with Don in a

RE: rebuilding indexes - sure to cause a ruckus

I think it needs an index. ;-) -Original Message- Paul Baumgartel Sent: Monday, December 08, 2003 3:44 PM To: Multiple recipients of list ORACLE-L somewhat on the longish side??? I'd hate to see a long article! ;-) --- Richard Foote [EMAIL PROTECTED] wrote: Hi Yong, Saying there

Re: rebuilding indexes - sure to cause a ruckus

Tanel, I think you're saying a query almost always runs faster right after the index rebuild and there's no point in finding the criterion whether to rebuild an index. (What is 42?) Some time ago I posted a message somewhere else showing a case where rebuilding or coalescing an index may be

RE: rebuilding indexes - sure to cause a ruckus

Wow. We've got a lot of indexes to rebuild... :) Seems like those criteria have been beaten up on this list before. Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- Sent:

Re: rebuilding indexes - sure to cause a ruckus

There's no point of arguing about whether a query ran faster right after you rebuilt your index. Nor there is no point in finding some ultimate algorithm for finding the point of index rebuilding, we all know the answer - it's 42. Instead, a long stress test has to be done, e.g. running 10

RE: rebuilding indexes - sure to cause a ruckus

Thanks, Added this one to my bookmarks along with http://www.oracle.com/oramag/webcolumns/2001/index.html?auto_index.html and http://www.dba-oracle.com/art_index1.htm Sten ;) -Original Message- [EMAIL PROTECTED] Sent: Thursday, December 04, 2003 11:55 AM To: Multiple recipients of

Re: rebuilding indexes - sure to cause a ruckus

Comments in-line Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr One-day tutorials: http://www.jlcomp.demon.co.uk/tutorial.html Three-day seminar: