Re: question on EXPLAIN_PLAN

2002-02-07 Thread kevin wang
buy. I mean, re-create table can fix the problem, but, the problem is not only with the HWM. I will do some further investigation. thanks a lot, Kevin Wang - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, February 06, 2002 2:18 PM

question on EXPLAIN_PLAN

2002-02-06 Thread kevin wang
Hi, guys The problem belows is really make me confused and gave me big trouble, is there someone can give me some hlep? I have two databses, same version(oracle 8.1.6),same O/S(win2000), sameschema structure, different data(but small difference ofsize). and even exactly same

Re: question on EXPLAIN_PLAN

2002-02-06 Thread kevin wang
Zakrzewski To: kevin wang Sent: Wednesday, February 06, 2002 12:38 PM Subject: Re: question on EXPLAIN_PLAN Kevin, Have these indexes been rebuilt recently? If not, you may want to consider rebuilding the indexes. Not sure if this is your issue, but if you have

Re: question on EXPLAIN_PLAN

2002-02-06 Thread kevin wang
the PK index, same thing. that's very bad. it is Oracle 8.1.6 on win2000. thanks for reply. Kevin Wang - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, February 06, 2002 1:55 PM Kevin, Have you analyzed the tables on both databases? Card

limit user CPU usage

2002-01-15 Thread kevin wang
will be highly appreciated. My environment is Oracle8.1.6 on Win2000. Thanks, Kevin Wang

Re: limit user CPU usage

2002-01-15 Thread kevin wang
Thanks, Ron, I will try it. Kevin Wang - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, January 15, 2002 11:55 AM Kevin, You could try creating a profile with the cpu_per_call and cpu_per_session set ta a particular value. It will limit

Re: How to backup MTS database with RMAN

2001-12-21 Thread kevin wang
= dedicated) ) ) Kevin Wang - Original Message - From: Daiminger, Helmut To: Multiple recipients of list ORACLE-L Sent: Wednesday, December 19, 2001 5:25 AM Subject: How to backup MTS database with RMAN Hi! Since I'm pretty new to RMAN I have a rather basic

Re: How to backup MTS database with RMAN

2001-12-19 Thread kevin wang
= dedicated) ) ) Kevin Wang - Original Message - From: Daiminger, Helmut To: Multiple recipients of list ORACLE-L Sent: Wednesday, December 19, 2001 5:25 AM Subject: How to backup MTS database with RMAN Hi! Since I'm pretty new to RMAN I have a rather basic