RE: dbms_stats.gather_schema_stats

2003-06-12 Thread gmei
://www.orafaq.net -- Author: gmei 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

OT: question about DynaLoader::dl_load_file from perl profiler output

2003-06-11 Thread gmei
- DynaLoader::dl_find_symbol 0.00 0.000 -0.000 2 0. - DynaLoader::dl_install_xsub What is DynaLoader::dl_load_file corresponding to in my perl code? TIA. Guang -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: gmei INET: [EMAIL PROTECTED] Fat City

sql query optimization

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

query run time vs IN list elements

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

RE: query run time vs IN list elements

2003-06-06 Thread gmei
an EXISTS statement. Jerry Whittle ASIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -Original Message----- From: gmei [SMTP:[EMAIL PROTECTED] Hi: Today I have something I don't fully understand. I have oracle 8173 on Sun Solar

RE: query run time vs IN list elements

2003-06-06 Thread gmei
geneid in (165383,165409,165603,166524,149490,166141,166342,166829,16683 2,167771,16849 7,163450,163817, 165751,167437,167438,167476,164118,166054,168728,162967,164533 ,164545,163212 , 168501) group by geneid, genegroup; From: gmei [EMAIL PROTECTED] Date: 2003/06/06 Fri PM 02:09:44 EDT

OT: Is there a simple perl utility or program similar to Oracle's dbms_profiler?

2003-06-04 Thread gmei
FAQ: http://www.orafaq.net -- Author: gmei 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

RE: would imp speed affect by setting indexes to NOLOGGING?

2003-05-29 Thread gmei
) extents. Make sure temp tablespace has ample room, should index build processes perform disk sorts. Also, make sure quota is okay on tablespaces for primary key constraint indexes. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: gmei INET: [EMAIL PROTECTED] Fat City

would imp speed affect by setting indexes to NOLOGGING?

2003-05-27 Thread gmei
to be lower. Does anyone have similar experience? TIA. Guang -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: gmei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

RE: would imp speed affect by setting indexes to NOLOGGING?

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

Re: create interMedia index problem

2003-03-28 Thread gmei
on them are much more filled (like 90% full). Any idea what might be the problem? TIA. Guang -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: gmei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

why FTS is chosen here?

2003-03-25 Thread gmei
explaination why TermObs.OBSID's index is not used? TIA. Guang -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: gmei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

RE: Tablespaces - datafiles

2003-03-11 Thread gmei
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: gmei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: Tablespaces - datafiles

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

RE: Disable / enable constraints

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

drop table vs truncate table -- performance

2003-03-10 Thread gmei
truncate table Any explanation? TIA. Guang -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: gmei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: perl DBI question: fetchrow_array

2003-03-07 Thread gmei
[EMAIL PROTECTED] cc: Subject:Re: perl DBI question: fetchrow_array try using fetchrow_arrayref and see if its faster or less resource intensive. On Thu, 6 Mar 2003, gmei wrote: I have some perl code which selects table data and write it into a file. I have

perl DBI question: fetchrow_array

2003-03-06 Thread gmei
-- Author: gmei 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: DBMS_STATS

2003-02-28 Thread gmei
of 'ListGuru') and in the message BODY, include a line 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.net -- Author: gmei

RE: Purely for your amusement

2003-02-28 Thread gmei
Title: RE: Purely for your amusement I thinkthe reason that Microsoft does this is to keep the control of OS market in China. MShas a huge market share in China, almost exclusively. Iread a report a while ago saying some local goverment (Beijing Minucipal?) isconcerned about OS security

RE: Invalid column in table - how to access it?

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

select count(case ...) slow in PL/SQL, any better way?

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

RE: select count(case ...) slow in PL/SQL, any better way?

2003-02-24 Thread gmei
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of gmei Sent: Monday, February 24, 2003 4:07 PM To: Multiple recipients of list ORACLE-L Subject: select count(case ...) slow in PL/SQL, any better way? Hi: Oracle 8173 on Sun Solaris 2.8. I am trying to optimize

Question on set autotrace on statistics

2003-02-05 Thread gmei
client 2 SQL*Net roundtrips to/from client 0 sorts (memory) 0 sorts (disk) 1 rows processed -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: gmei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

FW: OT: unix script quetion: to replace $ with \$

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

why these tables can not be seen from user_segments?

2003-02-04 Thread gmei
not have their corresponding segments? What are they and their functions? TIA. Guang Mei -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: gmei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing

RE: why these tables can not be seen from user_segments?

2003-02-04 Thread gmei
They don't seem to be views, they are tables SQL select view_name from user_views where view_name like 'DR$%'; no rows selected SQL -Original Message- Sent: Tuesday, February 04, 2003 11:53 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Hi, I found this out the hard way to:

RE: why these tables can not be seen from user_segments?

2003-02-04 Thread gmei
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: gmei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: OT: unix script quetion: to replace $ with \$

2003-02-03 Thread gmei
-- Author: gmei 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