Results 1 to 3 of 3

Thread: Status=INACTIVE

  1. #1
    Join Date
    May 2002
    Location
    Timbaktu
    Posts
    185

    Unanswered: Status=INACTIVE

    What is the meaning of Status='INACTIVE' in Oracle?One of our query is running for hours without any result but the status=INACTIVE?

  2. #2
    Join Date
    Dec 2002
    Location
    Netherlands
    Posts
    118
    Hi


    When status = inactive in v$session it should be just what it says, session is inactive...


    Are you sure your query is still running?

    Remi
    Remi Visser

    Oracle Database Administrator
    (OCP certified 8i)

    Homepage: http://home.remidian.com/

  3. #3
    Join Date
    May 2002
    Location
    Timbaktu
    Posts
    185
    We are trying to run some report and the report works fine as long as it's a short report.But for big reports the status is changing to Inactive after sometime and then nobody knows that what's going on?Any help?Is there any query timeout in Oracle?

Posting Permissions

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