How to Scroll Explain plan window?

[Jeff Hunter]

Using 5.1.6.747 with oracle 8.1.7 client on 9.2.0.5 database.

When I explain a query, how do I get a horizontal scroll bar to appear so I can see the other information (such as partition start/stop, etc.) that are outside the bounds of the window?

 

[ScottMattes]

If this is what I think, there is a 'bug' in the grid component used by PLSD and the work around is to widen the column that is the next to last column on the right, so that it goes to the right hand margin - once that is done the horizontal scroll bar appears and you can see the rest of the grid.

 

[Marco Kalter]

This is actually fixed in 6.0, where the 5.1 grid component is replaced with a component that has a proper horizontal scrollbar.

 

[jasonvogel]

Existing bug / enhancement request. I've been asking Marco to fix this for years. It is a third-party component that they use that's broken.

Jason

 

[Jeff Hunter]

Thanks all. Looks like upgrade to 6.x is the best answer.