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

Home -> Community -> Usenet -> c.d.o.server -> Re: Parallel Query and Sort Size

Re: Parallel Query and Sort Size

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 21 Jul 1998 18:55:05 GMT
Message-ID: <01bdb4d8$ed5a36d0$0300a8c0@WORKSTATION> 






What are the storage parameters on


the tablespace being used for the sort ?



> The SELECT fails after creating 122MB of temporary storage.  Is


this


> reasonable in your experience?  I have never had bad sort behavior


with


> PQO before this.  The explain plan shows a regular, parallelized,


full


> table scan with sort operation.



Received on Tue Jul 21 1998 - 13:55:05 CDT












Original text of this message













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