Unsolved
1 Rookie
•
23 Posts
0
357
May 29th, 2023 02:00
Oracle Backup slowness - Networker
Hello,
We were experiencing the slowness of oracle backup running on AIX. So i tried running the filesystem backup of the same AIX system and we got a good network throughput but the oracle backup alone was giving a low network throughput. To isolate the issue i tried running the filesystem backup for the path where oracle was installed which is /oracle and we were getting the low network throughput.
The /oracle path is connected with Storage LUNS from IBM DS box. from the DS box the Luns read and write Cache is enabled. Is there anything i need to be looking for this issue ?
No Events found!
barry_beckers
393 Posts
0
May 30th, 2023 15:00
You need to first be ruling out NW altogether, what are results of for example dd testing trying to read and write data to and from the filesystems that contain the Oracle DB data to be backed up? As filesystem backup seems to suggest it is also slower for those filesystems, compared to other filesystems?
So any testing is first to be performed from the client to and from its own storage and then work from there. If dd or similar tests (can't recall what kinda performance tests can be run on a AIX system) show performance is slow, then backup will encounter the same thing. So any testing would be performed, and possibly the result might show not having to do anything with Networker or any backup product...
ble1
2 Intern
•
14.3K Posts
0
June 2nd, 2023 10:00
Most likely if you have good reads from /a and slower reads from /b given that it is same host - difference is storage path (assuming it is not fs related and it is unlikely to be). You can create some random data file of couple GB size and place it on /a and /b (whatever would be corrensponding good and bad performance fs in your case). Then use some tool to read data into memory (in your case reads are related to backup performance) and see if there is difference. Your AIX admin will probably come up with some imaginative test scenarios in combination with iostat.
Saikat_33
1 Rookie
•
9 Posts
0
August 25th, 2023 17:53
try increasing channel