view counter

Database Feed

Oracle Database, Oracle 10g, Oracle 11g, Oracle XE, Oracle RAC, Oracle Instant Client, Oracle Data Guard and Oracle Exadata resources, news, and support articles.

Restrictions on the append hint

I wanted to add an append hint to some code but realised that there are known restrictions when either triggers or referential integrity are involved.

That does make sense as potentially rows would be inserted that either did not fire a trigger or broke RI constraints.

I decided to produce a test case to prove that the restrictions did work and were still in place.

Test append with trigger created

DOAG 2015 - "Oracle 12c Parallel Execution New Features" presentation material

Thanks to the many attendees that came to my presentation "Oracle 12c Parallel Execution New Features" at the DOAG conference 2015.

Trace Files -- 8b : More Performance Evaluation from Trace File

Continuing with the same table as in the previous example, but with the addition of
(a) Statistics on the table
(b) An Index on the CREATED column
SQL> select count(*) from all_objects_many_list;


SQL> select min(created) from all_objects_many_list;



Countdown to Sydney

I’m speaking at the Sydney leg on the OTN APAC tour on November 30th, 394 Lane Cove Rd, North Ryde
This is a great event with local and international speakers all giving their time and knowledge for free to help you with your Oracle technology.
If you’re in Sydney, then come along for some great education.  Even if you cannot attend the conference, if you are in the area, come along and say Hi.  Part of my job focus is helping developers succeed with Oracle, so we might be able to organise something in the future in terms of (free) education for your development teams.

Log Buffer #450: A Carnival of the Vanities for DBAs

class="l-submain-h g-html i-cf">

This Log Buffer Editions picks few blog posts from Oracle, SQL Server and MySQL.


OPatch bugs when applying Grid Infrastructure

For one of my clients, I experienced several issues with applying PSU with opatch

There were some code changes in opatchauto, which are not yet production-ready. I am looking forward to seeing a new opatch release (maybe or 11) which has these issues fixed.

ORA-27101 Shared Memory Realm does not exist

What is the cause of the "ORA-27101 Shared Memory Realm does not exist"?

How do I resolve this?

CLOBS, from 11g to 12c

If you are a regular user of LOB’s in the database, take care when you switch from 11g to 12c.  Notice the subtle difference:

A Problem with REVOKE

If you grant the DBA role to a user, Oracle also grants it the UNLIMITED TABLESPACE system privilege. If you then revoke the DBA role from this user, Oracle also revokes its UNLIMITED TABLESPACE system privilege.

view counter