Track a long DELETE execution
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Track a long DELETE execution

  1. #1
    Join Date
    Sep 2000
    Location
    Sao Paulo,SP,Brazil, Earth, Milky Way
    Posts
    350

    Track a long DELETE execution

    I want to check the progress of a long DELETE running in the server from another machine. I tried V$SESSION_LONGOPS, but the DELETE is being done row by row, and longops tracks only bulk operations. My test case :

    SQL> create table TAB_TEST(c1 number, c2 varchar2(45));

    SQL> BEGIN
    2 for i in 1..1999999 loop
    3 insert into TAB_TEST values(i, 'Linha ' || i);
    4 end loop;
    5 END;
    6 /

    SQL> commit;

    ==> now I will do a long delete :

    SQL> update TAB_TEST set c2='x' where c2 like 'Linha 2%';

    ==> in another session I will consult V$SESSION_LONGOPS :

    SQL> select * from v$session_longops where time_remaining > 0;

    SQL>

    nothing show. Any ideas to do it ? DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS donīt work int this case, AFAIK, only in LOOP operations.

    Regards,

    Chiappa

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Where's the row-by-row delete?
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

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