Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: temp tablespace colesce
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
> > > >
-- 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