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
We've been load testing an application that will be allowing customers to
enter their email information through the web. The loadrunner application
was experiencing periodic freezing after which it would go back to normal.
Reviewing the statspack information I saw a high number of buffer busy
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
-Original Message-
From: Miller, Jay [SMTP:[EMAIL PROTECTED]]
Sent: Friday, June 15, 2001 2:31 PM
To: Multiple recipients of list ORACLE-L
Subject: Increasing Freelists?
We've been load testing an application that will be allowing customers to
enter their email information through
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
, June 15, 2001 2:31 PM
To: Multiple recipients of list ORACLE-L
Subject: Increasing Freelists?
We've been load testing an application that will be allowing customers to
enter their email information through the web. The loadrunner application
was experiencing periodic freezing after
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
