02-09-2012
From the data you provided so far, you have 1 raidset raid 10 from SAS (so internal storage) disks of a total of 1 TB (presented to the system as 1 disk) for 6 DBs and anything else running on the system excluding root - this just asks for problems as you access all your storage just with one serial path.
Even worse all your filesystems are sharing the same logfile and if I assume correctly and your filesystems are not mounted with noatime option that means that every single read (which includes as simple things as ls) and every single write of 8 different filesystems concur about access to the logfile which by nature makes this logfile naturally the hotspot of the entire system.
Still waiting for the vmstat outputs but I bet that your system has only the default filesystem tuning and is running out of buffers most of the time.
Can you post lvmo -a -v oravg output please to confirm?
Regarding aio - dont worry - on AIX 6.1 you find it with the ioo -a | grep aio command but AIX will turn it on automatically if oracle or any other application wants to use it.
filesystem_io_options is a variable set within oracle (ask your DBA) and can be set to none (standard I think in your oracle version), async or setall - the setall option lets decide oracle to use cio with async IO but wont let you access open database files outside of the database itself other than with rman which might be a problem if you dont do rman backups.
Please run a simple mount on the box to allow us to see if you are using any mount options on the filesystems.
So far
- consider to give each of your oravg filesystems its very own logfile
- consider another storage solution and a different filesystem layout if possible since 6 DBs in the same filesystem - even if this filesystem has its own logfile, are still not such a great idea. If that is not possible, than your disk will naturally stay busy since you only have one.
Regards
zxmaus
9 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
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
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
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
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
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
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
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
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
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
LEARN ABOUT ULTRIX
ypserv
ypserv(8yp) ypserv(8yp)
Name
ypserv, ypbind - yellow pages (YP) server and binder processes
Syntax
/usr/etc/ypserv
/etc/ypbind [ -S domainname, servername1,servername2... ][ -X ]
Description
The yellow pages (YP) service provides a network lookup service consisting of databases and processes. The databases are files stored in
the directory. These files are described in The processes are the YP database lookup server, and the YP binder. The software interface to
the YP service is described in Administrative tools are described in and Tools to see the contents of YP maps are described in and Database
generation and maintenance tools are described in and
Both and are daemon processes activated at system startup time from The command runs only on a YP server machine with a complete YP data-
base. The command runs on all machines using YP services, both YP servers and clients.
The daemon's primary function is to look up information in its local database of YP maps. The operations performed by are defined for the
programmer in the header file
Communication with is by means of RPC calls. Lookup functions are described in and are supplied as C-callable functions in
There are four lookup functions, all of which are performed on a specified map within a YP domain: and The operation takes a key, and
returns the associated value. The operation returns the first key-value pair from the map, and the operation returns the remaining key-
value pairs. The operation ships the entire map to the requester.
Two other functions supply information about the map, rather than the map entries: and Both the order number and the master name exist in
the map as key-value pairs, but the server will not return either through the usual lookup functions. If the map is examined with however,
they are visible.
Other functions are used within the YP subsystem itself, and are not of general interest to YP clients. They include the the and the func-
tions.
The purpose of the function is to remember information that lets client processes on a single node communicate with a process. The func-
tion must run on every machine that has YP client service requirements. The function must be started through an entry in the file.
The information remembers is called a binding, the association of a domain name with the internet address of the YP server, and the port on
that host at which the process is listening for service requests. The process of binding is driven by client requests. As a request for
an unbound domain comes in, the process broadcasts on the net trying to find a process that serves maps within that domain. Since the
binding is established by broadcasting, there must be at least one process on every net. Once a domain is bound by a particular that same
binding is given to every client process on the node. The process on the local node or a remote node may be queried for the binding of a
particular domain by using the command.
Bindings are verified before they are given out to a client process. If is unable to speak to the process it is bound to, it marks the
domain as unbound, tells the client process that the domain is unbound, and tries to bind the domain once again. Requests received for an
unbound domain will fail immediately. In general, a bound domain is marked as unbound when the node running crashes or gets overloaded.
When the node gets overloaded, will try to bind any YP server (typically one that is less-heavily loaded) available on the net.
The process also accepts requests to set its binding for a particular domain. The request is usually generated by the YP subsystem itself.
Options
-S Allows the system administrator to lock to a particular domain and set of servers. Up to four servers can be specified as fol-
lows:
/etc/ypbind -S domainname,server1,server2,server3,server4
Note that there can not be any spaces around the commas in the command line. The option ensures that this system only binds to
the specified domain and to one of the specified servers. The servers used with the option must have entries in the local file.
-X The initial bind ( option forces to bind to a YP server at the time that the command is executed, instead of waiting until YP is
used. If no server is available at this time, will try for several minutes and then exit. Normally, is executed at boot time.
The option enables a system that does not exclusively depend on YP to boot and to allow logins when there are no YP servers
available. Without this option, such a system hangs.
Files
If the file exists when starts up, log information is written to when error conditions occur.
See Also
ypcat(1yp), ypmatch(1yp), ypwhich(1yp), ypclnt(3yp), ypfiles(5yp), yppush(8yp), ypxfr(8yp)
Guide to the Yellow Pages Service
ypserv(8yp)