Which would you choose Sql or Performance tuning
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Which would you choose Sql or Performance tuning

  1. #1
    Join Date
    Nov 2000
    Posts
    126

    Question

    If you're down to the final two. Which would you choose and why? Pl/Sql or Performance Tuning. Both seem to have the same equal level of difficulty...

  2. #2
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    Depends what preconceptions you have on each on them both. Most people say Perf Tuning is one of the hardest. Id say they were pretty much on a par. But if I was making a choice, I'd take Perf Tuning, just get it out of the way. When you pass that, it should fill you with enough confidence to easily pass the SQL exam not to long after.

    Cheers,
    OCP 8i, 9i DBA
    Brisbane Australia

  3. #3
    Join Date
    Aug 2001
    Posts
    27
    I haven't taken P&T yet, but if you've got quite a bit of experience with SQL syntax, I'd do the PL/SQL first. To prep for that one I just used Couchman's book and the sample test. I don't think it was very hard, mostly a lot of syntax questions. I've heard P&T focuses a lot on the V$ views....what's in each one, which one to query when, etc..

  4. #4
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by Rookie
    If you're down to the final two. Which would you choose and why? Pl/Sql or Performance Tuning. Both seem to have the same equal level of difficulty...
    Have you ever worked as a developer? I assume not, because otherwise you would have then taken PL/SQL first. If I am right in my assumption, go to Tuning next and let SQL be the final trap :-)


  5. #5
    Join Date
    Jan 2001
    Posts
    3,131
    This all depends on the individual. For me PL/SQL was a living hell, I failed it twice. Prior to that I had no programming experience so that is one reason. I did have Oracle installed at home and practiced my butt off each time I took it.

    Oddly enough as hard as Perf. Tun. was it was that exam that I scored highest on, I was surprised!

    So, my vote is get pl/sql out of the way, but be afraid, be very afraid. Bwoo ha ha ha harrrrrrrrrrr
    MH

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width