how to monitor progress of index creation
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: how to monitor progress of index creation

Hybrid View

  1. #1
    Join Date
    Jun 2001
    Posts
    150

    how to monitor progress of index creation

    Hi All
    I am creating index on oracle805 database. Table is very big and it is being running for hours. How can i find out that index creation is going on or stuck somewhere or is waiting for something.
    Please reply asap as i have this night to find a solution.

    Thanks
    UKDBA

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Is there a V$SESSION_LONGOPS in 805?
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Jun 2001
    Posts
    150

    Thumbs up

    Hi
    The way i found is that by looking used_blocks and used_extents column for v$sort_segment. This will tell you about progress of index and it becomes easier as i was using a seperate temporary tablespace for index creation.

    Thanks
    ukdba

  4. #4
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586
    UK DBA. how would i corrolate that with my process that is creating the index?? There is no way to join v$sort_segment with a process on v$session?
    "High Salaries = Happiness = Project Success."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width