RE: Performance tuning

>Since Data is being loaded in development environment. that is why we have
128 meg ram. (Regarding RAM i have no other choice) i have the NT performance monitor and it shows that it is not using swap heavily.

NT swaps heavily with 128Mb ram running office, you must have some sort of magical system to run oracle with such a large table on it.

"Walking on water and developing software from a specification are easy if both are frozen."

Christopher R. Spence
Oracle DBA
Fuelspot

-----Original Message-----
Sent: Wednesday, May 30, 2001 9:56 AM
To: Multiple recipients of list ORACLE-L

Actually we have to

Since Data is being loaded in development environment. that is why we have 128 meg ram. (Regarding RAM i have no other choice) i have the NT performance monitor and it shows that it is not using swap heavily. Currently disk configuration is not RAID . however we have no disk limit problem. i have autoexetended datafiles. Regards
Azhar              

                    Peter McLarty

                    <peter.mclarty@        To:     Multiple recipients of
list ORACLE-L <ORACLE-L_at_fatcity.com>       
                    incts.com>             cc:

                    Sent by:               Subject:     Re: Performance
tuning                                       
                    root_at_fatcity.co

                    m

 

 

                    05/30/2001

                    04:21 PM

                    Please respond

                    to 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: 
  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: Christopher Spence
  INET: cspence_at_FuelSpot.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).