Ask a Question related to Oracle Server, Design and Development.
-
Dave #1
Index Partition Rebuild is using Full Table Scan
I am rebuilding multiple UNUSABLE index partitions on Oracle HP/UX ...
Oracle8i Enterprise Edition Release 8.1.7.4.0 - 64bit Production
With the Partitioning option
JServer Release 8.1.7.4.0 - 64bit Production
The rebuild command ...
alter index XIE12FCT_ITEM rebuild partition Y2002_M11 compute
statistics pctfree 0 nologging parallel;
.... which normally completes in less than ten seconds was observed to
be taking very much longer. OEM showed a "Long Operation" for the
session, and is showing scans of every partition of the table, despite
showing the correct SQL.
We have done this every month for over two years, and suddenly all of
these rebuilds are full-scanning the source tables. We are not aware
of any config changes to the DB or server.
Tables are all range partitioned by DATE with mostly bitmap indexes.
Does any have any insights here?
Dave Guest
-
Any advantages over Acrobat full-text index vs. Spotlight?
Are there any advantages between creating a full-text index in Acrobat Pro vs the indexing Spotlight on OS X 10.4? -
Index scan vs. Seq scan on timestamps
On Tue, Dec 07, 2004 at 09:25:20AM +0100, Per Jensen wrote: CURRENT_TIMESTAMP is fixed to the time of transaction start, not session start; this... -
How to insert data using index unusable/rebuild
I am trying to rewrite a generic data load procedure for large tables to use the INDEX REBUILD statements instead of dropping and recreating the... -
Rebuild a table
Try: create table #t(a int, b int) insert into #t values (1,4) insert into #t values (2,5) select 'A' col1, a from #t union all select 'B'... -
Rebuild index in SQL server ¿?¿?
hi all, in access we have an "utility" to rebuild autonumeric index when a table is empty(Set the autonumeric to the first available... -
Jonathan Lewis #2 Re: Index Partition Rebuild is using Full Table Scan
I think I noticed a bug on Metalink about
this some time ago. But I can't guarantee
that my memory is correct.
--
Regards
Jonathan Lewis
[url]http://www.jlcomp.demon.co.uk[/url]
Next Seminar dates:
(see [url]http://www.jlcomp.demon.co.uk/seminar.html[/url] )
____England______January 21/23
The Co-operative Oracle Users' FAQ
[url]http://www.jlcomp.demon.co.uk/faq/ind_faq.html[/url]
Dave wrote in message .......>I am rebuilding multiple UNUSABLE index partitions on Oracle HP/UXdespite>
>Oracle8i Enterprise Edition Release 8.1.7.4.0 - 64bit Production
>With the Partitioning option
>JServer Release 8.1.7.4.0 - 64bit Production
>
>The rebuild command ...
>
>alter index XIE12FCT_ITEM rebuild partition Y2002_M11 compute
>statistics pctfree 0 nologging parallel;
>
>... which normally completes in less than ten seconds was observed to
>be taking very much longer. OEM showed a "Long Operation" for the
>session, and is showing scans of every partition of the table,>showing the correct SQL.
>
>We have done this every month for over two years, and suddenly all of
>these rebuilds are full-scanning the source tables. We are not aware
>of any config changes to the DB or server.
>
>Tables are all range partitioned by DATE with mostly bitmap indexes.
>
>Does any have any insights here?
Jonathan Lewis Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
