RE: Checking the rebuildability of an index

Jesse,

Platform HPUX 11 Oracle ver 7.3.4.5 Application Oracle Financials 10.7

This is further to my reply to Ethan's email. Oracle Financials using hundreds of INTERFACE applications for their different modules and these serve as TRANSITORY place before moving data to their final tables. By keeping this strategy, if any data before final posting goes through this tables and if any error/short coming is found in data, it provides opportunity to correct it and then post it.

Because of this there are lot of inserts and deletes(in terms of thousands)everyday in such tables so indexes on these tables occupies a lot of space and also slowing down performance of these tables. To keep performance intact, we have to keep rebuilding indexes on such tables with regular interval and for this we don't rely on any statistics.

I hope it clarifies..
Regards
Rafiq

Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Date: Tue, 06 Aug 2002 11:55:26 -0800

Hi Rafiq,

Not having the pleasure of dealing with Oracle Financials, how are the 'INTERFACE' tables used? Is it a "populate, query, delete" temporary kind of table?

Rich Jesse                           System/Database Administrator
Rich.Jesse_at_qtiworld.com              Quad/Tech International, Sussex, WI USA

> -----Original Message-----
> From: Mohammad Rafiq [mailto:rafiq9857_at_hotmail.com]
> Sent: Tuesday, August 06, 2002 2:34 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Checking the rebuildability of an index
>
>
> Ethan,
>
> With due respect to both Tom Kyte and Jonathan Lewis,if
> database has tables
> with lot of deletions like Oracle Financials 'INTERFACE'
> tables, regular
> rebuilding of indexes really help in keeping good performance
> and release of
> good amount of space. If you don't rebuild indexes for a
> while on such
> tables then performance degrades very fast.
>
> Regards
> Rafiq

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jesse, Rich
   INET: Rich.Jesse_at_qtiworld.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).




_________________________________________________________________
Join the world’s largest e-mail service with MSN Hotmail. 
http://www.hotmail.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohammad Rafiq
  INET: rafiq9857_at_hotmail.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).