Search

Top 60 Oracle Blogs

Recent comments

March 2016

BI Publisher Integration in EM12c

As some of you would already know, for my sins I am the product manager with responsibility for BI Publisher in Enterprise Manager [I must have a lot of sins because I’m also responsible for Change Management, Compliance Management, Configuration Management (these three form the Database Lifecycle Management pack), jobs, the target discovery framework, and at least part of DBaaS along with data cloning and refresh </p />
</p></div>

    	  	<div class=

GoldenGate Plug-in for Enterprise Manager 13.1 is released

Just a quick post to let you know the EM13.1 plug-in for GoldenGate has been released by the GoldenGate development team. I know some of you have been waiting for this, so head on over to the official announcement for all the details!

The post GoldenGate Plug-in for Enterprise Manager 13.1 is released appeared first on PeteWhoDidNotTweet.com.

Wrong Results ?

I gather that journalistic style dictates that if the headline is a question then the answer is no. So, following on from a discussion of possible side effects of partition exchange, let’s look at an example which doesn’t involve partitions.  I’ve got a schema that holds nothing by two small, simple heap tables, parent and child, (with declared primary keys and the obvious referential integrity constraint) and I run a couple of very similar queries that produce remarkably different results:

Tightening up your data model

Having NOT NULL constraints declared on columns that are genuinely not nullable not only is good practice, but can yield performance gains. Here’s a little routine that lists those columns that probably need a NOT NULL constraint. It looks at all columns and

  • check to see if a constraint with definition “COLUMN_NAME” IS NOT NULL is present
  • counts the null values

If the latter is zero, and no constraint was found, then we print out ‘alter table … ‘ DDL for those columns that may need such a constraint defined.

Extensive Elapsed Time for ASH Report

The other day I had a customer who was to send me an ASH report after there was a challenge in providing me EM Diagnostics from their repository database.  After the report hadn’t been submitted after a number of days, the customer admitted that they would execute an ASH report request and would subsequently kill the session after eight hours or so of non-completion.

Overcoming Your Oracle Data Insecurity Webinar

delphix1

Overcoming Your Oracle Data Insecurity

Webinar – Wednesday, March 30 – 10am PT

In 2016, the risks and reasons why companies should secure their sensitive data are well known (Sony, Target, and Anthem just to name a few examples). Yet, most companies have pitiful or limited data security in their Oracle databases.

Oracle Cloud – Oracle Management Cloud

Oracle Management Cloud is a new Oracle Cloud offering launched during Oracle Open World 2015,…

BOF: A Sample Application For Testing Oracle Security

In my Oracle security training classes I use a couple of sample applications for various demonstrations. I teach people how to perform security audits of Oracle databases, secure coding in PL/SQL, designing audit trail solutions and locking down Oracle. We....[Read More]

Posted by Pete On 10/03/16 At 11:07 AM

Oracle Cloud – Moving a dumpfile into the Database as a Service Cloud

Now that I got myself a bit acquainted with the Database as a Service offering,…

UKOUG Application Server & Middleware SIG

ukougI’ll be speaking at the UKOUG Application Server & Middleware SIG tomorrow.

It’s going to be another hit-and-run affair for me. I’m in meetings at work all morning, then I’ll be doing a mad dash to get to my presentation at the SIG, then straight back to work to do an upgrade during the evening.

The agenda looks cool, so I would have liked to stay the whole day, but sadly that’s not going to happen. :(