Results 1 to 6 of 6

Thread: To See Progress

  1. #1
    Join Date
    Jun 2007
    Posts
    10

    Unanswered: To See Progress

    can any one help me .....
    I want to see the progress of a delete operation.or how many rows have been deleted when the delete operation is running.

    thanx.
    tanmoy.

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    You can not (as far as I can tell).

    Actually, you could using PL/SQL, but it wouldn't be real-time as it would display all messages at once when PL/SQL block finishes its execution.

    BTW, what is the purpose of doing it?

  3. #3
    Join Date
    Jun 2007
    Posts
    10
    I executed a delete operation and it takes more than 10 min. then I thought is there any problem during the deletion. thats it.

    thanx.

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Repeated SELECTs against V$SESS_IO can/will show I/O counts increasing.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    May 2004
    Location
    Dominican Republic
    Posts
    721
    I would rather go with V$TRANSACTION for this.

  6. #6
    Join Date
    Dec 2003
    Posts
    1,074
    You could use PL/SQL and the BULK COLLECT syntax. Maybe that wouldn't slow things down too much. Then, every 1000 or so deletes write to a logging table (via a PL/SQL function set up as an automomous_transaction with a commit), and use a separate session to monitor. --=cf

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •