I did a quick check of some facts I’m studying about Oracle 12c and its new threaded execution mode. I set this parameter:
alter system set THREADED_EXECUTION=true scope=spfile;
I had to connect SYS as SYSDBA with a password to get the system to bounce.
Then it had these processes only:
oracle 1854 1 0 09:17 ? 00:00:00 ora_pmon_orcl
oracle 1856 1 0 09:17 ? 00:00:00 ora_psp0_orcl
oracle 1858 1 2 09:17 ? 00:00:00 ora_vktm_orcl
I just finished reading Sam Alapati’s 12c OCP upgrade book for the first time and I really like it because of the content that it covered which I hadn’t discovered through my study of the Oracle manuals. Also, it did a good job explaining some things that Oracle’s manuals left unclear.
After reading each chapter I took the end of chapter test and got between 60% and 75% of the questions right. Next (more...)
Yesterday I used Delphix to quickly recover ten production tables that had accidentally been emptied over the weekend. We knew that at a certain time on Saturday the tables were fully populated and after that some batch processing wrecked them so we created a new virtual database which was a clone of production as of the date and time just before the problem occurred. We could have accomplished the same task using RMAN (more...)
Sweet! I just installed the software from the CD that came with Sam Alapati’s book related to the OCP 12c upgrade exam and found that it has questions related to the key DBA skills section of the test. Now I feel good about my test preparation materials. The first time I took the test I didn’t have this degree of guidance on what to study, especially on the key DBA skills section.
I haven’t even started on Sam Alapati’s OCP book but I realized today that Matthew Morris’s OCP 12c upgrade book has an outline of the Key DBA Skills section of the OCP exam and that is what I need most. I was two questions away on that section when I took the test the first time and I need to make sure I’m studying the right things. After I got back to the (more...)
I think I’m done with the script for my Toastmaster’s talk: pdf
It’s Toastmaster’s talk 3 “Get to the Point” so I’m trying to do a 5-7 minute talk that focuses on how Oracle’s SQL optimizer sometimes chooses a slow plan. It’s tough to say anything meaningful in 7 minutes and I’m not using any kind of slides so I have to describe everything verbally.
But, it’s a topic I’m passionate about so I (more...)
I just finished working with a coworker on speeding up a PS/Query. It was running well in a development environment but not in production. I tried to find a simple hint or two to make production run like development but didn’t have any luck. Then I remembered that my script to get a query’s plan prints out a full set of outline hints like this:
I think I’ve run across a bug in 12c where v$sql_cs_statistics is not populated in 12c as it was in 126.96.36.199.
I’ve messed with adaptive cursor sharing using an example on Tim Hall’s web site: web example
I’ve tried to break it and change it in various ways to understand adaptive cursor sharing. I was using some 11g databases and on those systems the example results in output from v$sql_cs_statistics. (more...)
We have a Senior Oracle DBA position open on my team here in Tempe, Arizona.
Here is the link: url This link is for non-recruiters only.
We have a good team and would love to have someone join us.
I guess I should have waited around a bit longer before taking my 12c OCP upgrade exam. I purchased Kaplan’s Self Test software to prepare for the 12c OCP upgrade exam but it only included 50 questions and they only covered the first part of the OCP exam – the part I passed!
I noticed on the Self Test website that the test now includes 105 questions. So, I got the bright idea (more...)