Database Performance Drop
Hi
I have some problem in my server at several day, database's performance going to slow where big process with big data started.
this is the information that i can give:
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ---------
1 1 182408 104857600 2 YES ACTIVE 8.2671E+12 20-AUG-10
2 1 182409 104857600 2 NO CURRENT 8.2671E+12 20-AUG-10
3 1 182398 104857600 2 YES ACTIVE 8.2671E+12 20-AUG-10
4 1 182399 104857600 2 YES ACTIVE 8.2671E+12 20-AUG-10
5 1 182400 104857600 2 YES ACTIVE 8.2671E+12 20-AUG-10
6 1 182401 104857600 2 YES ACTIVE 8.2671E+12 20-AUG-10
7 1 182402 104857600 2 YES ACTIVE 8.2671E+12 20-AUG-10
8 1 182403 104857600 2 YES ACTIVE 8.2671E+12 20-AUG-10
9 1 182404 104857600 2 YES ACTIVE 8.2671E+12 20-AUG-10
10 1 182405 104857600 2 YES ACTIVE 8.2671E+12 20-AUG-10
11 1 182406 104857600 2 YES ACTIVE 8.2671E+12 20-AUG-10
I have some problem in my server at several day, database's performance going to slow where big process with big data started.
this is the information that i can give:
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ---------
1 1 182408 104857600 2 YES ACTIVE 8.2671E+12 20-AUG-10
2 1 182409 104857600 2 NO CURRENT 8.2671E+12 20-AUG-10
3 1 182398 104857600 2 YES ACTIVE 8.2671E+12 20-AUG-10
4 1 182399 104857600 2 YES ACTIVE 8.2671E+12 20-AUG-10
5 1 182400 104857600 2 YES ACTIVE 8.2671E+12 20-AUG-10
6 1 182401 104857600 2 YES ACTIVE 8.2671E+12 20-AUG-10
7 1 182402 104857600 2 YES ACTIVE 8.2671E+12 20-AUG-10
8 1 182403 104857600 2 YES ACTIVE 8.2671E+12 20-AUG-10
9 1 182404 104857600 2 YES ACTIVE 8.2671E+12 20-AUG-10
10 1 182405 104857600 2 YES ACTIVE 8.2671E+12 20-AUG-10
11 1 182406 104857600 2 YES ACTIVE 8.2671E+12 20-AUG-10
0