Category Archives: Uncategorized

Yesterday and today I’ve read or heard two people mention the force_match => TRUE parameter value for DBMS_SQLTUNE.IMPORT_SQL_PROFILE and how it forces a profile to work on all SQL statements that are the same except for their literal values.  So, … Continue reading →

I saw this fun blog post about the Arizona Oracle User Group getting organized: blog post(updated with meetup page). I’m definitely interested in being involved.  Please pass this on to any Oracle DBAs, developers, etc. that you know in the … Continue reading →

This graph represents commit time compared to CPU utilization and redo log write time.  I’ve included only the hourly intervals with more than 1,000,000 commits.  At these peaks the number of commits ranges 1 to 1.6 million commits per hour … Continue reading →

I am learning about how well commits scale on Oracle 11.2 and so far they seem to scale surprisingly well. I’ve looked at two waits – log file parallel write and log file sync.  Based on documents I’ve read on … Continue reading →

Well, I finally passed the Oracle Certified Professional (OCP) 12c upgrade exam, 1Z0-060.  I got 86% right on the new features section and 78% correct on the general DBA section.  So, that means I missed roughly 7 questions on each … Continue reading →

I came up with a simple query that shows a running SQL executing a different plan than what it had in the past.  Here is the query: — show currently executing sqls that have history — but who have never … Continue reading →

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 … Continue reading →

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 … Continue reading →

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 … Continue reading →

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 … Continue reading →