>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 <[EMAIL PROTECTED]>
incts.com> cc:
Sent by: Subject: Re: Performance
tuning
[EMAIL PROTECTED]
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: [EMAIL PROTECTED]
>
>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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
