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: temp extent size

Re: temp extent size

From: viny <vinsharma1808_at_gmail.com>
Date: 19 Jan 2007 10:48:42 -0800
Message-ID: <1169232522.235446.188300@v45g2000cwv.googlegroups.com>


Thanks for your response !!

for more clarity :
My DB version is 9.2.0.6
OS is HP Unix 11i

I am facing ORA-1652 even if I have sufficient Temp datafile more than 4GB . I think only reason here, i see is Next extent ize is not proper , which is 1M by default, /and that may have caused the fragmentation in the temp tablespace. Due to which it is not able to provide contiguous blocks for the user process.

But I am not sure, how much should we use for extent size in case of Temporary content type Temp tablespace?

regards,
vinay

DA Morgan wrote:
> viny wrote:
> > My sort area size is 8MB and db_block_size is 8KB
> >
> > I have created locally managed temporary tablespace. What should be
> > ideal value for INITIAL, NEXT extent size for the locally managed
> > temporary tablespace??
> >
> > I am using 8MB+8KB extent size. Is it higher/lower? Need the suggestion
> > asap.
> >
> > thanks in advance !!
> >
> > regards,
> > vinay
>
> Could you please restate your question, adding your version number and
> operating system, and strive for greater clarity.
>
> The default is 1M for each and I wouldn't change that without some
> metrics giving a reason to make a different choice.
> --
> Daniel A. Morgan
> University of Washington
> damorgan_at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Group
> www.psoug.org
Received on Fri Jan 19 2007 - 12:48:42 CST

Original text of this message

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