Solved

ctx_ddl.optimize_index() takes a long time

Posted on 2008-10-08
4
1,062 Views
Last Modified: 2013-12-19
Hello

ctx_ddl.optimize_index() takes a long time
It runs for 60-90 mins earlier it was use to complete within 10 mins
Number of rows approx 0.5 million

Kindly let me know reason what all possible reasons can be for its delay.

Regards
Ankush
0
Comment
Question by:Ankush_Chawla
  • 2
4 Comments
 
LVL 74

Expert Comment

by:sdstuber
ID: 22723908
has the index changed or the volume of data?  Has it always been .5 million?  is it still .5 million?
0
 
LVL 74

Accepted Solution

by:
sdstuber earned 500 total points
ID: 22723912
you can trace the session running the optimize,  capture wait events and see what it's hanging on
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
execute immediate plsql block 5 57
PL/SQL Two changes 7 34
Oracle DB monitor SW 21 60
Oracle create type table from existing table%rowtype ? 6 34
Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question