Re: expdp and exp are slowing (iscsi)
From: Rodrigo Mufalani <rodrigo_at_mufalani.com.br>
Date: Wed, 30 Sep 2015 16:08:28 -0300
Message-Id: <1E655764-1ACB-484A-A53D-61E768518ED8_at_mufalani.com.br>
Hello,
>> Em 30/09/2015, à(s) 09:52, Michael McMullen <ganstadba_at_hotmail.com <mailto:ganstadba_at_hotmail.com>> escreveu:
>>
>> have you tried explicitly setting streams_pool_size? google streams_pool_size expdp or check out metalink.
>>
>> From: rodrigo_at_mufalani.com.br <mailto:rodrigo_at_mufalani.com.br>
>> Subject: expdp and exp are slowing (iscsi)
>> Date: Tue, 29 Sep 2015 18:42:47 -0300
>> To: oracle-l_at_freelists.org <mailto:oracle-l_at_freelists.org>
>>
>> Hi Folks,
>>
>> Our env:
>> Oracle 11.2.0.4 SE (64bits)
>> Windows 2012 (64bits)
>> ISCSI
>>
>> About one month ago one of our database servers, running on windows 2012 as I said on top, started an issue on logical backups (I tried expdp and exp) both of them are slowing generating dumps after 3 or 4 days after a boot on server. If we bounce only the database and listeners, the performance still poor. When we restart the entire OS, backups are generated with normal time, about 3 hours for a 1TB database, I think it is good.
>>
>> I’ve traced the backup sessions, a lot time on CPU and no events indicating I/O issues.
>>
>> My SysAdmin ran some storage performance softwares and haven’t issues evidenced. The users are not complaining about performance issues, only the backups, event the RMAN backup still running ok on same device.
>>
>> Any directions will be appreciated.
>>
>> All the best,
>>
>> Rodrigo Mufalani
>> Database Consultant
>> +55 XX(21) 3193-0326
>> rodrigo_at_mufalani.com.br <mailto:rodrigo_at_mufalani.com.br>
>> www.mufalani.com.br <http://www.mufalani.com.br/>
>>
>> "Stop guessing… Be Sure… Because performance matters"
>
Date: Wed, 30 Sep 2015 16:08:28 -0300
Message-Id: <1E655764-1ACB-484A-A53D-61E768518ED8_at_mufalani.com.br>
Hello,
In addition we are running these logical backup in a ReFS (Micro$oft), but this device was delivery to us a long time ago (more than year) and started issue about one month ago.
All the best,
Rodrigo Mufalani
Database Consultant
+55 XX(21) 3193-0326
rodrigo_at_mufalani.com.br
www.mufalani.com.br
"Stop guessing… Be Sure… Because performance matters"
> Em 30/09/2015, à(s) 09:59, Rodrigo Mufalani <rodrigo_at_mufalani.com.br> escreveu: > > Hi Michael, > > Yes, I was wondering about that bug, I’ve increased my streams_pool_size to 250mb and found in a german blog a simple solution, at least I don’t faced to the event "AQ: enqueue blocked on low memory” anymore, but still slow. > > The workaround for that bug that you pointed. > > http://www.dbmasters.at/db/masters/artikel/expdp-impdp-haengen-lange-zeit-und-sind-dann-sehr-langsam <http://www.dbmasters.at/db/masters/artikel/expdp-impdp-haengen-lange-zeit-und-sind-dann-sehr-langsam> > > SQL> alter system set aq_tm_processes=2; > > All the best, > > Rodrigo Mufalani > Database Consultant > +55 XX(21) 3193-0326 > rodrigo_at_mufalani.com.br <mailto:rodrigo_at_mufalani.com.br> > www.mufalani.com.br > > "Stop guessing… Be Sure… Because performance matters" >
>> Em 30/09/2015, à(s) 09:52, Michael McMullen <ganstadba_at_hotmail.com <mailto:ganstadba_at_hotmail.com>> escreveu:
>>
>> have you tried explicitly setting streams_pool_size? google streams_pool_size expdp or check out metalink.
>>
>> From: rodrigo_at_mufalani.com.br <mailto:rodrigo_at_mufalani.com.br>
>> Subject: expdp and exp are slowing (iscsi)
>> Date: Tue, 29 Sep 2015 18:42:47 -0300
>> To: oracle-l_at_freelists.org <mailto:oracle-l_at_freelists.org>
>>
>> Hi Folks,
>>
>> Our env:
>> Oracle 11.2.0.4 SE (64bits)
>> Windows 2012 (64bits)
>> ISCSI
>>
>> About one month ago one of our database servers, running on windows 2012 as I said on top, started an issue on logical backups (I tried expdp and exp) both of them are slowing generating dumps after 3 or 4 days after a boot on server. If we bounce only the database and listeners, the performance still poor. When we restart the entire OS, backups are generated with normal time, about 3 hours for a 1TB database, I think it is good.
>>
>> I’ve traced the backup sessions, a lot time on CPU and no events indicating I/O issues.
>>
>> My SysAdmin ran some storage performance softwares and haven’t issues evidenced. The users are not complaining about performance issues, only the backups, event the RMAN backup still running ok on same device.
>>
>> Any directions will be appreciated.
>>
>> All the best,
>>
>> Rodrigo Mufalani
>> Database Consultant
>> +55 XX(21) 3193-0326
>> rodrigo_at_mufalani.com.br <mailto:rodrigo_at_mufalani.com.br>
>> www.mufalani.com.br <http://www.mufalani.com.br/>
>>
>> "Stop guessing… Be Sure… Because performance matters"
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Sep 30 2015 - 21:08:28 CEST