jshen.cad's articles:

Items(26) /3 Next >> Last >|

Pressure Test tools for oracle database 3 58 (2/11/2009 1:55:18 PM) comp.databases.oracle.server hi, we plan to do some pressure test on Oracle 10g database againt our environment. Would anybody do some favor to recommend pressure test tools for oracle database ? Joe ... jshen

Regarding Oracle version upgrading questions 5 25 (1/26/2009 3:07:31 PM) comp.databases.oracle.server hi, we are considering seriously on upgrading our database server. Current database runs on HP-UX 11.11, 20CPU and 36GB RAM. The version is Oracle8.1.7. To system running records, we met Ora-600 err... jshen

Need help: wio rease from 1% to more than 50% after increasing SGA size 5 38 (6/27/2008 5:48:45 AM) comp.databases.oracle.server hi, we met problem with oracle8.1.7(on HP-UX) SGA tuning. The Oracle server runs on HP-UX11i. Previously, the server has 16GB RAM and 20CPU installed. The business data keeps increasing in past ... jshen

Oracle8.1.7 : Very high CPU load but NO alert.log record 1 33 (5/5/2008 5:13:47 PM) comp.databases.oracle.server Hi, two of our DB server suffered very high CPU load today. we could not identify the exact reason for it. We run a main DB whose table content update frequently. Both of the two questionable servers m... jshen

Oracle8.1.7 snapshot refresh failed without any error message 6 30 (12/4/2007 3:12:16 PM) comp.databases.oracle.server hi, we use snapshot in oralce8.1.7 (HP-UX 11i). There are three snapshots which map main DB data to three satalite servers. On each satalite server there are three jobs configured to refresh snapshot tabl... jshen

Should we consider PA-RISC server 8420 or server of new CPU architecture? 2 120 (10/24/2007 2:41:51 PM) comp.sys.hp.hpux someone on the list said PA-RISC is to it EOF. But, HP sales still recommend PA-RISC based 8420 server. Should we consider new architecture base server but not 8420? joe ... jshen

Is that possible to change NIC without stop CM cluster ? 0 130 (10/24/2007 12:10:30 PM) comp.sys.hp.hpux hi, we have four 8400(8400-1, 8400-2, 8400-3 8400-4) form a CM cluster on which four packages run on different 8400. When CM cluster is installed, 8400-1 use LAN1 and LAN3 in CM configuration. Now I w... jshen

Need recommendation DB upgradation 5 35 (10/19/2007 3:01:46 PM) comp.databases.oracle.server hi, we are using Infranet 6.5 (Portal software product, which is now a part of Oracle) with Oracle 8i. As Oracle8i has been announced to be EOL, and we do have met several times of system fault cause Or... jshen

Poor Oracle performance with load CPU load 2 24 (8/2/2007 3:59:57 PM) comp.databases.oracle.server hi, we run oracle8.1.7 on HP-UX 11i. The DB performance becomes very poor that a lot data is lost for application processing queue overflow. Application ---- > DB ^ ... jshen

Oracle performance tuning question 3 29 (7/29/2007 3:07:45 PM) comp.databases.oracle.server Hi, I'm trying to identify the bottleneck of our Orcle8.1.7 server running on HP-UX 11i. The server has 20CPU and 16GB DRAM, HP XP1024 disk array is attached as storage. Currently, we have install... jshen

jshen.cad's replies:

Items(7) /1

Need help: wio rease from 1% to more than 50% after increasing SGA size 5 38 (6/27/2008 5:48:45 AM) comp.databases.oracle.server hi, we met problem with oracle8.1.7(on HP-UX) SGA tuning. The Oracle server runs on HP-UX11i. Previously, the server has 16GB RAM and 20CPU installed. The business data keeps increasing in past ... jshen.cad (38)

Oracle8.1.7 snapshot refresh failed without any error message 6 30 (12/4/2007 3:12:16 PM) comp.databases.oracle.server hi, we use snapshot in oralce8.1.7 (HP-UX 11i). There are three snapshots which map main DB data to three satalite servers. On each satalite server there are three jobs configured to refresh snapshot tabl... jshen.cad (38)

Need recommendation DB upgradation 5 35 (10/19/2007 3:01:46 PM) comp.databases.oracle.server hi, we are using Infranet 6.5 (Portal software product, which is now a part of Oracle) with Oracle 8i. As Oracle8i has been announced to be EOL, and we do have met several times of system fault cause Or... jshen.cad (38)

How to increase MAX number of connections for Oracle DB server? 10 45 (2/2/2007 3:01:46 PM) comp.databases.oracle.server Hi, I'm new to system tuning of Oracle DB. Our Oracle DB seems to only allow 128 connections, while the DB connection requirement has exceed 250. How could I increase the max number of connection allowed f... jshen.cad (38)

How to determine the reason for snapshot autorefresh failure? 3 34 (1/28/2007 3:19:09 PM) comp.databases.oracle.server hi, we have a central DB which is updated frequently. there are three satallite DB which much keep syncronized with central DB at 5min interval. there are six tables need to be syncronized. We have ... jshen.cad (38)

performance of backup degrade continuously 3 35 (6/24/2006 1:55:04 PM) comp.databases.oracle.server Hi, we are using oracle8i in our service system. The number of record increases about 3million every day. We backup the system every day with HP ominibackup. In past weeks, we noticed that the backup perform... jshen.cad (38)

How to increase MAX extent size in a tablespace? 6 73 (5/28/2006 3:39:14 PM) comp.databases.oracle.server Hi, One of tablespace in our oracle DB shows MAX extent size is less than 30MB, while the available tablespace size is more than 800MB. I issued "alter tablespace PDB coalesce; " , but this does no help. Ho... jshen.cad (38)