Re: temp extent size

From: viny <vinsharma1808_at_gmail.com>
Date: 19 Jan 2007 12:05:05 -0800
Message-ID: <1169237104.706226.216900@11g2000cwr.googlegroups.com>

Hi Daniel ,

What more information you need, I think I can provide you more information !!

Please let me know ?

Regards,
Vinay

DA Morgan wrote:
> viny wrote:
> > 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

>

> Please don't top post. Scroll to the bottom to reply. Thank you.

>

> I highly doubt the issue is as you suspect. I can't with so little
> information suggest what it is but I wouldn't change parameters
> without knowing more. Seriously consider opening an SR if you can
> not post sufficient information here for someone to help you.
> --
> 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 - 14:05:05 CST