on 03-10-2014 3:48 PM
Dear Team,
We are facing the issue that after compression activity we are not getting the good performance and also backup with the third party tool going very slow ,earlier transfer rate of back was 2500 kbps , but not it reduce to 200 kbps, please advice something just after the compression we was getting very good speed also till 3 to 4 hour after that automatically its reduces ..oracle version is 11.2.0.3 (SBP 24)
Need your expert advice on the same..
Regards,
RK
Hi Nick,
I got the following Notes related to Backup issue,.
1628116 - Long runtimes of RMAN backups in Oracle 11g
1692866 - RMAN backups are taking longer after table compression
RK
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Deepak,
Thanks for the response,
1) Please provide details on what kind of compression has been implemented ( Tablespace compression or table column compression )
Tablespace
2) Also what is the impression on performance ? Which transactions are being slow ?
We have done for CRM , CRMWEBUI is slow .
3) Did you check backup using RMAN or brtools what is the transfer rate ?
RMAN(Now 200 KBPS before it was 2500Kbps)
RK
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
For system response time - You should check whether it is happening for entire system or for specific Tcodes. Trace one of the transaction and check for the clue where it is taking long time (update etc.).
For backups - There is no such direct impact with compression, backup time is majorly depended on the database size and the backup speed. Compression never increase the backup execution time (most/almost all of the customers got positive response that backups are 3 times faster after this).
Check whether your third party tool is supporting the compressed database backups or not?
Regards,
Nick Loy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Rableen,
1) Please provide details on what kind of compression has been implemented ( Tablespace compression or table column compression )
2) Also what is the impression on performance ? Which transactions are being slow ?
3) Did you check backup using RMAN or brtools what is the transfer rate ?
Regards,
Deepak Kori
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.