Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Poor Performance of server
Operating Systems AIX Poor Performance of server Post 302596998 by guzzelle on Thursday 9th of February 2012 12:12:12 AM
Old 02-09-2012
Thanks Zaxxon & zxmaus,
I don't know where to begin before this thread opened.

For iostat -A 2 10, vmstat -wt 2 10, vmstat -v and vmstat -s, I will post a snapshot for these once the issue occurs again.

For lsattr -El aio0, i did't get anything so i tried lsattr -El sys0 (i hope it will do).
--> See attachment - lsattr sys0.jpg

For "Do you use asynchronous I/O (AIO) and have it tuned?"
--> I have no idea for this since I am new here and I came here in the middle of the application roll-out to production. I wish I had a clue. No knowledge on the history of the servers here.
However i checked the I/O stat in nmon and here it is:
-->
Code:
Total AIO processes=  72 Actually in use=   0  CPU used=   1.1%
         All time peak=  90     Recent peak=   7      Peak=   3.4%

If physical disk or LUN from SAN
-->Im not entirely sure if it's LUN from SAN but here's what i gathered:
from prtcfg/lsdev:
Code:
hdisk8     Available 05-00-00    SAS RAID 10 Disk Array
from lspv hdisk8
PHYSICAL VOLUME:    hdisk8                   VOLUME GROUP:     oravg
PV IDENTIFIER:      00f678f86bb5b458 VG IDENTIFIER     00f678f800004c00000001326bb5b750
PV STATE:           active
STALE PARTITIONS:   0                        ALLOCATABLE:      yes
PP SIZE:            256 megabyte(s)          LOGICAL VOLUMES:  8
TOTAL PPs:          4228 (1082368 megabytes) VG DESCRIPTORS:   2
FREE PPs:           68 (17408 megabytes)     HOT SPARE:        no
USED PPs:           4160 (1064960 megabytes) MAX REQUEST:      256 kilobytes
FREE DISTRIBUTION:  00..00..00..00..68
USED DISTRIBUTION:  846..846..845..845..778
MIRROR POOL:        None

For oracle version:
-->Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi

For disk layout/fs setup:

-->In sumarry we have three hdisks. rootvg resides in 2 hdisk and applications(oravg) resides in hdisk8.
Below are the details:
Code:
lspv
hdisk0          00f678f866fa237c                    rootvg          active
hdisk1          00f678f86b3707b7                    rootvg          active
hdisk8          00f678f86bb5b458                    oravg           active

lsvg -l oravg
oravg:
LV NAME             TYPE       LPs     PPs     PVs  LV STATE      MOUNT POINT
loglv00             jfs2log    1       1       1    open/syncd    N/A
fslv00              jfs2       210     210     1    open/syncd    /u01
fslv01              jfs2       391     391     1    open/syncd    /bankadm
fslv02              jfs2       200     200     1    open/syncd    /smeadm
fslv03              jfs2       200     200     1    open/syncd    /infosys
fslv04              jfs2       1758    1758    1    open/syncd    /uatadm1
fslv05              jfs2       600     600     1    open/syncd    /uatadm2
fslv06              jfs2       800     800     1    open/syncd    /DB_Backups

there are several oracle database instances in oravg also. here they are:
Code:
/u01/oracle/oracle/dbs
# ls -lrt *.ora
-rwxr-xr-x    1 oracle   oinstall       8385 Sep 12 1998  init.ora
-rw-r--r--    1 oracle   oinstall      12920 May 03 2001  initdw.ora
-rw-r-----    1 oracle   oinstall        922 Sep 16 09:54 initorcl.ora
-rw-r-----    1 oracle   oinstall       3584 Sep 16 10:15 spfileorcl.ora
-rw-rw-r--    1 oracle   oinstall       5149 Oct 17 02:07 initU1SISDB.ora
-rw-rw-r--    1 oracle   oinstall       5176 Oct 17 02:15 initUASISDB.ora
-rw-rw-r--    1 oracle   oinstall       5172 Feb 05 00:40 initBANKDB.ora
-rw-rw-r--    1 oracle   oinstall       5161 Feb 05 00:40 initSMEDB.ora
-rw-rw-r--    1 oracle   oinstall       5172 Feb 05 00:40 initUAT1DB.ora
-rw-rw-r--    1 oracle   oinstall       5174 Feb 05 00:41 initUAT2DB.ora

for filesystemio_options:
-->I have no idea where to locate this? is this executed or set in a configuration file?

for "...min or max distribution, blocksize ...
output of mount command will help and definitely mounting your oracle filesystems with noatime option and if you have a dedicated dump device with rbrw..."
--> I am totally alost with the min/max tuning. no idea for this yet.


Again. Thanks very much for the help. It's greatly appreciated
Poor Performance of server-lsattr-sys0jpg
Last edited by zxmaus; 02-10-2012 at 08:26 AM.. Reason: added tags
 

9 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Samba on E3500 Poor Performance!!!

Hi you all, I have a BIG performance problem on an Sun E3500, the scenario is described below: I have several users (30) accessing via samba to the E3500 using an application built on Visual Foxpro from their Windows PC , the problem is that the first guy that logs in demands 30% of the E3500... (2 Replies)
Discussion started by: alex blanco
2 Replies

2. Filesystems, Disks and Memory

Poor read performance on sun storedge a1000

Hello, i have a a1000 connected to an e6500. There's a raid 10 (12 disks) on the a1000. If i do a dd if=/dev/zero of=/mnt/1 bs=1024k count=1000 and then look at iostat it tells me there's a kw/s of 25000. But if i do a dd of=/dev/zero if=/mnt/1 bs=1024k count=1000 then i see only a... (1 Reply)
Discussion started by: mbrenner
1 Replies

3. UNIX for Dummies Questions & Answers

poor performance processing file with awk

Hello, I'm running a script on AIX to process lines in a file. I need to enclose the second column in quotation marks and write each line to a new file. I've come up with the following: #!/bin/ksh filename=$1 exec >> $filename.new cat $filename | while read LINE do echo $LINE | awk... (2 Replies)
Discussion started by: scooter53080
2 Replies

4. UNIX for Advanced & Expert Users

HW Raid poor io performance

Hello all We just built a storage cluster for our new xenserver farm. Using 3ware 9650SE raid controllers with 8 x 1TB WD sata disks in a raid 5, 256KB stripe size. While making first performance test on the local storage server using dd (which simulates the read/write access to the disk... (1 Reply)
Discussion started by: roli8200
1 Replies

5. Solaris

Poor Disk performance on ZFS

Hello, we have a machine with Solaris Express 11, 2 LSI 9211 8i SAS 2 controllers (multipath to disks), multiport backplane, 16 Seagate Cheetah 15K RPM disks. Each disk has a sequential performance of 220/230 MB/s and in fact if I do a dd if=/dev/zero of=/dev/rdsk/<diskID_1> bs=1024k... (1 Reply)
Discussion started by: golemico
1 Replies

6. Solaris

Poor disk performance however no sign of failure

Hello guys, I have two servers performing the same disk operations. I believe one server is having a disk's impending failure however I have no hard evidence to prove it. This is a pair of Netra 210's with 2 drives in a hardware raid mirror (LSI raid controller). While performing intensive... (4 Replies)
Discussion started by: s ladd
4 Replies

7. Solaris

Poor performance on an M3000

Hi We have an M3000 single physical processor and 8gb of memory running Solaris 10. This system runs two Oracle Databases one on Oracle 9i and One on Oracle 10g. As soon as the Oracle 10g database starts we see an immediate drop in system performance, for example opening an ssh session can... (6 Replies)
Discussion started by: gregsih
6 Replies

8. AIX

ISCSI poor performance 1.5MB/s fresh install AIX7.1

Hi Everyone, I have been struggling for few days with iSCSI and thought I could get some help on the forum... fresh install of AIX7.1 TL4 on Power 710, The rootvg relies on 3 SAS disks in RAID 0, 32GB Memory The lpar Profile is using all of the managed system's resources. I have connected... (11 Replies)
Discussion started by: frenchy59
11 Replies

9. Windows & DOS: Issues & Discussions

Poor Windows 10 Performance of Parallels Desktop 15 on macOS Catalina

Just a quick note for macOS users. I just installed (and removed) Parallels Desktop 15 Edition on my MacPro (2013) with 64GB memory and 12-cores, which is running the latest version of macOS Catalina as of this post. The reason for this install was to test some RIGOL test gear software which... (6 Replies)
Discussion started by: Neo
6 Replies
All times are GMT -4. The time now is 02:55 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy