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" <
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 re
> 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 web. The loadrunner applicatio
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,
not in 8i -- you can adjust freelists on the fly
>From: "Mohan, Ross" <[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:05 -0
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
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 "niche
> -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
>
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
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 wai
10 matches
Mail list logo