RE: Performance tuning

I agree. Is your Shared_pool_size set to 239MB? You can't ask Oracle to allocate this much memory with excessive swapping on your NT box. If you can't add mode RAM, I would cut that to around 50 MB. I would also do what Peter recommends below. There are always a few more things to try (like direct=true) but, you simply have too large of a db on your server.

Hth,
Frank Pettinato
Oracle DBA

-----Original Message-----
McLarty
Sent: Wednesday, May 30, 2001 4:22 AM
To: Multiple recipients of list ORACLE-L

Okay fill us in why would you try and inane thing like that on only 128MB RAM. NT would be barely running on that without getting your instance up. I am not that good yet at calculating what amount of RAM you need for a given SGA but I am thinking that you are running in swap

What is the disk configuration.

Are you running RAID and if so what configuration. (Not RAID 5 I hope)

Can you get this system up to 512MB at least.

With this and a whole lot more you will get some better answers

Peter
Trainee Oracle DBA

At 01:19 AM 30/05/2001 -0800, you wrote:

>HI ALL,
>We have to load almost 3 millions records of average row size of 150 bytes.
>We are importing data using sqloader with ROWS=4000 and bindsize=8450000 .
>We have adjusted the rollback segment to almost 10 m with 8 extents enough
>for single transaction size and considering 30% rollback overhead. We
>adjusted the OPTIMAL TO 10 M to have avoid rollback extension
>Rollback segment, databuffer cache have hit ratio of 100%.
>
>The loading was fast only for first 10 commits but then it slowed like
>snail. LOADING TOOK 22 hours in the first run on ORACLE8i NT4 128 megs RAM
>.
>SGA figures in M :
>NAME VALUE
>-------------------- ---------
>Fixed Size .0676384
>Variable Size 239.02734
>Database Buffers 39.0625
>Redo Buffers 7.8203125
> ---------
>sum 285.97779
>( we can't use direct path due to functions in sqlldr controlfile). .
>Couldn't figure out the bottleneck yet.
>Any ideas.
>TIA
>Azhar Siddiq,
>DBA
>LMK Resources
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author:
> INET: azhar_at_mathtech-pk.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Peter McLarty
  INET: peter.mclarty_at_incts.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Frank N. Pettinato
  INET: frankp_at_extremezone.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).