RE: re Rebuilding Indexes in Oracle Apps -- was RE: RE:

Oops, I didn't see that part. Thanks for the catch, Hemant.

Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:

- Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney
- SQL Optimization 101: 12/8-12 Dallas
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit www.hotsos.com for schedule details...

-----Original Message-----
Hemant K Chitale
Sent: Tuesday, October 21, 2003 10:15 AM To: Multiple recipients of list ORACLE-L

Unfortunately, the lines
" Unoccupied space on indexes occurs when a key value changes, and the
index

     row is deleted from one place (Leaf Block) and inserted into another.

     Deleted Leaf Rows are not reused. Therefore, indexes whose columns are

     subject to intensive value change should be rebuilt periodically, since

     they become naturally fragmentated. " are still visible in Note 182699.1

Hemant

At 08:29 AM 20-10-03 -0800, you wrote:
>Fyi, Oracle updated note 182699.1 last Friday. The inaccurate
statements
>about "index fragmentation" have been removed.
>
>
>Cary Millsap
>Hotsos Enterprises, Ltd.
>http://www.hotsos.com
>
>Upcoming events:
>- Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney
>- SQL Optimization 101: 12/8-12 Dallas
>- Hotsos Symposium 2004: March 7-10 Dallas
>- Visit www.hotsos.com for schedule details...
>
>
>-----Original Message-----
>Richard Foote
>Sent: Friday, October 17, 2003 6:29 AM
>To: Multiple recipients of list ORACLE-L
>Separate
>
>Hi Hemant,
>
>One word perfectly describes the Metalink article you highlighted:
>
>Crap ;)
>
>A nice example of how Oracle Corp is the greatest myth generator of
>them
>all !! It's all rather sad and embarressing isn't.
>
>Thanks for the headsup. Anyone in a position to get the note removed ?
>
>Cheers
>
>Richard
>
> >Quoting Metalink Note 182699.1 bde_rebuild.sql Validates and Rebuilds
>Fragmentated Indexes (8.0->9.0)
> >
> >Index fragmentation occurs when a key value changes, and the index
row
>is
> >deleted from one place (Leaf Block) and inserted into another.
> >
> > Deleted Leaf Rows are not reused. Therefore indexes whose columns
are
> >subject to value change must be rebuilt periodically since they
become
>naturally fragmentated.
> >
> >An index is considered to be 'fragmentated' when more than 20% of
its
>Leaf
>Rows space is
> >empty because of the implicit deletes caused by indexed columns value
>changes.
> >
> >Fragmentated indexes degrade the performance of index range scan
>operations.
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Richard Foote
> INET: richard.foote_at_bigpond.com
>
>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting services
>---------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Cary Millsap
> INET: cary.millsap_at_hotsos.com
>
>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting services
>---------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).

Hemant K Chitale
Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Hemant K Chitale
  INET: hkchital_at_singnet.com.sg

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Cary Millsap
  INET: cary.millsap_at_hotsos.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).