My DB is getting slow on particular weekdays like Saturday and Sunday. What will be the reason?
Database is Oracle 11g R1.
Operating system is Windows 2003 64 Bit Service pack 2.
My DB is getting slow on particular weekdays like Saturday and Sunday. What will be the reason?
Database is Oracle 11g R1.
Operating system is Windows 2003 64 Bit Service pack 2.
This could be a million things ..
It would be very strange if this is directly related to your DB. AFAIK there is no if dow='Saturday' then wait 5000 end
code in Oracle ...
Can you run an AWR/ statspack report during the week when performance is good and compare that to an AWR/ statspack report from the weekend where performance is poor? If the entire system is slow, the AWR/ statspack report should identify what the system is waiting on.