Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: performance problems after increasing redolog size

Re: performance problems after increasing redolog size

From: Bud Socks <bud_socks_at_gmx.de>
Date: Thu, 6 Mar 2003 13:14:09 +0100
Message-ID: <b47e2h$1t3puv$1@ID-2182.news.dfncis.de>


Hi there,

first of all thank you very much for the numerous messages.

Of course i owe you some more informations:

We have 4 Oracle 8.1.7 instances running on a single cpu (PIII750) Winnt4 machine with
1 GB ram.
There are two drives created on a raid level 5 (drive c:, d:). No other internal drives for e.g. raid 1 are available !!!!

All Oracle files including datafiles, redologs, archives and even the controlfiles are located
on drive d: !!!!!!
(don`t beat me - i know it's sheer lunacy! - but i have to administrate it
and did not set
it up that way)

The client application running on top is a "small" CRM-solution for a call-center !
Two of the oracle instances are the productive databases - that means each of it has its own
CRM application & call-center !

Both of them are having the archive mode & automatic archival enabled plus one more
test-database running in the same mode (but low/less user activations). The last database
is very infrequently visited - no archive mode enabled !

As i have taken over this machine there were just 3 redolog groups with just one 1MB member !
So far the archive mode was still disabled.

Almost frequently the client-server connection has gone lost - several times a week.

By having a view on the alertlog i noticed heavy logswitching. Therefore i decided to modify the redolog configuration as a first step on my troubleshooting path.
(due to sequrity/recovery issues i have enabled the archive mode as well)

2 times a week (not scheduled - just triggered by a user) an import from another host system is
started. The amount of datas do almost have the same size (thats what i was told).
As the redolog size was set to 1MB this import has taken two hours runtime. Now after the modification (4 members / 10MB each) the import takes more 24 hours.

Unfortunately i don`t have the init<sid>.ora available now - cause i´m not at work.

But please find below a part of the oracle alert log taken yesterday.

What problems do you see ?

By the way i have requested 2 hd`s to build up a raid1 to place all redologs on this logical disc - although
it is just a interim solution.

Thank you very much

Bud



ARC0: STARTING ARCH PROCESSES
ARC1 started with pid=13
Mon Mar 03 16:20:10 2003
ARC0: STARTING ARCH PROCESSES COMPLETE
Mon Mar 03 16:20:10 2003
ARC1: Archival started
Mon Mar 03 16:20:10 2003
ARC0: Beginning to archive log# 1 seq# 1874 Mon Mar 03 16:20:17 2003
Thread 1 advanced to log sequence 1876
  Current log# 3 seq# 1876 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO03.LOG Mon Mar 03 16:20:17 2003

ARC1: Beginning to archive log# 1 seq# 1874
ARC1: Failed to archive log# 1 seq# 1874
ARC1: Beginning to archive log# 2 seq# 1875
Mon Mar 03 16:20:18 2003
ARC0: Completed archiving log# 1 seq# 1874
ARC0: Beginning to archive log# 2 seq# 1875
ARC0: Failed to archive log# 2 seq# 1875
ARC0: Beginning to archive log# 2 seq# 1875
ARC0: Failed to archive log# 2 seq# 1875
Mon Mar 03 16:20:25 2003
ARC1: Completed archiving log# 2 seq# 1875 Mon Mar 03 16:20:28 2003
Thread 1 advanced to log sequence 1877
  Current log# 4 seq# 1877 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO04.LOG Mon Mar 03 16:20:28 2003
ARC0: Beginning to archive log# 3 seq# 1876 ARC0: Completed archiving log# 3 seq# 1876 Mon Mar 03 16:20:38 2003
Thread 1 advanced to log sequence 1878
  Current log# 1 seq# 1878 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO01.LOG Mon Mar 03 16:20:38 2003
ARC0: Beginning to archive log# 4 seq# 1877 ARC0: Completed archiving log# 4 seq# 1877 Mon Mar 03 16:20:48 2003
Thread 1 advanced to log sequence 1879
  Current log# 2 seq# 1879 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO02.LOG Mon Mar 03 16:20:48 2003
ARC0: Beginning to archive log# 1 seq# 1878 ARC0: Completed archiving log# 1 seq# 1878 Mon Mar 03 16:20:59 2003
Thread 1 advanced to log sequence 1880
  Current log# 3 seq# 1880 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO03.LOG Mon Mar 03 16:20:59 2003
ARC0: Beginning to archive log# 2 seq# 1879 ARC0: Completed archiving log# 2 seq# 1879 Mon Mar 03 16:28:37 2003
Thread 1 advanced to log sequence 1881
  Current log# 4 seq# 1881 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO04.LOG Mon Mar 03 16:28:37 2003
ARC0: Beginning to archive log# 3 seq# 1880 kccrsz: expanded controlfile section 11 from 13 to 27 records   requested to grow by 13 record(s); added 1 block(s) of records ARC0: Completed archiving log# 3 seq# 1880 Mon Mar 03 16:36:23 2003
Thread 1 advanced to log sequence 1882
  Current log# 1 seq# 1882 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO01.LOG Mon Mar 03 16:36:23 2003
ARC0: Beginning to archive log# 4 seq# 1881 ARC0: Completed archiving log# 4 seq# 1881 Mon Mar 03 16:44:13 2003
Thread 1 advanced to log sequence 1883
  Current log# 2 seq# 1883 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO02.LOG Mon Mar 03 16:44:13 2003
ARC0: Beginning to archive log# 1 seq# 1882 ARC0: Completed archiving log# 1 seq# 1882 Mon Mar 03 16:51:58 2003
Thread 1 advanced to log sequence 1884
  Current log# 3 seq# 1884 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO03.LOG Mon Mar 03 16:51:58 2003
ARC0: Beginning to archive log# 2 seq# 1883 ARC0: Completed archiving log# 2 seq# 1883 Mon Mar 03 16:59:51 2003
Thread 1 advanced to log sequence 1885
  Current log# 4 seq# 1885 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO04.LOG Mon Mar 03 16:59:51 2003
ARC0: Beginning to archive log# 3 seq# 1884 ARC0: Completed archiving log# 3 seq# 1884 Mon Mar 03 17:07:45 2003
Thread 1 advanced to log sequence 1886
  Current log# 1 seq# 1886 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO01.LOG Mon Mar 03 17:07:45 2003
ARC0: Beginning to archive log# 4 seq# 1885 ARC0: Completed archiving log# 4 seq# 1885 Mon Mar 03 17:15:41 2003
Thread 1 advanced to log sequence 1887
  Current log# 2 seq# 1887 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO02.LOG Mon Mar 03 17:15:41 2003
ARC0: Beginning to archive log# 1 seq# 1886 ARC0: Completed archiving log# 1 seq# 1886 Mon Mar 03 17:23:45 2003
Thread 1 advanced to log sequence 1888
  Current log# 3 seq# 1888 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO03.LOG Mon Mar 03 17:23:45 2003
ARC0: Beginning to archive log# 2 seq# 1887 ARC0: Completed archiving log# 2 seq# 1887 Mon Mar 03 17:31:49 2003
Thread 1 advanced to log sequence 1889
  Current log# 4 seq# 1889 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO04.LOG Mon Mar 03 17:31:49 2003
ARC0: Beginning to archive log# 3 seq# 1888 ARC0: Completed archiving log# 3 seq# 1888 Mon Mar 03 18:04:42 2003
Thread 1 advanced to log sequence 1890
  Current log# 1 seq# 1890 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO01.LOG Mon Mar 03 18:04:42 2003
ARC0: Beginning to archive log# 4 seq# 1889 ARC0: Completed archiving log# 4 seq# 1889 Mon Mar 03 19:19:24 2003
Thread 1 advanced to log sequence 1891
  Current log# 2 seq# 1891 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO02.LOG Mon Mar 03 19:19:24 2003
ARC0: Beginning to archive log# 1 seq# 1890 ARC0: Completed archiving log# 1 seq# 1890 Mon Mar 03 21:32:00 2003
Thread 1 advanced to log sequence 1892
  Current log# 3 seq# 1892 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO03.LOG Mon Mar 03 21:32:00 2003
ARC0: Beginning to archive log# 2 seq# 1891 ARC0: Completed archiving log# 2 seq# 1891 Tue Mar 04 00:48:08 2003
Thread 1 advanced to log sequence 1893
Tue Mar 04 00:48:08 2003
  Current log# 4 seq# 1893 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO04.LOG Tue Mar 04 00:48:08 2003
ARC0: Beginning to archive log# 3 seq# 1892 Tue Mar 04 00:48:10 2003
ARC0: Completed archiving log# 3 seq# 1892 Tue Mar 04 04:02:58 2003
Thread 1 advanced to log sequence 1894
  Current log# 1 seq# 1894 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO01.LOG Tue Mar 04 04:02:58 2003
ARC0: Beginning to archive log# 4 seq# 1893 ARC0: Completed archiving log# 4 seq# 1893 Tue Mar 04 06:59:34 2003
Thread 1 advanced to log sequence 1895
  Current log# 2 seq# 1895 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO02.LOG Tue Mar 04 06:59:34 2003
ARC0: Beginning to archive log# 1 seq# 1894 kccrsz: expanded controlfile section 11 from 27 to 55 records   requested to grow by 27 record(s); added 2 block(s) of records ARC0: Completed archiving log# 1 seq# 1894 Tue Mar 04 09:15:11 2003
Thread 1 advanced to log sequence 1896
  Current log# 3 seq# 1896 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO03.LOG Tue Mar 04 09:15:11 2003
ARC0: Beginning to archive log# 2 seq# 1895 ARC0: Completed archiving log# 2 seq# 1895 Tue Mar 04 10:20:12 2003
Thread 1 advanced to log sequence 1897
  Current log# 4 seq# 1897 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO04.LOG Tue Mar 04 10:20:12 2003
ARC0: Beginning to archive log# 3 seq# 1896 ARC0: Completed archiving log# 3 seq# 1896 Tue Mar 04 11:25:09 2003
Thread 1 advanced to log sequence 1898
  Current log# 1 seq# 1898 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO01.LOG Tue Mar 04 11:25:09 2003
ARC0: Beginning to archive log# 4 seq# 1897 ARC0: Completed archiving log# 4 seq# 1897 Tue Mar 04 12:27:36 2003
Thread 1 advanced to log sequence 1899
  Current log# 2 seq# 1899 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO02.LOG Tue Mar 04 12:27:36 2003
ARC0: Beginning to archive log# 1 seq# 1898 ARC0: Completed archiving log# 1 seq# 1898 Tue Mar 04 13:34:31 2003
Thread 1 advanced to log sequence 1900
  Current log# 3 seq# 1900 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO03.LOG Tue Mar 04 13:34:31 2003
ARC0: Beginning to archive log# 2 seq# 1899 ARC0: Completed archiving log# 2 seq# 1899 Tue Mar 04 14:42:30 2003
Thread 1 advanced to log sequence 1901
  Current log# 4 seq# 1901 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO04.LOG Tue Mar 04 14:42:30 2003
ARC0: Beginning to archive log# 3 seq# 1900 ARC0: Completed archiving log# 3 seq# 1900 Tue Mar 04 15:51:49 2003
Thread 1 advanced to log sequence 1902
  Current log# 1 seq# 1902 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO01.LOG Tue Mar 04 15:51:49 2003
ARC0: Beginning to archive log# 4 seq# 1901 ARC0: Completed archiving log# 4 seq# 1901 Tue Mar 04 17:20:59 2003
Thread 1 advanced to log sequence 1903
  Current log# 2 seq# 1903 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO02.LOG Tue Mar 04 17:20:59 2003
ARC0: Beginning to archive log# 1 seq# 1902 ARC0: Completed archiving log# 1 seq# 1902 Tue Mar 04 19:23:03 2003
Thread 1 advanced to log sequence 1904
  Current log# 3 seq# 1904 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO03.LOG Tue Mar 04 19:23:03 2003
ARC0: Beginning to archive log# 2 seq# 1903 ARC0: Completed archiving log# 2 seq# 1903 Tue Mar 04 22:13:02 2003
Thread 1 advanced to log sequence 1905
Tue Mar 04 22:13:02 2003
  Current log# 4 seq# 1905 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO04.LOG Tue Mar 04 22:13:04 2003
ARC0: Beginning to archive log# 3 seq# 1904 Tue Mar 04 22:13:13 2003
ARC0: Completed archiving log# 3 seq# 1904 Wed Mar 05 01:07:17 2003
Thread 1 advanced to log sequence 1906
  Current log# 1 seq# 1906 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO01.LOG Wed Mar 05 01:07:17 2003
ARC0: Beginning to archive log# 4 seq# 1905 ARC0: Completed archiving log# 4 seq# 1905 Wed Mar 05 04:03:23 2003
Thread 1 advanced to log sequence 1907
  Current log# 2 seq# 1907 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO02.LOG Wed Mar 05 04:03:23 2003
ARC0: Beginning to archive log# 1 seq# 1906 ARC0: Completed archiving log# 1 seq# 1906 Wed Mar 05 07:01:09 2003
Thread 1 advanced to log sequence 1908
  Current log# 3 seq# 1908 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO03.LOG Wed Mar 05 07:01:09 2003
ARC0: Beginning to archive log# 2 seq# 1907 ARC0: Completed archiving log# 2 seq# 1907 Wed Mar 05 09:44:03 2003
Thread 1 advanced to log sequence 1909
  Current log# 4 seq# 1909 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO04.LOG Wed Mar 05 09:44:03 2003
ARC0: Beginning to archive log# 3 seq# 1908 ARC0: Completed archiving log# 3 seq# 1908 Wed Mar 05 11:12:25 2003
Thread 1 advanced to log sequence 1910
  Current log# 1 seq# 1910 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO01.LOG Wed Mar 05 11:12:25 2003
ARC0: Beginning to archive log# 4 seq# 1909 ARC0: Completed archiving log# 4 seq# 1909 Wed Mar 05 11:16:21 2003
Thread 1 advanced to log sequence 1911
  Current log# 2 seq# 1911 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO02.LOG Wed Mar 05 11:16:21 2003
ARC0: Beginning to archive log# 1 seq# 1910 ARC0: Completed archiving log# 1 seq# 1910 Wed Mar 05 11:16:32 2003
Thread 1 advanced to log sequence 1912
  Current log# 3 seq# 1912 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO03.LOG Wed Mar 05 11:16:33 2003
ARC0: Beginning to archive log# 2 seq# 1911 ARC0: Completed archiving log# 2 seq# 1911 Wed Mar 05 11:16:43 2003
Thread 1 advanced to log sequence 1913
  Current log# 4 seq# 1913 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO04.LOG Wed Mar 05 11:16:43 2003
ARC0: Beginning to archive log# 3 seq# 1912 ARC0: Completed archiving log# 3 seq# 1912 Wed Mar 05 11:16:54 2003
Thread 1 advanced to log sequence 1914
  Current log# 1 seq# 1914 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO01.LOG Wed Mar 05 11:16:55 2003
ARC0: Beginning to archive log# 4 seq# 1913 ARC0: Completed archiving log# 4 seq# 1913 Wed Mar 05 11:17:05 2003
Thread 1 advanced to log sequence 1915
  Current log# 2 seq# 1915 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO02.LOG Wed Mar 05 11:17:05 2003
ARC0: Beginning to archive log# 1 seq# 1914 ARC0: Completed archiving log# 1 seq# 1914 Wed Mar 05 11:17:17 2003
Thread 1 advanced to log sequence 1916
  Current log# 3 seq# 1916 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO03.LOG Wed Mar 05 11:17:17 2003
ARC0: Beginning to archive log# 2 seq# 1915 ARC0: Completed archiving log# 2 seq# 1915 Wed Mar 05 11:44:40 2003
Thread 1 advanced to log sequence 1917
  Current log# 4 seq# 1917 mem# 0: D:\ORACLE\ORADATA\XYZ\REDO04.LOG Wed Mar 05 11:44:40 2003
ARC0: Beginning to archive log# 3 seq# 1916 ARC0: Completed archiving log# 3 seq# 1916 Received on Thu Mar 06 2003 - 06:14:09 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US