Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Performace question
sorry...
but what is not working ????
"Sybrand Bakker" <gooiditweg_at_sybrandb.verwijderdit.demon.nl> a écrit dans le
message de news: 2jniu0l0rpqlnn1psa35eottpeh8qb65aq_at_4ax.com...
> On Sat, 15 Jan 2005 16:10:32 +0100, "Antoine BRUNEL"
> <antoinebrunel_at_nospam_yahoo.fr> wrote:
>
>>Hi from Paris
>>
>>I would suggest to check PCTFREE and PCTUSED values, and eventually
>>extents
>>size...
>>
>>I mean:
>>- this is definitely a temporary table (from the application view)
>>- try to know the max rows this table has to handle -> this is the high
>>water mark, the table should be of 1 extent with the required size
>>- are the records only inserted then deleted ??? then : PCTFREE 0 and
>>PCTUSED 99 this will avoid wasting space
>
> Please do not top-post. People read from top to bottom not from bottom
> to top.
> As to your little strategy: It doesn't work. PERIOD. Been there, done
> that. It just doesn't work.
>
>
> --
> Sybrand Bakker, Senior Oracle DBA
Received on Sat Jan 15 2005 - 13:10:50 CST
![]() |
![]() |