Query v$session_longops (obviously, do so in another session). OEM does
a nice progress bar from that view-- you could do the same thing from
the application or you could just present the raw data, depending on how
sophisticated you wanted to get.

Justin Cave
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC

-----Original Message-----
From: Robert FURTADO
[mailto:oracledba-ezmlmshield-x12486689.[Email address protected]
Sent: Thursday, March 03, 2005 9:35 PM
To: LazyDBA Discussion
Subject: Create Index and a progress Bar

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


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page