Oracle 11gr2
OS: Linux 6
We had some performance issue during rolling forward a DB clone(applying archived logs). We used 4 channels for recovering database. I am trying to figure out if I am using correct number of channels.
1. what is the formula for number of channels?
2. how to find how many cores do I have on the physical Linux server?
Note: I am waiting for a response about the i/o throughput from the storage admin.
I ran these command but not sure which number is correct.
| $ grep "physical id" /proc/cpuinfo | sort -u | wc -l |
| 2 | | | |
| | | |
| cat /proc/cpuinfo |grep "physical id" | sort -u | wc -l |
| 2 | | | |
| | | |
| $ grep "cpu cores" /proc/cpuinfo |sort -u |cut -d":" -f2 |
| 6 | | | |
| $ grep -c "processor" /proc/cpuinfo |
| 24 | | | |
| | | |
| cat /proc/cpuinfo | grep processor | wc -l |
| 24 | |