hi !! gurus,
we have a production system which runs on oracle 7.
the database runs in archivelog mode and the average time in creation of new archived file is around 2 min.
does this means that archiver processess remains alwayus busy with the archiving. and there is to many log switches. the system is hybride one.
-rw-r----- 1 oracle7 dba 512512 Jun 30 11:07 arch.log1_178245.dbf
-rw-r----- 1 oracle7 dba 512512 Jun 30 10:54 arch.log1_178244.dbf
-rw-r----- 1 oracle7 dba 512512 Jun 30 10:54 arch.log1_178243.dbf
-rw-r----- 1 oracle7 dba 512512 Jun 30 10:48 arch.log1_178242.dbf
-rw-r----- 1 oracle7 dba 512512 Jun 30 10:47 arch.log1_178241.dbf
-rw-r----- 1 oracle7 dba 512512 Jun 30 10:46 arch.log1_178240.dbf
-rw-r----- 1 oracle7 dba 512512 Jun 30 10:45 arch.log1_178239.dbf
-rw-r----- 1 oracle7 dba 512512 Jun 30 10:45 arch.log1_178238.dbf
-rw-r----- 1 oracle7 dba 512512 Jun 30 10:44 arch.log1_178237.dbf
-rw-r----- 1 oracle7 dba 512512 Jun 30 10:43 arch.log1_178236.dbf
-rw-r----- 1 oracle7 dba 512512 Jun 30 10:32 arch.log1_178235.dbf
-rw-r----- 1 oracle7 dba 512512 Jun 30 10:32 arch.log1_178234.dbf
-rw-r----- 1 oracle7 dba 512512 Jun 30 10:25 arch.log1_178233.dbf

any suggesations

TIA
ravi


____________________________________________________
Buy Feng Shui Package for Rs. 151/- only, at http://shopping.rediff.com/shopping/fengshui_mailer.htm



Oracle LazyDBA home page