Book Reviews   Digital Libraries   Astronomy Log   Software   About  

Monitoring Oracle index rebuild progress
06 January 2004 12:00

Today I asked the ORACLE-L list about ways to monitor the progress of an Oracle index rebuild (index rebuilds on a live system when you don't have EE are no fun). One suggestion was to use v$session_longops, which looks interesting. Tanel Poder, on the list, said this:

Check v$session_longops view, it is meant for monitoring this kind of long-running jobs - but it can be quite inaccurate. Another way would be to check v$sort_usage during sorting phase of index recreation and then check the newly created index segments size (it'll be created as a temporary segment initially and switched to index-type afterwards).

Monitoring the creation of the new temporary segments/extents was something I thought of initially, but I'd like to see how accurate v$session_longops is.

True love begins when the needs of others become more important than your own.
The practice of true love begets true happiness


Daniel Hanks

I'm a system administrator working for Omniture

Interested in

digital archival
digital libraries
web applications
web infrastructure
distributed storage

among other things . . .


Pamela Hanks

is an excellent storyteller.

(She also happens to be my wife :-)

A storyteller makes a wonderful and unique addition to family, school, church or other group events. Schedule her for your next gathering.
Kiva - loans that change lives

Recent Blog Entries

Subscribe with Bloglines
- OpenWest Conference 2014 Presentation Slides - Ansible
- OpenWest Conference 2013 Presentation Slides
- Utah Open Source Conference 2012 - Presentation slides
- E-Book Review: Data Mashups in R
- Book Review: Illustrated Guide to Astronomical Wonders
- Book Review: Wicked Cool Shell Scripts
- PLUG Presentation Slides: The Open Source Data Center
- Harnessing human computational power from computer games
- I love a good roadtrip
- FamilySearch Developers Conference 2008 presentations now available online
- FHT follow up: an idea for a mobile genealogical application
- Family history and technology: it's only getting better
- President Hinckley passes away
- December is NaBoMoReMo - National Book of Mormon Reading Month
- Family History, Photos, Blogs, and Books
- The Compact Oxford English Dictionary
- 1830s English and the Book of Mormon
- Google adds My Library feature to Book Search
- Utah Open Source Conference
- Wiki diagrammer (Steal this idea!)

All Entries . . .

LDS Open Source Software
A website discussing the use of Open-source software for applications useful to those sharing values of the Latter-day Saint (Mormon) faith.

© 2009, Daniel C. Hanks