asktom.oracle.com is something of a gem within that site. The navigation isn't great but there's a lot of good "how to" questions and answers there. I found it very helpful when I was working with Oracle. Also I recommend Tom Kyte's books. He's definitely an Oracle evangelist, but he knows what he's talking about.