Sponsored Content
Top Forums UNIX for Advanced & Expert Users raid 0+1 +oracle getting slow data reads. Post 35944 by Optimus_P on Wednesday 14th of May 2003 03:18:34 PM
Old 05-14-2003
Code:
set shmsys:shminfo_shmmax=2147483648
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=100
set shmsys:shminfo_shmseg=10
set semsys:seminfo_semmns=830
set semsys:seminfo_semmni=100
set semsys:seminfo_semmsl=210
set semsys:seminfo_semopm=100
set semsys:seminfo_semvmx=32767
* Begin MDD root info (do not edit)
forceload: misc/md_trans
forceload: misc/md_raid
forceload: misc/md_hotspares
forceload: misc/md_stripe
forceload: misc/md_mirror
forceload: drv/sbus
forceload: drv/isp
forceload: drv/sd
rootdev:/pseudo/md@0:0,12,blk
* End MDD root info (do not edit)
* Begin MDD database info (do not edit)
set md:mddb_bootlist1="sd:14:16 sd:14:1050 sd:14:2084 sd:22:16 sd:22:1050"
set md:mddb_bootlist2="sd:22:2084 sd:62:16 sd:62:1050 sd:62:2084 sd:70:16"
set md:mddb_bootlist3="sd:70:1050 sd:70:2084 sd:6:16 sd:6:1050 sd:126:16"
set md:mddb_bootlist4="sd:126:1050 sd:134:16 sd:134:1050 sd:134:2084"
set md:mddb_bootlist5="sd:142:16 sd:142:1050 sd:142:2084 sd:182:16"
set md:mddb_bootlist6="sd:182:1050 sd:182:2084 sd:190:16 sd:190:1050"
set md:mddb_bootlist7="sd:190:2084"
* End MDD database info (do not edit)

unfortunetly our oracle dba is pretty demanding that it is not the db but the system.

the dba said he is not seeing any errors in his logs.
there is only 1 db running. all users connect remotely thru a software package (i2 which is a transportaion software suite)

i cant disagree but i cant agree either.

i truly wish i could just test differant parm's but alas it is a prod box that we were forced to use the current versions of software. and hardware does not look like a fesable idea in my future.
 

7 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Howto capture data from rs232port andpull data into oracle database-9i automatically

Hi, i willbe very much grateful to u if u help me out.. if i simply connect pbx machine to printer by serial port RS232 then we find this view: But i want to capture this data into database automatically when the pbx is running.The table in database will contain similar to this view inthe... (1 Reply)
Discussion started by: boss
1 Replies

2. Shell Programming and Scripting

Get data from 3 differrnt oracle DB & then compare data

Hi All, I have a requirement to write a shell script for the following... we have 3 different database.... lets say A, B, C From these 3 DBs, i need to get data.. all have 3 different table...a,b, c A.a => Emp_code, count(*) B.b => emp_code, count(*) C.c => emp_code, copunt(*) Once get this... (4 Replies)
Discussion started by: Amit.Sagpariya
4 Replies

3. Red Hat

Recover RAID data

Hello, Given a scenario, I have 2 HDD which were used on the server with software RAID. Now, the original server crashed and I have attached these 2 HDD to the new server. Any possible chances to recover the data from any of this HDD ? I want to mount /dev/sdb3 on some folder.. Output of... (3 Replies)
Discussion started by: chinmay
3 Replies

4. AIX

ORACLE Database running slow on AIX ( nmon / topas )

Hello, How can I know if ORACLE Database is running slow due to Memory or due to processing power ? I have only Oracle Database running on a P4 with 4GB RAM. Could anyone suggest any tools which can help me determine exactly if it is memory issue or processor issue. (43 Replies)
Discussion started by: filosophizer
43 Replies

5. AIX

SCSI PCI - X RAID Controller card RAID 5 AIX Disks disappeared

Hello, I have a scsi pci x raid controller card on which I had created a disk array of 3 disks when I type lspv ; I used to see 3 physical disks ( two local disks and one raid 5 disk ) suddenly the raid 5 disk array disappeared ; so the hardware engineer thought the problem was with SCSI... (0 Replies)
Discussion started by: filosophizer
0 Replies

6. UNIX for Dummies Questions & Answers

Difference between buffered disk reads and cached reads?

I was analyzing the Disk read using hdparm utility. This is what i got as a result. # hdparm -t /dev/sda /dev/sda: Timing buffered disk reads: 108 MB in 3.04 seconds = 35.51 MB/sec # hdparm -T /dev/sda /dev/sda: Timing cached reads: 3496 MB in 1.99 seconds = 1756.56 MB/sec... (1 Reply)
Discussion started by: pinga123
1 Replies

7. Red Hat

RAID Configuration for IBM Serveraid-7k SCSI RAID Controller

Hello, I want to delete a RAID configuration an old server has. Since i haven't the chance to work with the specific raid controller in the past can you please help me how to perform the configuraiton? I downloaded IBM ServeRAID Support CD but i wasn't able to configure the video card so i... (0 Replies)
Discussion started by: @dagio
0 Replies
md(7D)								      Devices								    md(7D)

NAME
md - user configurable pseudo device driver DESCRIPTION
md is a user configurable pseudo device driver that provides disk concatenation, striping, mirroring, RAID5 metadevices, trans metadevices, and hot spare utilities. Trans devices are no longer supported and have been replaced by UFS logging. See mount_ufs(1M). The block devices access the disk using the system's normal buffering mechanism and are read and written without regard to physical disk records. There is also a ``raw'' device which provides for direct transmission between the disk and the user's read or write buffer. A sin- gle read or write call usually results in one I/O operation; raw I/O is therefore considerably more efficient when many bytes are transmit- ted. The names of the block devices are found in /dev/md/dsk; the names of the raw devices are found in /dev/md/rdsk. Metadevices have the appearance of whole disks; there are no slices (partitions). I/O requests (such as lseek(2)) to the metadevices must have an offset that is a multiple of 512 bytes (DEV_BSIZE), or the driver returns an EINVAL error. If the transfer length is not a multiple of 512 bytes, the tranfer count is rounded up by the driver. The md pseudo device drivers support all disk devices on all Solaris 2.4 or later Solaris systems. IOCTLS
This section provides a list of the ioctls supported by the metadisk driver. The following ioctls are valid when issued to the raw metadevice, such as /dev/md/rdsk/d0. See dkio(7I) for additional information. DKIOCGGEOM This ioctl is used to get the disk geometry. The metadisk driver fills in the dkg_nhead, dkg_nsect, dkg_rpm, dkg_write_rein- struct and dkg_read_reinstruct from the first component of the metadevice (at metainit time). dkg_ncyl is calculated using the size of the metadevice (reported by metastat) divided by (dkg_nhead * dkg_nsect). The total size is always a multiple of (dkg_nhead * dkg_nsect). If the first component of a metadevice does not start on cylinder number 0, then the dkg_ncyl is increased by one cylinder; because DKIOCGVTOC reports the metadevice as starting on cylinder 1. The side effect here is that it looks like cylinder 0 is not being used, but all the arithmetic works out correctly. If the metadevice is not set up, then ENXIO is returned. DKIOCINFO When issued to the administrative device or metadevice, this ioctl sets dki_unit to the unit number of the metadevice, dki_ctype to a value of DKC_MD, and dki_partition to 0, because there are no slices. DKIOCGVTOC This ioctl returns the current vtoc. If one has not been written, then a default vtoc is returned. v_nparts is always 1. v_part[0].p_start is 0 if the first component of the metadevice starts on cylinder 0. Otherwise, the p_start field is the starting sector of cylinder 1. v_part[0].p_size is the same as the total size reported by metastat. DKIOCSVTOC This ioctl stores the vtoc in the metadevice state database so it is persistent across reboots. DIAGNOSTICS
Notice Log Messages The informative log messages include: md: dnum: Hotspared device dev with dev The first device name listed has been hot spare replaced with the second device name listed. md: dnum: Hotspared device dev(num,num) with dev(num,num) The first device number listed has been hot spare replaced with the second device number listed. md: Could not load misc /dev The named misc module is not loadable. It is possibly missing, or something else has been copied over it. md: dnum: no mem for property dev Memory could not be allocated in the prop_op entry point. md: db: Parsing error on 'dev' Set command in /kernel/drv/md.conf for the mddb.bootlist <number> is not in the correct format. metadb -p can be run to put the correct set commands into the /kernel/drv/md.conf file. md: dnum: dev(num,num) needs maintenance md: dnum: dev needs maintenance An I/O or open error has occurred on a device within a mirror causing a component in the mirror to change to the Maintenance state. md: dnum: dev(num,num) last erred md: dnum: dev last erred An I/O or open error has occurred on a device within a mirror and the data is not replicated elsewhere in the mirror. This is causing the component in the mirror to change to the Last Erred state. Warning Log Messages The warning log messages include: md: State database is stale This error message comes when there are not enough usable replicas for the state database to be able to update records in the database. All accesses to the metadevice driver will fail. To fix this problem, more replicas need to be added or inaccessible replicas need to be deleted. md: dnum: read error on devmd: dnum: write error on dev A read or write error has occurred on the specified submirror, at the specified device name. This happens if any read or write errors occur on a submirror. md: dnum: read error on dev(num,num)md: dnum: write error on dev( num,num) A read or write error has occurred on the specified submirror, at the specified device number. This happens if any read or write errors occur on a submirror. md: State database commit failed md: State database delete failed These messages occur when there have been device errors on components where the state database replicas reside. These errors only occur when more than half of the replicas have had device errors returned to them. For instance, if you have three components with state database replicas and two of the components report errors, then these errors may occur. The state database commit or delete is retried periodically. If a replica is added, then the commit or delete will finish and the system will be operational. Otherwise the system will timeout and panic. md: dnum: Cannot load dev driver Underlying named driver module is not loadable (for example, sd, id, xy, or a third-party driver). This could indicate that the driver mod- ule has been removed. md: Open error of hotspare devmd: Open error of hotspare dev(num,num) Named hotspare is not openable, or underlying driver is not loadable. Panic Log Messages The panic log messages include: md: dnum: Unknown close typemd: dnum: Unknown open type Metadevice is being opened/closed with an unknown open type (OTYP). md: State database problem Failed metadevice state database commit or delete has been retried the default 100 times. FILES
/dev/md/dsk/dn block device (where n is the device number) /dev/md/rdsk/dn raw device (where n is the device number) /dev/md/setname/dsk/dn block device (where setname is the name of the diskset and n is the device number) /dev/md/setname/rdsk/dn raw device (where setname is the name of the diskset and n is the device number) /dev/md/admin administrative device /kernel/drv/md driver module /kernel/drv/md.conf driver configuration file /kernel/misc/md_stripe stripe driver misc module /kernel/misc/md_mirror mirror driver misc module /kernel/misc/md_hotspares hotspares driver misc module /kernel/misc/md_trans metatrans driver for UFS logging /kernel/misc/md_raid RAID5 driver misc module SEE ALSO
mdmonitord(1M), metaclear(1M), metadb(1M), metadetach(1M), metahs(1M), metainit(1M), metaoffline(1M), metaonline(1M), metaparam(1M), metarecover(1M), metarename(1M), metareplace(1M), metaroot(1M), metassist(1M), metaset(1M), metastat(1M), metasync(1M), metattach(1M), md.cf(4), md.tab(4), attributes(5), Solaris Volume Manager Administration Guide NOTES
Trans metadevices have been replaced by UFS logging. Existing trans devices are not logging--they pass data directly through to the under- lying device. See mount_ufs(1M) for more information about UFS logging. SunOS 5.11 29 Aug 2003 md(7D)
All times are GMT -4. The time now is 09:56 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy