Here is the Gamespot Preview :
They also have a few more screenshots
They also have a few more screenshots
The real enhancement is in the visuals, and (to some extent) the loading times. The game seemed to have a slightly smoother and more consistent frame rate than it did on the Xbox, though the difference wasn't enormous, and it seemed to us that the textures looked just a tad bit sharper. More obvious (and confirmed by Bethesda) was an improvement to the game's texturing over large distances. Remember how the original Oblivion had a line set an arbitrary distance in front of the player beyond which ground textures turned into kind of a muddy mess? That's all taken care of now, thanks to a new custom pixel shader. The effect is only noticeable outdoors--though it's more accurate to say the effect is not noticeable if you've never played a previous version of the game--but it's a nice addition nonetheless.
Oblivion will make extensive use of the PS3's hard drive by caching multiple gigabytes of data, which seemed to help with load times from what we saw. Bethesda's Pete Hines also commented that recent reports of data duplication on the PS3 Oblivion disc have been exaggerated, and this technique isn't different than the similar strategy that was employed in the creation of the Xbox 360 game last year. Lastly, it's unclear if or when the PS3 will see the Shivering Isles content on the way to the PC and Xbox, though with a burgeoning PlayStation Network and plenty of unfilled hard drive space, it's not hard to imagine the expansion can be made available to PS3 owners somewhere down the road.