Patch 19183482 resolves ORA-01403 getting plan with baseline

I was testing SQL plan baselines on a base 11.2.0.3 release of Oracle on a 64 bit Linux virtual machine.  I ran DBMS_SPM.LOAD_PLANS_FROM_CURSOR_CACHE to create a SQL plan baseline for a test query after running that query once to get its plan in the cursor cache.  When I ran the test query after creating the SQL plan baseline and called dbms_xplan.display_cursor to see its new plan I got (more...)

Preparing for Oracle OpenWorld

The big annual Oracle event is almost here – starting Sunday 28 Sep with the User Group Sunday followed by four days of presentations in around 50 tracks!

If the agenda seems a bit overwhelming, read the OTech Magazine Special OpenWorld Issue to find some of the highlights and can’t-miss sessions.

My sessions are:

  • Mastering Oracle ADF Bindings: Advanced Techniques (UGF3484). Sunday Sep 28 at 10am in Moscone South room 270
  • Starting Your Oracle Application (more...)

On the Topic of Technology… 7

September 26, 2014 (Back to the Previous Post in the Series) As I was walking from the back of the facility where I work to my office just recently, I started repeatedly saying to myself as I approached the office door, “that huge computer was not here when I started calling my office a second home“.  I […]

Where the real technical talks are at OOW

What are the real technical talks at OOW amid all the marketing fluff? I don’t know all of them but I can vouch for the following

 

time id speaker room title
Sunday 9:00 UGF2563 Jeremiah Wilton, Marc Fielding M South 309 24/7 Availability with Oracle Database Application Continuity
9:00 UGF4378 Gwen Shapira M South 308 Analyzing Twitter Data with Hadoop – Live Demo
10:00 UGF3587 Tim Gorman M South 301 Scaling To Infinity: Partitioning (more...)

Query to show sql_ids related to SQL Profiles

I have a number 0f SQL Profiles on a database I’m working on and I wanted to know the sql_id of the SQL statements that they relate to.  Here is what I came up with:

select distinct 
p.name sql_profile_name,
s.sql_id
from 
dba_sql_profiles p,
DBA_HIST_SQLSTAT s
where
p.name=s.sql_profile;

Here is the output on my system:

SQL_PROFILE_NAME               SQL_ID
------------------------------ -------------
coe_5up1944u1zb7r_1979920644   5up1944u1zb7r
coe_b9ad7h2rvtxwf_3569562598   b9ad7h2rvtxwf
coe_9f21udzrfcygh_2815756405   9f21udzrfcygh
coe_366brswtxxuct_10194574     366brswtxxuct
coe_2261y37rp45py_2815756405   2261y37rp45py

These are (more...)

Openworld day minus 3

Its day minus 3, or day +1 depending on your point of view at Openworld 2014.

I’m here a few days early for the Ace Director briefings, where a selection of product managers provide an insight into what is coming in the Oracle world, either at Openworld or in the coming year.

I must admit, I arrived to the briefings somewhat sceptical because a couple of years ago, when I was last at the briefings, (more...)

Oaktable World & Delphix Labs on Mon & Tues

Next week during Oracle Open World, be sure and come on Monday and Tuesday to the free Oaktable World and  on Tuesday to Delphix hands on lab and free 90 day trial version at #CloneAttack at the same venue as Oaktable World.   The labs will also be joined by DBvisit for #RepAttack and Solarwinds (Confio) for #MonitorAttack.

 

Screen Shot 2014-09-12 at 12.38.32 PM

Screen Shot 2014-09-25 at 8.30.39 AM

Beer, Meat, Explode

 

Screen Shot 2014-09-15 at 10.57.34 AM

 

Screen Shot 2014-09-15 at 10.57.41 AM

Screen Shot 2014-09-22 at 7.18.15 AM

 

 

My Data Model Checklist book is now available in Spanish – Just in time for #OOW14!

Originally posted on Oracle Data Warrior:

Exciting news!

I just got this email from Amazon:

Congratulations, your book “UNA LISTA DE VERIFICACIÓN PARA REALIZAR REVISIONES A LOS DISEÑOS DE MODELOS DE DATOS” is live in the Kindle Store and is currently enrolled in KDP Select. It is available for readers to purchase here.

If you are in Mexico, you can get the book here.

If you are in Spain, you can get it here.

(more...)

Oracle Open World schedule

Here is my schedule of presentations at Open World this coming week.

I most excite about my talk on Sunday. The Phoenix Project is a awesome book everyone should read, DevOps is the rising star of IT and this talk will empower DBAs to take their careers to the next level with data virtualization – virtualize, govern and deliver data efficiently boosting your companies efficiencies and bottom line much greater than any other change one could make (more...)

Startup upgrade suppresses ORA-00955 on create table WRH$_SQL_PLAN

Today I was trying to see if upgrading from 11.2.0.2 to 11.2.0.4 would change the SYS.WRH$_SQL_PLAN table.  This table is large on our production system so I wanted to find out if some time-consuming update to this table would occur that would slow down our production upgrade but not be detected on our test systems.  We recently performed this upgrade on our development database and I (more...)

Delphix trial version available for first time : #CloneAttack

At Oracle Open World we will be leading hands on labs to install a fully operation Delphix environment on your laptop.

The labs will be hosted at the Creativity Museum, the same location as Oaktable World on Tuesday Sept 30 from 10am to 5pm. Solarwinds Confio and DBvisit will also beholding #MonitorAttack and #RepAttack in the same location.

The labs for Delphix will be led by

Jonathan Lewis explains Delphix internals

Last week we had a great webinar with Jonathan Lewis as he explained his hands on experience of Delphix, how Delphix works internally and some use cases that Delphix solves for Jonathan.

Jonathan will be joining us a the Delphix booth at Oracle Open World and giving shorter version of the presentation at 10am on Monday and Tuesday and 11am on Wednesday.

Also Jonathan will be speaking at Oaktable World on both Monday 1pm and (more...)

Oracle Forms 12c?

Some people wonder whether there will be a 12c version of Oracle Forms or not.

Instead of making guesses, the best way is to ask the people who know best.
So, after getting this question, I asked Michael Ferrante, Oracle Forms Product manager.

Here’s his answer:

Version 12 of Forms and Reports is tentatively planned for releases sometime in CY2015.  At this time, we (Oracle) are not permitted to share exact dates, but (more...)

High log file sync waits? Check log parallelism!

Log parallelism is an optimization introduced in 9.2 that reduces latch contention due to redo copy to the log buffer by enabling multiple public redo buffers (or “strands”). In many cases, however, it can cause a massive degradation of commit performance (“log file sync” wait increase). In this blog post, I will describe the mechanism, illustrate it with test results, and discuss solutions. Tests were performed on several different 11gR2 databases on Solaris servers.

Log parallelism

Log parallelism is controlled by (more...)

Oracle Open World: Oaktable speakers at Delphix booth

Screen Shot 2014-09-19 at 2.16.51 PM


Planning to attend Oracle OpenWorld this year? 

If so, stop by to visit Delphix at booth 821 and hear from Oracle industry luminaries such as Jonathan Lewis, Tim Gorman, Kyle Hailey, Ben Prusinski and the Oracle Alchemist, Steve Karam.

  • Taking Back Your Time: The Power of Virtual Databases, Jonathan Lewis
  • Virtual Data Platform: Revolutionizing Database Cloning, Kyle Hailey
  • Virtual Data for the High Performance Warehouse, Steve Karam
  • Transforming IT Infrastructure, Tim Gorman
  • Oracle E-Business Suite (more...)

ps and top differences with HugePages

The Unix utilities ps and top report memory differently with HugePages than without.

Without HugePages ps seems to include the SGA memory under the SZ column:

UID        PID  PPID  C    SZ   RSS PSR STIME TTY          TIME CMD
... 
oracle    1822     1  0 846155 16232  0 07:19 ?        00:00:00 ora_d000_orcl
oracle    1824     1  0 846155 16228  0 07:19 ?        00:00:00 ora_d001_orcl
oracle    1826     1  0 846155 16236  0 07:19 ?        00:00:00 ora_d002_orcl
oracle    1828     1  0 846155  (more...)

Jonathan Lewis explains Delphix live Sept 18th

Join myself and Tim Gorman as we host a live webinar  and Q&A September 18th at 10am PST  with Jonathan Lewis. Jonathan will explain from his on experiences how Delphix works and what industry problems it solves.

Click here to register for our webinar.

Screen Shot 2014-05-21 at 8.08.47 AM

Screen Shot 2014-05-21 at 8.08.47 AM
Screen Shot 2014-05-21 at 8.08.47 AM

Jonathan explains issues and obstacles to creating “thin clones” on typical industry hardware:

Screen Shot 2013-07-15 at 10.13.05 PM

how point in time snapshots work
Screen Shot 2013-07-15 at 10.12.07 PM

And from point in time snapshots, he explains how clones can rapidly be made.

Screen Shot 2013-07-15 at 10.12.37 PM

Related (more...)

Good Blogs to follow

Good blogs keep popping up and other blogs fade into the back ground, so it’s hard to keep track of the good stuff out there. The following is a list of blogs I have either in the past gotten a lot out of or currently do. It would be great to get comments on what the best current blogs are and then iterate on this list and keep it updated.

Oracle Blogs

Virtual Circuit Wait

On Monday we had some performance problems on a system that includes a database which uses shared servers.  The top wait was “virtual circuit wait”.  Here are the top 5 events for a 52 minute time frame:

Top 5 Timed Foreground Events

Event Waits Time(s) Avg wait (ms) % DB time Wait Class
virtual circuit wait 1,388,199 17,917 13 50.98 Network
db file sequential read 1,186,933 9,252 8 26.33 User I/O
(more...)

CPU-starved LGWR

In my recent post I showed how log file sync (LFS) and log file parallel write (LFPW) look for normal systems. I think it would also be interesting to compare that to the situation when LGWR does not have enough CPU.

I happen to have collected LGWR and database-level trace files for a 11.2.0.3 database on a Solaris 10 server which was under serious pressure (50 threads mostly inserting and committing data, only 32 (more...)