CTAS progress
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: CTAS progress

  1. #1
    Join Date
    Jul 2002
    Location
    Northampton, England
    Posts
    612

    CTAS progress

    Hi all

    Its Saturday afternoon in the UK, Andy Murray is about to play at Wimbledon on the telly and I am having to sit watching a CTAS of approximately 20m rows. There is the gripe over with, now on the the age-old problem. Does anyone know of any clever way of telling how far through the process I am? v$session_longops doesn't seem to tell me what I want to know... Any bright ideas?

    Thanks!

    db = 10.2.0.2
    os = RHEL 4
    Last edited by waitecj; 06-28-2008 at 10:39 AM.
    Assistance is Futile...

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,445

    Talking Don't know, but...

    Did you try COUNT(*)?
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  3. #3
    Join Date
    Feb 2004
    Location
    UK
    Posts
    56
    Surely that wouldn't work as the rows would be uncommitted until it had finished. Still I guess it has finished now !

  4. #4
    Join Date
    Jul 2002
    Location
    Northampton, England
    Posts
    612
    I wanted some measure or other to check the progress every few minutes, so I wanted it to be something that wasn't going to have a negative affect on the process itself ... and the table has BLOBs of varying sizes so the number of rows wouldn't give me an indication of the amount that had been done.... Did I not mention that?... :ahem:
    Assistance is Futile...

  5. #5
    Join Date
    Feb 2004
    Location
    UK
    Posts
    56
    Would the select count(*) work though as the data would not be commited - or have i missed something?

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