So i want to know the differences (topics, etc) between D52163GC20 and D52163GC10.I pulled up the two URLs from your post, then clicked on the topics for one, cut & pasted into Notepad. I then opened the second URL and did the same. They contain most of the same topics, but the order is quite different. It looks like the Release II is simply an updated version of the firs. It may be updated for 11G Release 2, or it may simply be Release II of the course. I certainly can't see taking both of them given the degree of commonality. The 1Z0-117 test is going to have the very latest information since it's not even production yet, so there doesn't seem to be any reason to even consider taking the earlier SQL Tuning workshop if the purpose is preparing for the exam.
Roger25 wrote:Its like the difference between Roger22 and Roger25. ;-)
Romania, but now I see, clicking on that course gives me on the GC20 course page
I think it's all about money here (the newer course)... looking at differenced between 11gR1 and 11gR1, I did not find any major changes in SQL tuning between the two
... looking at differenced between 11gR1 and 11gR1, I did not find any major changes in SQL tuning between the twoActually, I did. I lined the topics lists of the two up and deleted all topics that were identical or obviously the same topic renamed. That left a considerable number in the Release 2 workshop (below). A number of topics from Release 1 were dropped. By far the largest single common factor in the eliminated topics was HINTs. Oracle is moving away from these, so that makes sense. I might have missed a few more commonalities, but the below list is a fair indicator of what is 'new' in the Release II workshop. They are in alphabetical rather than topical order because that's how I matched up the two workshops to remove the duplicates.
You haven't deleted.. for example "Plan Generator", or "Result Cache Operator", and many other titles are found also in the first course too.I don't see either of these in the course topics listed for Oracle Database 11g: SQL Tuning Workshop:
...Maybe what we see here ... isn't so detailedThere's not much I can do about that. Since you have the book, you could take my list as a starting point and remove ones like this to provide a more complete comparison in this thread... for others that might be interested. This certification is likely to become very popular shortly...
...also i don't know why HINTS were removed from release II..Just saw this. Oracle seems to be moving away from hints in favor of SQL Profiles. There are a number of issues with using HINTs to tune SQL performance. They are labor-intensive, can't always be used (as with packaged applications), and don't evolve if the data changes such that they are no longer appropriate (among other issues).