Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: populate_group slow
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 CorpReceived on Tue Oct 16 2001 - 08:07:42 CDT