ssage-
> From: Hallas, John [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, April 18, 2001 6:21 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Temporary Tablespace Design
>
> FOR YOUR INFORMATION
>
> ESIS and EPFAL are now part of Logica. The Internet
- Kirti Deshpande
Verizon Information Services
http://www.superpages.com
> -Original Message-
> From: Hillman, Alex [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, April 18, 2001 10:37 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Temporary Tablespace
2001 17:26
To: Multiple recipients of list ORACLE-L
Subject: RE: Temporary Tablespace Design
Well, not quite. SORT_AREA_SIZE specifies the maximum
amount, in bytes, of memory to use for a sort. After the sort is complete
and all that re
Original Message-
> From: Jared Still [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, April 18, 2001 10:25 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Temporary Tablespace Design
>
> On Wednesday 18 April 2001 07:40, you wrote:
> > Hi John,
> > Aft
ssage-
> From: Hallas, John [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, April 18, 2001 6:21 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Temporary Tablespace Design
>
> FOR YOUR INFORMATION
>
> ESIS and EPFAL are now part of Logica. The Internet
On Wednesday 18 April 2001 07:40, you wrote:
> Hi John,
> After the sort phase is complete, Oracle will trigger memory
> de-allocation and the OS will go at work again.
Kirti,
I seem to recall a post from Steve Adams not too long ago about
this. As I recall, free() is not called immediately, b
nts of list ORACLE-L
> Subject: RE: Temporary Tablespace Design
>
> FOR YOUR INFORMATION
>
> ESIS and EPFAL are now part of Logica. The Internet email addresses of the
> staff has changed to the following - [EMAIL PROTECTED] eg
> [EMAIL PROTECTED] Emails using the old for
ent: Wednesday, April 18, 2001 6:21 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Temporary Tablespace Design
>
> FOR YOUR INFORMATION
>
> ESIS and EPFAL are now part of Logica. The Internet email addresses of the
> staff has changed to the following - [E
FOR YOUR INFORMATION
ESIS and EPFAL are now part of Logica. The Internet email addresses of the staff has
changed to the following - [EMAIL PROTECTED] eg [EMAIL PROTECTED] Emails
using the old format will continue to be delivered until 30th June 2001.
Kirti Deshpande writes
"Also, keep SOR
Do not increase the sort_area_size at the database
level but at the session level. When I have big batch
jobs running alone at night I increased the
hash_area_size and the sort_area_size of the session
running the job.
--- CC Harvest <[EMAIL PROTECTED]> a écrit : >
Kirti:
>The server is solely
I think you missed analyze operation. It is for this command is 4x may be required. Also space for temporary tablespaces can be on very
cheap disks.
Alex Hillman
-Original Message-
Sent: Thursday, April 12, 2001 10:57 AM
To: Multiple recipients of list ORACLE-L
Chris,
First let me
; Subject: RE: Temporary Tablespace Design
>
> Kirti:
>The server is solely used for the Oracle Database
> and it has 2GB Ram. I didn't increase sort_area_size
> too much because I thought the table is so big, and
> probablay I could not run them in the memory. Th
Kirti:
The server is solely used for the Oracle Database
and it has 2GB Ram. I didn't increase sort_area_size
too much because I thought the table is so big, and
probablay I could not run them in the memory. That's
why I just try the temp tablespace.
Thanks,
Chris
--- "Deshpande, Kirti" <[E
Chris,
Some of what your saying would lead me to look at the wait_io in a the sar
output. You may want to talk with your SA as it sounds like you maybe IO bound.
That being the case it does not matter how much temp space you have, your just
sitting around waiting on the drive(s).
Kirti
I would suggest that you increase (as much as possible) sort_area_size and
sort_area_retained_size for your session when building indexes to minimize
temporary tablespace use. Making temporary tablepspace of type temporary and
adjusting default initial & next extent size can also help.
HTH..
- K
Steve,
Thanks for reminding me of that one other operation that does also take up
temp. Again, I think that depends on how often you calculate statistics & if
your using partitioning. We do statistics once a week, and do it partition by
partition so it does not take up that much.
Dick Goul
I'd be tempted to make it 4 times your largest expected working set, but how you
arrive at that figure is beyond me...
>>> [EMAIL PROTECTED] 04/12/01 04:05AM >>>
What's your experience about the temporary table
design? I read Michael Ault's Orcale8 Administartion
and Management , it says "For Co
Title: RE: Temporary Tablespace Design
Hi Chris,
Yes there may be 'rules' like this, but realistically who has 64GB to spend on disk space? I have one huge table similar to what you describe. My temp tablespace is 20GB only because I have the disk. Maybe you can take th
What's your experience about the temporary table
design? I read Michael Ault's Orcale8 Administartion
and Management , it says "For Cost-based optimization,
it should be 4 times of the largest table". I have a
table of 60 Million records, and it costs 16GB, should
I have a 64GB temp tablespace(I d
19 matches
Mail list logo
