Progress status of index rebuild in Oracle

  The game never ends after the creation of anything. It starts when it comes to the phase of maintenance. Today we are going to have look on the query which is used to look “Progress status of index rebuild/creation or long operation”.      Let’s have look on the query. select sid, target, to_char(start_time,’hh24:mi’) start_time, elapsed_seconds/60 elapsed, […]

Read More