Home » RDBMS Server » Performance Tuning » Wrong REDO log file location (Oracle 10G, Solaris 10)
icon4.gif  Wrong REDO log file location [message #496202] Fri, 25 February 2011 04:03 Go to next message
Tlg13team
Messages: 95
Registered: June 2008
Location: MGL
Member
hi all,

I try to current redo log file location to multiplex redo log configuration. I did do this on the DB.

I import a backup file to DB when I made this change, but its too slow running import process from old configuration. Approximately it is 4 times slow.

when I recovery old configuration for redo log file, import process is normal running!

Why this changes hit to DB import process performance?
Someone tell me what is wrong I do?


The old redo log file location is below:
GROUP#	MEMBER	BYTES
4	"/crtest1/oradata/redo04a.log"	524288000
4	"/crtest1/oradata/redo04b.log"	524288000
3	"/crtest1/oradata/redo03a.log"	524288000
3	"/crtest1/oradata/redo03b.log"	524288000
2	"/crtest1/oradata/redo02a.log"	524288000
2	"/crtest1/oradata/redo02b.log"	524288000
1	"/crtest1/oradata/redo01a.log"	524288000
1	"/crtest1/oradata/redo01b.log"	524288000


The new multiplex redo log file location is below:
GROUP#	MEMBER	BYTES
4	"/crtest1/oradata/redo04a.log"	524288000
4	"/opt/redolog/redo04b.log"	524288000
3	"/opt/redolog/redo03a.log"	524288000
3	"/usr/redolog/redo03b.log"	524288000
2	"/usr/redolog/redo02a.log"	524288000
2	"/disk1/redolog/redo02b.log"	524288000
1	"/disk1/redolog/redo01a.log"	524288000
1	"/crtest1/oradata/redo01b.log"	524288000


I think that new configuration is better for old configuration at security issue.


Here is the disk partitions on the server:



-bash-3.00$ df -lh
Filesystem             size   used  avail capacity  Mounted on
/dev/dsk/c0t0d0s0      9.6G   2.2G   7.3G    23%    /
/devices                 0K     0K     0K     0%    /devices
ctfs                     0K     0K     0K     0%    /system/contract
proc                     0K     0K     0K     0%    /proc
mnttab                   0K     0K     0K     0%    /etc/mnttab
swap                   6.6G   1.6M   6.5G     1%    /etc/svc/volatile
objfs                    0K     0K     0K     0%    /system/object
sharefs                  0K     0K     0K     0%    /etc/dfs/sharetab
/dev/dsk/c0t0d0s6      9.6G   4.1G   5.4G    44%    /usr
fd                       0K     0K     0K     0%    /dev/fd
/dev/dsk/c0t0d0s3       14G    13G   1.7G    88%    /var
swap                   6.5G   112K   6.5G     1%    /tmp
swap                   6.5G    88K   6.5G     1%    /var/run
/dev/dsk/c1t203200A    100G   60G    20G    70%    /crtest1
/dev/dsk/c0t1d0s6       67G    28G    39G    42%    /disk1
/dev/dsk/c0t0d0s5       14G  1019M    13G     7%    /opt
/dev/dsk/c0t0d0s7       12G   1.9G   9.9G    17%    /export/home
/dev/dsk/c0t0d0s1      6.7G   522M   6.2G     8%    /usr/openwi

Re: Wrong REDO log file location [message #496208 is a reply to message #496202] Fri, 25 February 2011 04:29 Go to previous messageGo to next message
wkk1020
Messages: 10
Registered: January 2008
Location: Singapore
Junior Member

Hi there, in this case, maybe the I/O for following file systems
are much slower than the original location (/crtest1): -

- /opt
- /usr
- /disk1

Regards,
Mike Yeap
Re: Wrong REDO log file location [message #496215 is a reply to message #496208] Fri, 25 February 2011 04:54 Go to previous messageGo to next message
Michel Cadot
Messages: 59775
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you spread IO on more disks it is much likely that you will have better performances.

Regards
Michel
Re: Wrong REDO log file location [message #496250 is a reply to message #496208] Fri, 25 February 2011 09:30 Go to previous messageGo to next message
Tlg13team
Messages: 95
Registered: June 2008
Location: MGL
Member
hi Mike Yeap,

/crtest1 location is storage box disk.

/opt, /usr, /disk1 is internal hard disks in the Server.

The Server is connect to storage box via fiber optic cable.

I think that maybe internal hard disk in the Server and storage box hard disk I/O speed is different. it's impact the performance.
Re: Wrong REDO log file location [message #496290 is a reply to message #496250] Fri, 25 February 2011 20:43 Go to previous message
wkk1020
Messages: 10
Registered: January 2008
Location: Singapore
Junior Member

Hi there, yup the storage box disk obviously surpass the internal hard disks in terms of performance.

Regards,
Mike Yeap
Previous Topic: help to wrire the procedure
Next Topic: faster processing of records needed: performance isue
Goto Forum:
  


Current Time: Tue Nov 25 19:53:50 CST 2014

Total time taken to generate the page: 0.12461 seconds