STATUS=ACTIVE and LAST_CAL_ET= Consistently Increasing
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: STATUS=ACTIVE and LAST_CAL_ET= Consistently Increasing

  1. #1
    Join Date
    May 2008
    Posts
    29

    STATUS=ACTIVE and LAST_CAL_ET= Consistently Increasing

    We have 100 sessions open through parallel executions maigrating 7 million of customer data.

    The status of these sessions are 'ACTIVE' BUT the Last_Call_ET (the Idle Time) is increasing (see the result below). I tried to tracing (10046) the SID but the DB is not generating any trace files in udump.


    SID SERIAL# USERNAME OSUSER PROGRAM COMMAND STATUS LAST_CALL_ET
    ---------- ---------- -------------------- -------------------- ------------------------------ ---------- -------- ------------
    5463 137 MIGRATION ims oracle@uludag (P044) 6 ACTIVE 676


    Question:

    1) When last_call_et is showing a high value and increasing consistently, why does the STATUS is showing 'ACTIVE'?

    2) Is there any other way, I could see what the session is doing?

    Regards

  2. #2
    Join Date
    Nov 2002
    Location
    Mooresville, NC
    Posts
    349
    May be it's doing waiting for something, could be I/O wait and that's why it's increasing.
    http://www.perf-engg.com
    A performance engineering forum

  3. #3
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    We have 100 sessions open through parallel executions maigrating 7 million of customer data.
    Do you really need 100 sessions to migrate 7 Million rows? I doubt it.
    Try with single session.

    The v$sess_io is the best monitoring view to know about IO performance of the running session.

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