600-[25012] on delete of IOT table

2003-09-04 Thread chao_ping
the official ORACLE-L FAQ: http://www.orafaq.net -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: RE: SHMMAX setting on Sun 4800 box

2003-06-26 Thread chao_ping
). = = = = = = = = = = = = = = = = = = = = Ö Àñ£¡ chao_ping [EMAIL PROTECTED] 2003-06-27 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services

Re: copy a datafile to a raw device

2003-06-19 Thread chao_ping
subscribing). = = = = = = = = = = = = = = = = = = = = Ö Àñ£¡ chao_ping [EMAIL PROTECTED] 2003-06-20 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: chao_ping

Re: IO Topology Anyone???

2003-06-19 Thread chao_ping
£¡ chao_ping [EMAIL PROTECTED] 2003-06-20 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

Re: Memory taken by s session

2003-03-22 Thread chao_ping
= = = = = = = = = = = = = = = = = = = = -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: Row chaining

2003-03-11 Thread chao_ping
-- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send

Steps to migrate 8170 to 9203

2003-03-10 Thread chao_ping
) === 2003-03-03 10:40:00 ,you wrote£º=== -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting

Re: access to oracle $ tables in 9.2.0

2003-03-05 Thread chao_ping
://www.orafaq.net -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from

Re: Re: DB_BLOCK_SIZE and Solaris block size

2003-03-04 Thread chao_ping
). = = = = = = = = = = = = = = = = = = = = -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: Oracle 9.2.0.2 bugs

2003-03-03 Thread chao_ping
= = = = = = = = = = = = = = = = = = = = -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

DeadLock: session wait on itself with no rows.

2003-03-02 Thread chao_ping
/initrans, How about session wait on itself then? And how can it happen? Regards zhu chao msn:[EMAIL PROTECTED] www.happyit.net www.cnoug.org(China Oracle User Group) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network

Re: Re: DBMS_STATS

2003-02-28 Thread chao_ping
2.6 2.8 Running 8i, 9i, 9.2 5 terabyte db's Jeff = = = = = = = = = = = = = = = = = = = = -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

urgent: lots of db file sequential read

2003-02-25 Thread chao_ping
and different time lengh, but I think after i added a disk array to disk array, IO wait should slowdown, but from the new statspack, relatively more time is spent on io wait? How to explain this? Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: chao_ping INET

Re: update 30mil rows

2003-02-25 Thread chao_ping
ORACLE-L FAQ: http://www.orafaq.net -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE

Your experience with data guard in 9.2?

2003-02-23 Thread chao_ping
easy and robust,with some small problems, though. 4.Anyone using logical standby database? Is it as good as shareplex from quest? Please share your experience, thanks. Ö Àñ£¡ chao_ping [EMAIL PROTECTED

RAC resource affinity

2003-02-22 Thread chao_ping
list you want to be removed from). You may also send the HELP command for other information (like subscribing). = = = = = = = = = = = = = = = = = = = = -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network

RAC resource affinity

2003-02-22 Thread chao_ping
list you want to be removed from). You may also send the HELP command for other information (like subscribing). = = = = = = = = = = = = = = = = = = = = -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network

Re: Re: Oracle 8i or 9i ?

2003-02-17 Thread chao_ping
: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = = = = = = = = = = = = = = = = = = = = -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: chao_ping INET

Re: RE: Re: parallel index creation again:in which case, can we use p

2003-02-13 Thread chao_ping
: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E

OT:Disk Array performance benchmark?

2003-02-12 Thread chao_ping
benchmarking , please share your advice, also your experience with the New T3-ES storage. Thanks. Regards zhu chao msn:[EMAIL PROTECTED] www.happyit.net www.cnoug.org(China Oracle User Group) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: chao_ping

parallel index creation again:in which case, can we use parallel with single cpu env?

2003-02-12 Thread chao_ping
:[EMAIL PROTECTED] www.happyit.net www.cnoug.org(China Oracle User Group) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing

Re: Re: parallel index creation again:in which case, can we use parallel with single cpu env?

2003-02-12 Thread chao_ping
= = = = = = = = = = = = = = = = = = = = -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: View HELP Please!

2003-02-12 Thread chao_ping
for other information (like subscribing). = = = = = = = = = = = = = = = = = = = = -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re: RE: Oracle TEMPORARY SEGMENT

2003-02-11 Thread chao_ping
://www.orafaq.net -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from

Re: RE: RE: Oracle TEMPORARY SEGMENT

2003-02-11 Thread chao_ping
: I rewrote his SQL properly and it took less than a minute to return the 1036 records. Jerry Whittle ASIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -Original Message- From:chao_ping [SMTP:[EMAIL PROTECTED]] Whittle Jerome Contr NCI, I

Re: RE: Bind variables

2003-02-10 Thread chao_ping
the official ORACLE-L FAQ: http://www.orafaq.net -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: common listener

2003-02-10 Thread chao_ping
). = = = = = = = = = = = = = = = = = = = = -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: 2k and 8k block size

2003-02-10 Thread chao_ping
information (like subscribing). = = = = = = = = = = = = = = = = = = = = -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing

Re: RE: common listener

2003-02-10 Thread chao_ping
for a method to stop services for a single DB. Srinivas -Original Message- From: chao_ping [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 11, 2003 9:39 AM To: Multiple recipients of list ORACLE-L Subject: Re: common listener kommareddy sreenivasa, hei, you can just create

Re: books recommendations

2003-02-08 Thread chao_ping
ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = = = = = = = = = = = = = = = = = = = = -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: chao_ping INET: [EMAIL

Re: Ora-1548 while dropping tablespace

2003-02-08 Thread chao_ping
). = = = = = = = = = = = = = = = = = = = = -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: ORA-04031 error

2003-02-08 Thread chao_ping
). = = = = = = = = = = = = = = = = = = = = -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: Question on set autotrace on statistics

2003-02-06 Thread chao_ping
for other information (like subscribing). = = = = = = = = = = = = = = = = = = = = Ö Àñ£¡ chao_ping [EMAIL PROTECTED] 2003-02-06 -- Please see the official ORACLE-L

Re: RE: RAC on linux

2003-02-03 Thread chao_ping
the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

Re: Recovery Solutions - URGENT

2003-02-03 Thread chao_ping
. Thanks for your help in advance. Best Regards Jai -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting

Re: Re: more consistent gets, but more quickly?

2003-01-28 Thread chao_ping
also send the HELP command for other information (like subscribing). = = = = = = = = = = = = = = = = = = = = -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com

more consistent gets, but more quickly?

2003-01-27 Thread chao_ping
. Can someone help me understand it? Thanks very much. Regards zhu chao msn:[EMAIL PROTECTED] www.cnoug.org(China Oracle User Group) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858

Re: Re: more consistent gets, but more quickly?

2003-01-27 Thread chao_ping
the HELP command for other information (like subscribing). = = = = = = = = = = = = = = = = = = = = -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

Re: Strange processes showing up

2003-01-27 Thread chao_ping
you want to be removed from). You may also send the HELP command for other information (like subscribing). = = = = = = = = = = = = = = = = = = = = -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services

Re: Re: Experiences with Automatic Undo Management

2003-01-27 Thread chao_ping
the official ORACLE-L FAQ: http://www.orafaq.net -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: Re: How to parallel index scan.

2003-01-23 Thread chao_ping
sort_area_size is 5Mb and I do notice them all bunch up. I don't think adjusting the sort_area_size will have that much of a difference anyways. Mike [EMAIL PROTECTED] - Original Message - From: chao_ping [EMAIL PROTECTED] To: LazyDBA.com Discussion [EMAIL PROTECTED] Sent: Thursday, January

Re: CBO not using the index even though it is faster when hinted ....

2003-01-23 Thread chao_ping
). = = = = = = = = = = = = = = = = = = = = -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

off topic: iostat -x in linux

2003-01-22 Thread chao_ping
11.20 42948233.06 2.00 200.00 100.00 Regards zhu chao msn:[EMAIL PROTECTED] www.happyit.net www.cnoug.org(China Oracle User Group) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538

Re: Re: same sql: different db block gets in different oracle version

2003-01-22 Thread chao_ping
Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 22 January 2003 07:42 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

tuxedo connect to oracle: v$session.program =?

2003-01-22 Thread chao_ping
$session. IS there solution to this problem? Thanks. Regards zhu chao msn:[EMAIL PROTECTED] www.happyit.net www.cnoug.org(China Oracle User Group) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City

same sql: different db block gets in different oracle version

2003-01-21 Thread chao_ping
processed Regards zhu chao msn:[EMAIL PROTECTED] www.happyit.net www.cnoug.org(China Oracle User Group) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

Re: Oracle 9.2.0.2 performance problem

2003-01-20 Thread chao_ping
) 1 sorts (disk) 445919 rows processed = = = = = = = = = = = = = = = = = = = = -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

Re: HP-UX 11.0 mount parameter mincache

2003-01-15 Thread chao_ping
). = = = = = = = = = = = = = = = = = = = = -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

stripe the log file across different disks?

2003-01-09 Thread chao_ping
www.cnoug.org(ChinaOracle User Group) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: Performance Issue on 817 !!!

2003-01-08 Thread chao_ping
information (like subscribing). = = = = = = = = = = = = = = = = = = = = -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

Re: RE: RMAN and disk usage info

2003-01-08 Thread chao_ping
for other information (like subscribing). = = = = = = = = = = = = = = = = = = = = -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re: MTS / Dedicated

2003-01-06 Thread chao_ping
://www.orafaq.net -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing

Re: Prevent FTS

2003-01-06 Thread chao_ping
that there is a FTS of table z . what can be the reason for this and how to prevent this. Thanks Manoj = = = = = = = = = = = = = = = = = = = = -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services

Re: log file sync Wait

2003-01-02 Thread chao_ping
). = = = = = = = = = = = = = = = = = = = = -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: Re: Free Shared pool memory

2003-01-02 Thread chao_ping
may also send the HELP command for other information (like subscribing). = = = = = = = = = = = = = = = = = = = = -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

X$dual and Dual: performance and others?

2002-12-26 Thread chao_ping
significantly, right? But has anyone did this trick in production? any experience? Thanks. Regards zhu chao msn:[EMAIL PROTECTED] www.cnoug.org(ChinaOracle User Group) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City

Cache on sysdate? --From 9i performance planning manual

2002-12-26 Thread chao_ping
: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail

Re: Killed status

2002-12-25 Thread chao_ping
as killed? No matter how many times i try to kill the session, it still marked as killed, but it still won't release the lock. Thanks in advance. = = = = = = = = = = = = = = = = = = = = -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: chao_ping INET

Re: RE: help me find out why rac instance died

2002-12-22 Thread chao_ping
and check the OS log files. Best Regards, K Gopalakrishnan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

Re: Re: RE: help me find out why rac instance died

2002-12-22 Thread chao_ping
ORACLE-L FAQ: http://www.orafaq.net -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE

help me find out why rac instance died

2002-12-21 Thread chao_ping
-L FAQ: http://www.orafaq.net -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE

Re: Oracle 8i/HP-UX,Solaris,Windows/Active Directory Question

2002-12-16 Thread chao_ping
). = = = = = = = = = = = = = = = = = = = = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: RE: Active sessions chewing up a huge amount of RAM

2002-12-12 Thread chao_ping
CPU's on the db, and (to a lesser extent) enough RAM. Thanks... = = = = = = = = = = = = = = = = = = = = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

Re: Recovery Scenarios

2002-12-10 Thread chao_ping
-- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send

Re: archiving redo logs

2002-12-10 Thread chao_ping
option, I appreciate if you can share it here. Thanks, Bala. = = = = = = = = = = = = = = = = = = = = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

Re: Re: RE: image storage confusion ?? -- UUDECODE

2002-12-09 Thread chao_ping
containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = = = = = = = = = = = = = = = = = = = = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: chao_ping

Re: process memory utilization

2002-12-03 Thread chao_ping
chao_ping, It seems i am posting a too long question, so nobody is interested. I post the answer to my second question, to check the memory utilization in linux operation system. It is in /proc/spid/status file. Regards zhu chao Eachnet DBA 86

process memory utilization

2002-12-02 Thread chao_ping
Eachnet DBA 86-21-32174588-667 [EMAIL PROTECTED] www.cnoug.org(Chinese Oracle User Group) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re: RE: LGWR using lots of CPU time, low CPU usage

2002-11-26 Thread chao_ping
-- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send

Re: What makes Oracle DB shutdown automatically?

2002-11-25 Thread chao_ping
-- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send

Re: RE: Running/Licensing Hyperthreaded Intel Pentium4 Xeon CPU's on

2002-11-24 Thread chao_ping
). = = = = = = = = = = = = = = = = = = = = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: Running/Licensing Hyperthreaded Intel Pentium4 Xeon CPU's on Linu

2002-11-20 Thread chao_ping
command for other information (like subscribing). = = = = = = = = = = = = = = = = = = = = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

Re: RE: db file sequential read

2002-11-20 Thread chao_ping
containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = = = = = = = = = = = = = = = = = = = = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: chao_ping

Can OCI TAF and Tuxedo XA be used together in RAC enviroment?

2002-11-15 Thread chao_ping
ORACLE-L FAQ: http://www.orafaq.com -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE

Re: How to set client's characterset on session level?

2002-11-15 Thread chao_ping
). = = = = = = = = = = = = = = = = = = = = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

surprising result:8CPU Sun 3500 VS 4CPU Dell 6650

2002-11-15 Thread chao_ping
] www.happyit.net www.cnoug.org(Chinese Oracle User Group) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting

Re: RE: surprising result:8CPU Sun 3500 VS 4CPU Dell 6650

2002-11-15 Thread chao_ping
). = = = = = = = = = = = = = = = = = = = = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: Performance consequences from downgrading from 64-bit to 32-bit?

2002-11-15 Thread chao_ping
' = = = = = = = = = = = = = = = = = = = = = = Ö Àñ£¡ chao_ping [EMAIL PROTECTED] ¡¡2002-11-16 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services

Re: RE: How-To or Good Practices on Code Releases

2002-11-14 Thread chao_ping
S = = = = = = = = = = = = = = = = = = = = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting

Question about rac: http://asktom.oracle.com/~tkyte/9iSeminar/img17.html

2002-11-13 Thread chao_ping
about RAC advantage? Please share your opinion. Regards zhu chao Eachnet DBA 86-21-32174588-667 [EMAIL PROTECTED] www.happyit.net www.cnoug.org(Chinese Oracle User Group) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: chao_ping INET: [EMAIL PROTECTED] Fat

Re: URGENT

2002-11-12 Thread chao_ping
-L FAQ: http://www.orafaq.com -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE

Re: Oracle taking 100% CPU

2002-11-12 Thread chao_ping
=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A12002-11-12/FONT/DIV= DIVnbsp;/DIV/DIV/BODY/HTML --=002_Dragon206281065310_=-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Rollback Segment Size Testing.

2002-11-12 Thread chao_ping
a copy? And i hope friends have experience on this topic can share your experience Regards zhu chao Eachnet DBA 86-21-32174588-667 [EMAIL PROTECTED] www.cnoug.org(Chinese Oracle User Group) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: chao_ping INET

Re: RE: How to tune this query ...

2002-11-10 Thread chao_ping
/FONT/DIV= DIVnbsp;/DIV/DIV/BODY/HTML --=002_Dragon373150002168_=-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing

Re: OT: RAID 7137 configutation on AIX

2002-11-09 Thread chao_ping
). = = = = = = = = = = = = = = = = = = = = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: Re: Clone Production Server to Stand by Server on 8.1.7 on Win 2k

2002-11-06 Thread chao_ping
). = = = = = = = = = = = = = = = = = = = = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: sqlplus /nolog

2002-10-29 Thread chao_ping
://www.orafaq.com -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from

Re: RAID5+

2002-10-28 Thread chao_ping
: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail

SGA larger than 4GB

2002-10-24 Thread chao_ping
=A1=A1=A12002-10-24/FONT/DIV= DIVnbsp;/DIV/DIV/BODY/HTML --=002_Dragon320551784160_=-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

Re: Reduce parse call for stored procedure?

2002-10-23 Thread chao_ping
such as set cursor_sharing=force or keep this stored procedure into shared pool to reduce the parse call down to one or some no.? TIA, Chuan = = = = = = = = = = = = = = = = = = = = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: chao_ping INET: [EMAIL PROTECTED

Re:

2002-10-22 Thread chao_ping
--=002_Dragon630883480732_=-- --=001_Dragon630883480732_=-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

Re: Oracle 9i RAC

2002-10-22 Thread chao_ping
: http://www.orafaq.com -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from

Re: Oracle on OS/390

2002-03-01 Thread chao_ping
U can check it on metalink.I once see some information about manageing oracle on os/390. Good luck. - Original Message - From: Edward Shevtsov [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, February 28, 2002 11:28 PM Subject: Oracle on

Re: RE: OPS on a single machine ?

2001-09-04 Thread chao_ping
are not the intended recipient and then delete the email from your inbox and do not disclose the contents to another person, use, copy or store the information in any medium. ** Ö Àñ£¡ chao_ping

Re: changing long to lob

2001-08-20 Thread chao_ping

Re: Some doubts)

2001-08-08 Thread chao_ping
hi, 1.row chaining: see oracle8i concepts page 4-10. 2. partition: physically partition a table into several small tables, and logically they are one table. see detailed difinition at: oracle8i concepts 11-2. - Original Message - From: Viraj Luthra [EMAIL PROTECTED] To:

Re: O/S copies of datafiles

2001-08-08 Thread chao_ping
i tested it on windows 2000 and oracle 816-817, it works well, nothing wrong. if test env, i think it should work. if in production, u'd better use other way. - Original Message - From: Sujatha Madan [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]

Re: Unknown RBS

2001-08-07 Thread chao_ping
maybe this is public rollback segment. - Original Message - From: Sinardy [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, August 07, 2001 5:36 PM Subject: Unknown RBS Hi all, I have question below here .. (Solaris 7 Oracle

Re: MTS IS CONFIGURED BUT STILL DEDICATED CONNECTIONS USED

2001-08-06 Thread chao_ping
hi, have u made it? i also encounted the same problem of oracle 817 on solaris, if i specify server=shared in tnsnames.ora, then it gives out 12520 error code. - Original Message - From: Harvinder Singh [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL

Re: (No Subject)

2001-06-29 Thread chao_ping
hi, just do: '' represent ' SQL create table testtb(a varchar(90)); Table created. SQL insert into testtb values('i love oracle''s money'); 1 row created. SQL select * from testtb; A i love oracle's money SQL

  1   2   >