Re: Performance problem: Loading data via insert
From: David Fitzjarrell <oratune_at_yahoo.com>
Date: Fri, 14 Mar 2014 07:47:30 -0700 (PDT)
Message-ID: <1394808450.64994.YahooMailNeo_at_web124706.mail.ne1.yahoo.com>
http://dfitzjarrell.wordpress.com/2011/08/26/parallel-universe/ David Fitzjarrell Primary author, "Oracle Exadata Survival Guide" On Thursday, March 13, 2014 2:43 PM, Sameer Choudhari <sameer.choudhari_at_gmail.com> wrote: Try tuning your insert statements with hints like PARALLEL NOLOGGING . On Friday, 14 March 2014, Carlos Sierra <carlos.sierra.usa_at_gmail.com> wrote: Abhishek, > > >As always, start with the evidence: >What facts have you collected? What is AWR telling you? What are the SQL Traces telling? Which other diagnostics tools have you used for your case? > > >Cheers, > >Carlos Sierra > >blog: carlos-sierra.net >twitter: _at_csierra_usa > >Life's Good! > >On Mar 13, 2014, at 6:52 AM, Abhishek Gurung <abhishek.gurung_at_hotmail.com> wrote: > >Hi >> >>We are facing a performance problem but unable to identify where is the problem. >> >>We have a production database server where about 8 database instances of oracle is running. >>Daily we insert in each of these database instances about 1-5 GB of data in different tables. >>All database instances are working fine where we are able to load around 2-3 GB of data within 1hour except >>1 where it is taking about 8 hrs to load only 4 GB of data. >> >>When I try to load the same 4GB of data in another database where only one instance is running and with >>very less configuration as compared to the Production server we were able to load it in 1hr 45 minutes. >> >>Can anyone suggest how can we proceed to identify the problem? >> >>Regards >>Abhishek > -- Sent from Google Nexus
Date: Fri, 14 Mar 2014 07:47:30 -0700 (PDT)
Message-ID: <1394808450.64994.YahooMailNeo_at_web124706.mail.ne1.yahoo.com>
http://dfitzjarrell.wordpress.com/2011/08/26/parallel-universe/ David Fitzjarrell Primary author, "Oracle Exadata Survival Guide" On Thursday, March 13, 2014 2:43 PM, Sameer Choudhari <sameer.choudhari_at_gmail.com> wrote: Try tuning your insert statements with hints like PARALLEL NOLOGGING . On Friday, 14 March 2014, Carlos Sierra <carlos.sierra.usa_at_gmail.com> wrote: Abhishek, > > >As always, start with the evidence: >What facts have you collected? What is AWR telling you? What are the SQL Traces telling? Which other diagnostics tools have you used for your case? > > >Cheers, > >Carlos Sierra > >blog: carlos-sierra.net >twitter: _at_csierra_usa > >Life's Good! > >On Mar 13, 2014, at 6:52 AM, Abhishek Gurung <abhishek.gurung_at_hotmail.com> wrote: > >Hi >> >>We are facing a performance problem but unable to identify where is the problem. >> >>We have a production database server where about 8 database instances of oracle is running. >>Daily we insert in each of these database instances about 1-5 GB of data in different tables. >>All database instances are working fine where we are able to load around 2-3 GB of data within 1hour except >>1 where it is taking about 8 hrs to load only 4 GB of data. >> >>When I try to load the same 4GB of data in another database where only one instance is running and with >>very less configuration as compared to the Production server we were able to load it in 1hr 45 minutes. >> >>Can anyone suggest how can we proceed to identify the problem? >> >>Regards >>Abhishek > -- Sent from Google Nexus
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Mar 14 2014 - 15:47:30 CET