Back in my designer days I used 'Oracle Designer 2000'; at the time it was just about the only tool available, but as the years & my jobs have since moved on I'm not sure if anything else has come along.

Now if I want to visualize my Db design I just close my eyes & think hard