how to get alter table progress/status
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: how to get alter table progress/status

  1. #1
    Join Date
    Nov 2002
    Posts
    31

    how to get alter table progress/status

    Hi

    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
    gx

  2. #2
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    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
    Location
    Pretoria, Rep of South Africa
    Posts
    191
    Able was I ere I saw Elba

  4. #4
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    v$transaction might give you some good info as well..
    funky...

    "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