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).
