SLOB 2.3 Data Loading Failed? Here’s a Quick Diagnosis Tip.

The upcoming SLOB 2.4 release will bring improved data loading error handling. While still using SLOB 2.3, users can suffer data loading failures that may appear–on the surface–to be difficult to diagnose.

Before I continue, I should point out that the most common data loading failure with SLOB in pre-2.4 releases is the concurrent data loading phase suffering lack of sort space in TEMP. To that end, here is an example of a SLOB 2.3 data loading failure due to shortage of TEMP space. Please notice the grep command (in Figure 2 below) one should use to begin diagnosis of any SLOB data loading failure:

#000000;" src="https://kevinclosson.files.wordpress.com/2016/12/screen-shot-2016-12-27-at-3-37-20-pm.png?w=500&h=363" alt="screen-shot-2016-12-27-at-3-37-20-pm" width="500" height="363" srcset="https://kevinclosson.files.wordpress.com/2016/12/screen-shot-2016-12-27-at-3-37-20-pm.png?w=500&h=363 500w, https://kevinclosson.files.wordpress.com/2016/12/screen-shot-2016-12-27-... 150w, https://kevinclosson.files.wordpress.com/2016/12/screen-shot-2016-12-27-... 300w, https://kevinclosson.files.wordpress.com/2016/12/screen-shot-2016-12-27-... 768w, https://kevinclosson.files.wordpress.com/2016/12/screen-shot-2016-12-27-... 973w" sizes="(max-width: 500px) 100vw, 500px" />

Figure 1

And now, the grep command:

#000000;" src="https://kevinclosson.files.wordpress.com/2016/12/screen-shot-2016-12-27-at-3-37-42-pm.png?w=500&h=69" alt="screen-shot-2016-12-27-at-3-37-42-pm" width="500" height="69" srcset="https://kevinclosson.files.wordpress.com/2016/12/screen-shot-2016-12-27-at-3-37-42-pm.png?w=500&h=69 500w, https://kevinclosson.files.wordpress.com/2016/12/screen-shot-2016-12-27-... 150w, https://kevinclosson.files.wordpress.com/2016/12/screen-shot-2016-12-27-... 300w, https://kevinclosson.files.wordpress.com/2016/12/screen-shot-2016-12-27-... 731w" sizes="(max-width: 500px) 100vw, 500px" />

Figure 2

 

Filed under: oracle Tagged: Exadata, Oracle Performance, Random I/O, SLOB, SLOB Testing, Xeon E7 Performance