Oracle Database Discussions

Hi all,

11.2.0.1

Aix 6.1

desc v$archived_log

Name                  Null Type         

--------------------- ---- -------------

RECID                      NUMBER       

STAMP                      NUMBER       

NAME                       VARCHAR2(257)

DEST_ID                    NUMBER       

THREAD#                    NUMBER       

SEQUENCE#                  NUMBER       

RESETLOGS_CHANGE#          NUMBER       

RESETLOGS_TIME             DATE         

RESETLOGS_ID               NUMBER       

FIRST_CHANGE#              NUMBER       

FIRST_TIME                 DATE         

NEXT_CHANGE#               NUMBER       

NEXT_TIME                  DATE         

BLOCKS                     NUMBER       

BLOCK_SIZE                 NUMBER       

CREATOR                    VARCHAR2(7)  

REGISTRAR                  VARCHAR2(7)  

STANDBY_DEST               VARCHAR2(3)  

ARCHIVED                   VARCHAR2(3)  

APPLIED                    VARCHAR2(9)  

DELETED                    VARCHAR2(3)  

STATUS                     VARCHAR2(1)  

COMPLETION_TIME            DATE         

DICTIONARY_BEGIN           VARCHAR2(3)  

DICTIONARY_END             VARCHAR2(3)  

END_OF_REDO                VARCHAR2(3)  

BACKUP_COUNT               NUMBER       

ARCHIVAL_THREAD#           NUMBER       

ACTIVATION#                NUMBER       

IS_RECOVERY_DEST_FILE      VARCHAR2(3)  

COMPRESSED                 VARCHAR2(3)  

FAL                        VARCHAR2(3)  

END_OF_REDO_TYPE           VARCHAR2(10) 

BACKED_BY_VSS              VARCHAR2(3)  

Can you help me to query how much achivelogs or redologs generated per hour based on the table above?

I want to report to my boss why we have days where the database is slow. I will give her comparison that this slow day have lots of transaction updates.

Assuming that our app doesnt have inquiries.

Thanks a lot,

pK