I have a simple one liner SQL command to create an index.
Due to amount of data, this statement takes a long time.
I am doing this through an application and would like somehow to
see the progress of my index creation.

Currently the users just see the system sit there and they think it is dead.

How can I get the progress of my operation?
Is there a query I can do?

NOTE: I am using Oracle 8.1.7.0

Help?

Robert Furatdo

Oracle LazyDBA home page