Inactive Session/Application Slow
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Inactive Session/Application Slow

Hybrid View

  1. #1
    Join Date
    May 2002
    Posts
    163

    Inactive Session/Application Slow

    Hi,
    We are running an application on Oracle 8.1.7. I have compliants from the application users about the application being slow sometimes.When I monitor the DB - the DB instance everything looks OK. I am unable to find out the exactly cause of the slowness.

    I come across some inactive sessions. When I say Inactive session - these are the session that show up in v$session view. This application is running a process in 32 parallel and out of those few sessions are getting INACTIVE and the process getting slow.

    The application is simple CLIENT - SERVER based. No Application server (connection pool) is there in the middle.

    What might be causing the inactive sessions?
    ============================================

    Thanks a lot in advance.
    Nwcomer
    Student

  2. #2
    Join Date
    Jul 2002
    Location
    Northampton, England
    Posts
    612
    What kind of monitoring have you done to investigate the user's claim of "slowness"? Have you traced one of their sessions, or are you just looking at instance level stats?

  3. #3
    Join Date
    May 2002
    Posts
    163
    Hi

    My application was running ok in past. Recently it started getting slow. I monitored the followings in my DB

    1) SGA status: Fine
    2) Memory: Fine 99% hit rate
    3) Checkpoint occurance
    4) Rollback contention
    5) Session waits etc


    My top 5 wait events are

    1) db_file_sequential_read 4057992
    2) buffer_busy_waits 475055
    3) SQL* net more data to client 305261
    4) latch free 124169
    5) db_file_parallel_write 111110


    And most importantly I saw in v$session few sessions are becoming inactive. I am running a process 32 sessions wide but 5 -6 sessions are getting INACTIVE.

    I checked v$session_waits and see that they are waiting for 1) db_file_sequential_read and 2) Sql* net more from client


    A SMALL CHANGE FOUND: recently client added 8 more CPUs in the box, earlier it was 50.

    but they did not update db_block_lru_latch form 100 to 116
    and cpu_count 50 to 58

    DOES THAT MAKE ANY DIFF IN PERFORMANCE as mentioned above (waits)


    Regards
    Nwcomer
    Student

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