Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

what is hot spot?

tahasozgenMay 23 2015 — edited May 23 2015

Hi There;

I am reading some content about the data warehouse, and I encountered a phrase as such:

(context) Hardware and I/O Considerations in Data Warehouses --> Automatic Striping -->

"For index probes (for example, within a nested loop join or parallel index range scan), operating system striping enables you to avoid hot spots by evenly distributing I/O across the disks." http://docs.oracle.com/cd/B10500_01/server.920/a96520/hardware.htm


what is hot spot? Could you please explain briefly; Thanks in advance.

Message was edited by: tahasozgen

This post has been answered by Girish Sharma on May 23 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 20 2015
Added on May 23 2015
1 comment
970 views