Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: populate_group slow

Re: populate_group slow

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 16 Oct 2001 06:07:42 -0700
Message-ID: <9qhbeu02qqk@drn.newsguy.com>


In article <ae330f95.0110160122.949ac70_at_posting.google.com>, ehabsalem_at_yahoo.com says...
>
>Thanks for the reply. I will try that but I copied the SQL from the
>record group to sqlplus and ran it on both machines. The speed is
>identical.
>I read in Froms help that populate_group fetchs 100 rows at a time,
>might this be the reason, I mean it can be something related to the
>UNIX OS configuration.
>
>Ehab

try the sql_trace -- it'll tell us if the probably is in the database or not. I don't like to "guess".

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp 
Received on Tue Oct 16 2001 - 08:07:42 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US