Hi DBA gurus,
One of the application is going live .At presenr data is 15GB and will
grow more by 10 GB in year time. What is the right approach of
tablespace design having more files of smaller size(10 files of 2 GB )
or less file of bigger size (3 files of 8 gb ).
No tables
, then key in on v$waitstat. You might get a copy of Gaja's book
Oracle Performance Tuning 101. Then you'll really impress him.
If you have everything on a single drive, tablespace design probably
isn't going to buy you much in terms of performance. Myself, I would tend to
tune the memory buffer cache
?
-Original Message-
Sent: Wednesday, August 28, 2002 1:13 AM
To: Multiple recipients of list ORACLE-L
Hi DBA gurus,
One of the application is going live .At presenr data is 15GB and will
grow more by 10 GB in year time. What is the right approach of
tablespace design having more files
-Original Message-
Sent: Wednesday, 28 August 2002 6:13 PM
To: Multiple recipients of list ORACLE-L
Hi DBA gurus,
One of the application is going live .At presenr data is 15GB and will
grow more by 10 GB in year time. What is the right approach of
tablespace design having more files of smaller size
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
, 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 - [EMAIL PROTECTED] eg
[EMAIL PROTECTED] Emails using
: 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 format will continue to be
delivered until 30th June 2001
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, but
]]
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 email addresses of the
staff has changed to the following - [EMAIL PROTECTED] eg
[EMAIL
-
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,
After the sort phase is complete, Oracle will trigger
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 remains
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 Design
I think you are not correct. First - Oracle allocates
]]
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 email addresses of the
staff has changed to the following - [EMAIL PROTECTED] eg
:Temporary Tablespace Design
Thanks Dick and Lisa for answering my question.
I
think I am going to either let the file
auto-extend,
or will try a smaller file as a start. I found
my
temp
tablespace is too small(1GB) because it seems
like
takes forever to rebuild an index with
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 the route
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
Chris,
First let me say that I have a TON of respect for Mike and count him as a
friend. That said, I also take exception to many of his pronouncements from a
practical, not theoretical, point of view. Given infinite resources, like disk
space and memory and CPU, he does have it absolutely
Thanks Dick and Lisa for answering my question. I
think I am going to either let the file auto-extend,
or will try a smaller file as a start. I found my temp
tablespace is too small(1GB) because it seems like
takes forever to rebuild an index with nologging. I
have 11 indexes on this tables, and
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
Subject:Re:Temporary Tablespace Design
Thanks Dick and Lisa for answering my question. I
think I am going to either let the file
auto-extend,
or will try a smaller file as a start. I found my
temp
tablespace is too small(1GB) because it seems like
takes forever to rebuild an index with
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. That's
why I just try the temp tablespace.
Thanks,
Chris
I think you missed analyze operation. It is for this command is 4xtable
size 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,
22 matches
Mail list logo