Database Administration (MOSC)

MOSC Banner

Database Performance Drop

edited Oct 26, 2010 3:50AM in Database Administration (MOSC) 21 commentsAnswered
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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center