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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: temp tablespace colesce

RE: temp tablespace colesce

From: Gogala, Mladen <MGogala_at_oxhp.com>
Date: Mon, 19 May 2003 08:32:18 -0800
Message-ID: <F001.0059C986.20030519083218@fatcity.com>


Da, svakako! Hvala lijepa. Je li Klavdij Godnic jos uvijek tamo?

Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:mgogala_at_oxhp.com

-----Original Message-----
Sent: Monday, May 19, 2003 11:02 AM
To: Multiple recipients of list ORACLE-L

Mladene, ja verovatno uskoro napustam Aster (i SLoveniju, zapravo). Moje mesto prema tome ostaje upraznjeno. Da li te interesuje kontakt ovde sa nekim, u vezi tvog posla?

> And, of course, HASH_MULTIBLOCK_IO_COUNT blocks should be read/written
> in a single IO, which limits the size of both
DB_FILE_MULTIBLOCK_READ_COUNT
> and HASH_MULTIBLOCK_IO_COUNT to the maximum contiguous IO size supported
> by the OS. On Solaris 2.7 and AIX 4.3.3, it used to be 256k. On HP-UX 11,
> it's 1M. It's an old wisdom that temp tablespace extent should be a
multiple
> of max IO size + some fixed value as the extent header. I use 4k as the
> rule of thumb. I don't have a rational explanation, but I've never had any
> problems with segments sized that way, either.
>
>
> On 2003.05.19 07:21 Steve Perry wrote:
> > Joan's problem/solution of setting "hash_multiblock_io_count=2" sounds a
lot
> > like this from metalink.
> >
> > When a user's temporary tablespace is type=temporary and
> > extent size < hash_multiblock_io_count an ORA-3232 is raised
> > when an attempt is made to perform a hash join.
> > if the HASH_MULTIBLOCK_IO_COUNT is NOT set or = 0, then set it to 2 or 8
> >
> > Steve
> > ----- Original Message -----
> > To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> > Sent: Monday, May 19, 2003 5:01 AM
> >
> >
> > > Hi
> > > Do know if that work both in windows and unix?
> > > Regards
> > > PG
> > >
> > > -----Original Message-----
> > > Sent: sexta-feira, 16 de Maio de 2003 19:48
> > > To: Multiple recipients of list ORACLE-L
> > >
> > >
> > > AK,
> > >
> > > I had temp tablespace problem on a new server this early year. A
> > > particular query always run out of temp space (2 gig for a small
> > > database). I off-line the temp, recreate the temp, coalesced,
recreate
> > > temporary tablespace or regular tablespace, changed the pctincrase
from
> > > 0 to 1, forced wake up smon to clean. Guess what? I still got same
> > > problem until I put hash_multiblock_io_count=2 in the ini.ora file.
> > > Don't ask me why. It never had problem after since.
> > >
> > > Joan
> > >
> > > > AK wrote:
> > > >
> > > > What is the way to shrink temp tablespace . I tried alter tablespace
> > > > colesce .. doesn't seems to work and I can't bring down the db .
> > > >
> > > > -ak
> > > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > --
> > > Author: Joan Hsieh
> > > INET: joan.hsieh_at_tufts.edu
> > >
> > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > > San Diego, California -- Mailing list and web hosting services
> > > ---------------------------------------------------------------------
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from). You may
> > > also send the HELP command for other information (like subscribing).
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > --
> > > Author: Paulo Gomes
> > > INET: PGomes_at_Datinfor.pt
> > >
> > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > > San Diego, California -- Mailing list and web hosting services
> > > ---------------------------------------------------------------------
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from). You may
> > > also send the HELP command for other information (like subscribing).
> > >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Steve Perry
> > INET: sperry_at_sprynet.com
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting services
> > ---------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
>
> --
> Mladen Gogala
> Oracle DBA
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Mladen Gogala
> INET: mgogala_at_adelphia.net
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Vladimir Barac
  INET: vladob_at_aster.si

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gogala, Mladen
  INET: MGogala_at_oxhp.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Mon May 19 2003 - 11:32:18 CDT

Original text of this message

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