Re: Perfomancetuning a simple but large table

I can make one suggestion. Create two tablespaces, one for the table and one for the index.

create tablespace telekat_table

        datafile '/orcl1/oradata/whatever' size 50m;

create tablespace telekat_indexes

        datafile '/orcl2/oradata/whatever' size 50m;

Be sure to place these tablespaces on separate disks. Also, I just guessed at those sizes.

Recreate your table and index, assigning them to those tablespaces:

>create table TELEKAT (
> RUBRIK varchar2(255),
> NAMN varchar2(127),
> ORT varchar2(63),
> DETALJ long,
> TELEFON varchar2(63),
> MOBILTELEFON varchar2(63),
> FAX varchar2(63)
> ) tablespace telekat_table
> storage (maxextents unlimited);

>create unique index TELEKAT_UNIQUE on TELEKAT(
> RUBRIK,
> NAMN,
> ORT,
> TELEFON,
> MOBILTELEFON,
> FAX
> ) tablespace telekat_indexes storage (maxextents unlimited);

The above will also address the other possible problem that I was worried about. I was worried that you might have created these in the system tablespace.

regards,

Jonathan Gennick --- Brighten the Corner Where You Are mailto:jonathan_at_gennick.com
http://gennick.com

On Sat, 01 May 1999 20:15:02 GMT,
jonasmalmsten_at_my-dejanews.com wrote:

>Hi!
>
>I want to setup an Oracle database that will contain only on but a large
>table. I tried this using the preconfigured database that installes with
>Oracle, run the following script from SQL Plus.
>
>create table TELEKAT (
> RUBRIK varchar2(255),
> NAMN varchar2(127),
> ORT varchar2(63),
> DETALJ long,
> TELEFON varchar2(63),
> MOBILTELEFON varchar2(63),
> FAX varchar2(63)
> );
>
>create unique index TELEKAT_UNIQUE on TELEKAT(
> RUBRIK,
> NAMN,
> ORT,
> TELEFON,
> MOBILTELEFON,
> FAX
> );
>
>The index is used only to ensure uniqueness. At start everything works ok,
>but after adding around 5000 records it starts getting slow. If I close my
>client application and restart it things start go really slow (several
>seconds for every insert). The client is a simple delphi application using
>delphi standard components. My goal is to insert 500000 records.
>
>Thanks for any help
>
>//Jonas
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Sun May 02 1999 - 19:23:33 CDT