Register Login

What Would be The Reason for Sudden Dead Slow of Oracle Server?

Updated May 19, 2018

Hi Oracle Experts,
One of my Oracle server suddenly become dead slow so I want to know that what may be the cause for this. I want to know that where should I look for the reason? As I am a Plsql developer so I do not have much knowledge on dba things. So please suggest me the right solution and cause for this problem faced by me.

Thanks in Advance!


Comments

  • 28 Aug 2015 4:43 pm Rohit Mahajan

    You need to check the following:
    1.Check Space in Drives
    2.Check Storage of Data File
    3.Check Temp Folders

  • 28 Aug 2015 4:46 pm Nitesh Singh

    Genarate AWR ASH reports and dig to find out root cause. Try to intimate DBA. You need to verify those objects for any poor query and any full table scans and row level table level locks also. And need to verify all active sessions and what query those users and sessions using. You need to gather Statistics DB level, schema level.

  • 28 Aug 2015 4:47 pm Romil Tripathi

    You need to check SGA target and sga max size.

  • 28 Aug 2015 4:47 pm Jyoti Pandey

    First intimate to DBA. He knows where to check and what to do?

  • 28 Aug 2015 4:47 pm Chandan Singh Parihar

    You need to fetch addm report and find what sql is taking much time to execute.


×