Re: Pctfree and Pctused tuning

Hi, First off, your English is fine...don't apoligize for it in the future. As long as you try, no one can hold it against you.

There is no direct way of tuning PCTFREE/PCTUSED that I know of. You can determine if you have problems if you have block contention or free list contention. Even then, you can repair the problem without changing PCTFREE and PCTUSED.Your main aim in tuning space management is to make sure that rows are stored in blocks as economically as possible. This may mean changing PCTFREE and PCTUSED if blocks have wasted space. PCTFREE/PCTUSED are used to regulate free space within a block. Set PCTFREE to zero for static reference tables. For updated tables, use the following formula: PCTFREE = 100 * a/(a+b) where a is the average amount added by updates, in bytes where b is the average initial row length

If you need scripts to determine if you have Free List contention or block contention, then let me know.

Good Luck to you...
Satar Naghshineh

PS I stole most of the above statements from "ORACLE7 Server: Performance Tuning, Volume One - Student guide"
In article <70kl5j$4km$1_at_SOLAIR2.EUnet.yu>,   "Nebojsa Petrovic" <nebacar_at_eunet.yu> wrote:
>
> Hi,
>
> Sorry for my bad english.
>
> I know what storage parameters pctfree and pctused mean fo Oracle.
> during using aplication tables come in and come out in free list depends of
> parameters pctfree and pctused .
> How can I trace, tuning and monitoring these parameters?
> In which system tables Oracle put information about using them.
> Where can I found script which perform monitoring storage parameters
>
> Thanks in advance
>
> --
> Petrovic Nebojsa
>
>

--
Oracle DBA/UNIX System Admin
Advanced Enterprise Solutions
(949) 756-0588
Oracle Re-Seller

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Oct 21 1998 - 16:42:16 CDT