similar to: ZFS and Oracle asynchronous I/O

Hi All, We are currently in the process of testing Solaris 10 with ZFS and Oracle and are running it on a T2000. When checking performance statistics on the T2000, we notice that only one thread of the CPU appears to be doing any of the processing. Leaving all other threads seemingly idle. Are there any tuning parameters that need to be set or changed when running Oracle on T2000 using

Hi all, Is there some documentation or some example on how to interpret the arg0 .. arg<n> for the aioread, aiowrite, aiowait syscalls? The system call name for all three seems to be "kaio". Michael === Michael Mueller ================== Tel. + 49 8171 63600 Fax. + 49 8171 63615 Web: http://www.michael-mueller-it.de ======================================

We used rsync 2.6.3 on a couple of Solaris 8 machines to update an Oracle database from one machine to another. Here is the procedure I used: The source database was up and running so this operation was similar to doing a hot backup. I queried the source database for a list of tablespace names, and for each tablespace, I queried the list of datafiles. I put the tablespace in hot backup mode,

an ocfs-volume was nearly full (only 800MB free). i deleted some datafiles to free space: $ df -h . Filesystem Size Used Avail Use% Mounted on /dev/sdp1 10G 5.3G 4.8G 53% /db/DPS so there are more than 4GB available. $ sqlplus /nolog SQL*Plus: Release 9.2.0.4.0 - Production on Wed Sep 1 12:57:48 2004 Copyright (c) 1982, 2002, Oracle Corporation. All rights

Hi All, we´re currently running an Oracle DB un SuSE 7.2 with kernel 2.2.19 and 0.0.7b ext3 Patch. Do you have any recommendations for maximum performance with the Database? Tablespace Sizes are about 15 GB User, 10 GB Temp. Main Operation of DB is reporting (index load, table scan, arithmetic operations). Which mount option should be best (concerning performance)? Hints welcome. -- Christian

Hi all, I curently have a big problem. One request (listed above) using context take up to 1000 more time than the on RAW or ext2 database. I have ran this request on a single IA32 machine with Redhat and dbf on ext2. The average reponse time is less than a sec. The same request on RAC 4 nodes cluster on RAW take the same average time. On ext2 idem. But on OCFS it took up to 15 sec randomly

Hi all, I curently have a big problem. One request (listed above) using context take up to 1000 more time than the on RAW or ext2 database. I have ran this request on a single IA32 machine with Redhat and dbf on ext2. The average reponse time is less than a sec. The same request on RAC 4 nodes cluster on RAW take the same average time. On ext2 idem. But on OCFS it took up to 15 sec randomly

Hi all, It would appear that I have a zpool corruption issue to deal with... pool is exported, but upon trying to import it, server panics.  Are there any tools available on a zpool that is in an exported state?  I''ve got a separate test bed in which I''m trying to recreate, but I keep getting messages to the effect of need to import the pool first.  Suggestions? thanks Jay

Hi All, I inherited a 4-node ocfs2 cluster and recently 2 ocfs2 filesystems were added to be use as temp tablespace.?One of the four nodes rebooted during the ?creation of the tablespace and hanged at the message below...and it just sits there. If I put the server into rescue mode and comment out all the filesystems it boots up fine and than I can mount the ocfs2 filesystem manuelly but it cannot

Paul, > While testing iscsi targets exported from thumpers via 10GbE and > imported 10GbE on T2000s I am not seeing the throughput I expect, > and more importantly there is a tremendous amount of read IO > happending on a purely sequential write workload. (Note all systems > have Sun 10GbE cards and are running Nevada b65.) The read IO activity you are seeing is a direct

Hi, When attempting to restore to LINUX RHEL5 - OCFS2 filesystem received the following error during RMAN restore for nearly all of the datafiles attempted to restore with exception of a couple of smaller datafiles which were smaller < 2GB. ORA-19870: error reading backup piece /db/dumps/TR1_1/rmanbackup/TR1_88_1 ORA-19502: write error on file "/db/devices/db1/PR2/pr2_1/pr2.data1",

We are in the process of migrating to new database servers. Our current RAC clusters are running OCFS2 1.2.9 on RHEL 4. Our new servers are running OCFS2 1.6 OEL5. If possible, we would like to minimize the amount of data that needs to move as we migrate to the new servers. We have the following questions: 1. Can we mount an existing OCFS2 1.2 volume on a servers running OCFS2 1.6?

A new release of the puppetlabs/postgresql module is now available on the Forge: https://forge.puppetlabs.com/puppetlabs/postgresql/2.1.0 Changelog ======== This release is primarily a feature release, introducing some new helpful constructs to the module. For starters, we''ve added the line `include ''postgresql_conf_extras.conf''` by default so extra parameters not

Dear all, my problem is following. I know Stata, but currently I have to use R. Could You please help in finding the analogy to R. (1) creating of City-Dummy. I know in Stata: g byte city=0 replace city=1 if city==12&year==2000 and (2) Create a Time-Dummy-Variable g byte T2000=0 replace T2000=1 if year==2000 (3) I need the City DUmmy for the following combination: I have the

We ran into an interesting situation recently w.r.t. Oracle 9i and the zpool it lives on. Oracle is installed on (and has its tablespace on as well) a zpool which is comprised of two mirrored LUNs, and each LUN is from a separate 6140. We needed to do work on one of these 6140s and so I went to detach that side of the mirror from the zpool. What happened next was peculiar .... the

Are there any known issues with using a split mirror of the OCFS partitions for backups? One option we are looking at is as follows: 1. Put tablespace in backup mode. 2. Split the mirror at the SAN level. 3. end tablespace backup mode. 4. mount the OCFS mirror under a different mount point. 5. backup the files on the OCFS mirror using RMAN. The question is how feasibile it is for step #4 to

We are running 2-node RAC on RedHat Linux-86 (32-bit) the following was done on (4/10/2005) 1. upgrade OS to update 4 (kernel-smp-2.4.21-27.0.2.EL) 2. upgrade OCFS 1.0.12 to ocfs-2.4.21-EL-smp-1.0.14-1 3. upgrade from 9.2.0.5 to 9.2.0.6 (IN 2-Node RAC) 4. change defualt temporary tablespace to regular one (Rac bug fix) 5. Enable aysnc mode by applying patch 3208258_9206 ** Patch 4153303 applied on

Here is what I have configured: T2000 with OBP 4.28.6 2008/05/23 12:07 with 2 - 72 GB disks as the root disks OpenSolaris Nevada Build 91 Solaris Express Community Edition snv_91 SPARC Copyright 2008 Sun Microsystems, Inc. All Rights Reserved. Use is subject to license terms. Assembled 03 June 2008

Guru''s, Is anyone shar with me the steps to configure hardware RAID in T2000 server (LSI drivers) and use rootdisk hardware mirror -- Thanks a lot! Malahat Qureshi Ph.D. (MIS) Email: malahatq at hotmail.com -------------- next part -------------- An HTML attachment was scrubbed... URL:

Has anyone encountered this error or know how to correct it? I couldn''t find any Rails-specific info about this on google. Here are the circumstances: /usr/local/bin/ruby --version ruby 1.8.4 (2005-12-24) [i686-linux] /usr/local/bin/rails --version Rails 1.1.6 ## Create mcd app rails mcd -d oracle cd mcd ## Create oracle tablespace & user sqlplus ''/ as