Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Performace question

Re: Performace question

From: Antoine BRUNEL <antoinebrunel_at_nospam_yahoo.fr>
Date: Sat, 15 Jan 2005 20:10:50 +0100
Message-ID: <41e96aba$0$13404$79c14f64@nan-newsreader-06.noos.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US