Wow, must be in a new version of oracle.
Like 8.0.0.0.1
:)
-Original Message-
Sent: Friday, June 15, 2001 4:57 PM
To: Multiple recipients of list ORACLE-L
You can do an alter table TABLENAME storage freelists N
- Original Message -
To: Multiple recipients of list ORACLE-L
what is the name of the book by Gaja that you are referring to ?
-Original Message-
Sent: Friday, June 15, 2001 3:31 PM
To: Multiple recipients of list ORACLE-L
We've been load testing an application that will be allowing customers to
enter their email information through the web. The
Hi Jay,
If the table(s) need(s) to support multiple concurrent insert operations
from multiple transactions and you are seeing a lot of buffer waits then
adjusting freelists may help you. Setting it up to a max of twice the number
of CPUs should work (provided that the number of CPUs is not tool
The table must be dropped, yes.
Default for table is 1 freelist, 2 for indexes.
This is not scientific ( both because there are no
data to support it in your post and I have no hard
perf data of my own ) but freelists are small and
easily/rapidly maintained. Unless you have some
sort of
You can do an alter table TABLENAME storage freelists N
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, June 15, 2001 4:01 PM
The table must be dropped, yes.
Default for table is 1 freelist, 2 for indexes.
This is not scientific ( both
Oracle Performance Tuning 101 by Gaja Krishna Vaidyanatha and Kirtikumar
Deshpande
From: Anthony Hogan [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Increasing Freelists?
Date: Fri, 15 Jun 2001 12:01:04 -0800
what
Thanks Kirti.
I had already found 1029850.6 and was reading through it. It recommended
setting freelists to the maximum number of concurrent processses performing
simultaneous inserts to the table. Thanks for the tip on not setting it to
more than 2x #of CPUs.
And thank you very much for
As of 8.1.6. Before that, you needed to rebuild the table.
Gary Kirsh
Next Extent, Inc.
-Original Message-
Sent: Friday, June 15, 2001 4:57 PM
To: Multiple recipients of list ORACLE-L
You can do an alter table TABLENAME storage freelists N
- Original Message -
To: Multiple