Skip to Main Content

Breadcrumb

May 4th

Question and Answer

Connor McDonald

Thanks for the question, Pradeep.

Asked: July 22, 2018 - 2:47 pm UTC

Last updated: July 26, 2018 - 2:29 am UTC

Version: 11.2.0.4

Viewed 1000+ times

Comments

Many thanks

Pradeep prajapati, July 23, 2018 - 12:30 pm UTC

Dear Sir,

Many thanks for for input.
Just one more help.
Please help me to undersatnd cpu bound and IO bound with example.

Thanks
Pradeep

Connor McDonald
July 26, 2018 - 2:29 am UTC

CPU bound

You cannot get work performed faster because the machine is running at 100% CPU. So even if your disks could provide more data to the server, it wont help because it is consuming all CPU already.

IO bound

You cannot get work performed faster because the disks serving the machine cannot provide the data any faster - they are flat out. So even if your machine is only running at 50% CPU, nothing can make it run faster because the disks cannot provide the data fast enough


Thanks for help

Pradeep Kumar, July 24, 2018 - 1:26 pm UTC


Many thanks for making me to understand which i unable to get from other resources.


Connor McDonald
July 25, 2018 - 12:49 am UTC

glad we could help

two CPU bound in the above followup

Rajeshwaran Jeyabal, July 25, 2018 - 9:13 am UTC

.....
CPU bound

You cannot get work performed faster because the machine is running at 100% CPU. So even if your disks could provide more data to the server, it wont help because it is consuming all CPU already.

CPU bound

You cannot get work performed faster because the disks serving the machine cannot provide the data any faster - they are flat out. So even if your machine is only running at 50% CPU, nothing can make it run faster because the disks cannot provide the data fast enough
.....


hope the second detailed response should be for "IO bound" and not "CPU bound " - currently it is mentioned as "CPU bound" in both places.
Connor McDonald
July 26, 2018 - 2:29 am UTC

Ah...cut/paste fail - will fix.

More to Explore

Performance

Get all the information about database performance in the Database Performance guide.