deepdive

141 Flips | 4 Magazines | 140 Followers | @deepdive | Keep up with deepdive on Flipboard, a place to see the stories, photos, and updates that matter to you. Flipboard creates a personalized magazine full of everything, from world news to life’s great moments. Download Flipboard for free and search for “deepdive”

Linux 4.15 I/O Scheduler Tests: BFQ, CFQ, Kyber

With some BFQ performance fixes included as part of Linux 4.15 along with other I/O scheduler work and block improvements for this latest Linux …

Oracle 12c STIG Password Generator in PL/SQL

Creating or modifying an Oracle Database user password can be done by using any standard password generator you can find on the WEB. But I wanted a …

Viewing Automatic SQL Tuning Advisor Tasks in Oracle SQL Developer

I got a question from our internal mailing list…I would like to know how I can view historical SQL tuning recommendations in SQL Developer 4. I don’t …

Cache size for a heavily used sequence

Maybe his requirement is to guarantee ordered generation. Sorry for not being clear enough.<p>That would be a performance killer in Oracle RAC. To …

Oracle Database 12c: RMAN recover at table level | DBA survival BLOG

Oracle Database 12c comes with a new feature named “RMAN table level recovery”.<p>After a quick try it’s easy to understand that we are talking about …

Playing with Oracle 12c Multitenant Users and Roles | DBA survival BLOG

I’ve realized these days that the great list of articles by Oracle Alchemist does not contain any articles describing a little more in depth common …

Removing passwords from Oracle scripts: Wallets and Proxy Users | DBA survival BLOG

Very often I encounter customers that include Oracle account passwords in their scripts in order to connect to the database.<br>For DBAs, sometimes …

Databases

Some notes about Grid Infrastructure PSU 12.1.0.1.2 | DBA survival BLOG

I’m creating a new 12c RAC environment from scratch, Ii just want to track a few notes (primarily for my personal use ;-)) about the _PSU.<p>The opatch …

Oracle Multitenant and custom DBCA templates | DBA survival BLOG

Today I’ve encountered an annoying issue while adapting a few scripts for automatic database creation. I track it here so hopefully it may save a few …

Oracle Database 12c in-memory option, a quick overview | DBA survival BLOG

Oracle Database 12.1.0.2 is finally out, and as we all knew in advance, it contains the new in-memory option.<p>I think that, despite its cost ($23k per …

Oracle Active Data Guard 12c: Far Sync Instance, Real-Time Cascade Standby, and Other Goodies | DBA survival BLOG

Here you can find the content related to my second presentation at <b>Oracle Open World 2014</b>.<p><b>Slides</b><p><b>Demo video1: Real-Time Cascade</b><p><b>Demo video2: Far Sync</b> …

Tales from Demo Grounds part 1: Clone PDBs while open READ-WRITE | DBA survival BLOG

DISCLAIMER: I’ve got this information by chatting with Oracle developers at the Demo Grounds. The functionality is not documented yet and Oracle may …

Tales from the Demo Grounds part 2: cloning a PDB with ASM and Data Guard (no ADG) | DBA survival BLOG

In my #OOW14 presentation about MAA and Multitenant, more precisely at slide #59, “PDB Creation from other PDB without ADG*”, I list a few commands …

Cloning a PDB with ASM and Data Guard (no ADG) without network transfer

Ok, if you’re reading this post, you may want to read also the previous one that explains something more about the problem.Briefly said, if you have …

Moving Clusterware Interconnect from single NIC/Bond to HAIP

Very recently I had to configure a customer’s RAC private interconnect from bonding to HAIP to get benefit of both NICs.So I would like to recap here …

SQL Plan Directives: they’re always good… except when they’re bad!

The new Oracle 12c optimizer adaptive features are just great and work well out of the box in most cases.Recently, however, I’ve experienced my very …

How to avoid ORA-02153 when creating database links on 11.2.0.4 (the unsupported way)

<i>Disclaimer (wow, most of my recent posts start with a disclaimer, I guess it’s bad): this post explains an UNSUPPORTED workaround for an error</i> …

Grid Infrastructure 12c: Recovering the GRID Disk Group and recreating the GIMR

Losing the Disk Group that contains OCR and voting files has always been a challenge. It requires you to take regular backups of <b>OCR</b>, <b>spfile</b> and …

Querying the dba_hist_sys_time_model to get historical data

This quick post is mainly for myself… I will certainly use it for reference in the future.Debugging problems due to <b>adaptive dynamic sampling</b> and in …

Get information about Cursor Sharing for a SQL_ID

Yesterday I’ve got a weird problem with Adaptive Cursor Sharing. I’m not sure yet about the issue, but it seems to be related to cursor sharing …

System Statistics About DOP Downgrades

By: | Senior Principal Product Manager<p>I want to take a detour from the Auto DOP series to talk about system statistics related to DOP downgrades. In …

Is Parallelism married to Partitioning?

By:<p>In the last couple of months I have been asked a number of times about the dependency of parallelism on partitioning. There seems to be some …

Auto DOP and Queuing Parameter Settings

By: | Master Product Manager<p>In anticipation of some of the questions that will come out of this week's Rocky Mountain Oracle User Group Training …

Workload Management – Based on Execution Times

By: | Master Product Manager<p>Previously on this channel, mapping users to consumer groups is easy. Ok, so what if I do not have any users? Well you …

What is Auto DOP?

By: | Senior Principal Product Manager<p>Until 11.2 there were several ways for developers/DBAs to request parallelism for a SQL statement. 11.2 brought …

Limiting DOPs – Who rules over whom?

By: | Master Product Manager<p>I've gotten a couple of questions from Dan Morgan and figured I start to answer them in this way. While Dan is running on …

Optimizer Processing Rates for Auto DOP

By: | Senior Principal Product Manager<p>In the previous post in this series we looked at how we can configure and control Auto DOP and we have …

Auto DOP and Parallel Statement Queuing

By: | Master Product Manager<p>As a follow up on one of our older posts (here) I figured I should share the presentation and content I recently …

Monitoring Parallel Execution using Real-Time SQL Monitoring in Oracle Database 12c

By: | Senior Principal Product Manager<p>The Real-Time SQL Monitoring feature (SQL Monitor) was introduced in 11g to make it easier to monitor the …