DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2002

    how to get alter table progress/status


    I am running alter table

    alter table mytable add (newaddr varchar2(20) default '' not null);

    mytable is 30 M Rows table.

    this cmd is going to update all existing rows with new columns default value.

    my questions

    - is there any system table where i can see status on this alter cmd, like in v$sql i can see rows_processed if i do update/select/insert/delete

    - is there any better way of doing it

    - if i populate new column with NULL , which one is costly ? with NULL or with some default value.

    i can see only growing rollback segment...
    thanks in advance

  2. #2
    Join Date
    Sep 2003
    over the hill and through the woods
    If you've got OEM up you can go into sessions and take a look at it. Click on the "long operations" and you'll see it doing a bunch of sorting.
    Oracle it's not just a database it's a lifestyle!
    BTW....You need to get a girlfriend who's last name isn't .jpg

  3. #3
    Join Date
    May 2003
    Pretoria, Rep of South Africa
    Able was I ere I saw Elba

  4. #4
    Join Date
    Dec 2002
    Bangalore ( India )
    v$transaction might give you some good info as well..

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.