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 10:17:43 -0800
Message-ID: <F001.0059CC24.20030519101743@fatcity.com>


I apologize. I was responding to Vlado's email and I didn't notice that the email exchange went to the whole list. Once again, I humbly apologize.

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

-----Original Message-----
Sent: Monday, May 19, 2003 12:32 PM
To: Multiple recipients of list ORACLE-L

Translation please?

At 07:01 AM 5/19/03 -0800, you wrote:
>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?
>
>
>----- Original Message -----
>To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
>Sent: Monday, May 19, 2003 15:11
>
>
> > 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).


Scott Stefick
Systems / Oracle Certified DBA
Wm. Rainey Harper College
sstefick_at_harpercollege.edu
847.925.6130
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Scott Stefick
  INET: sstefick_at_harpercollege.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: 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 - 13:17:43 CDT

Original text of this message

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