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.

Reverse engineering exercise #21 (for x64, ARM, ARM64, MIPS); solution for exercise #20

Reverse engineering exercise #21 (for x64, ARM, ARM64, MIPS); solution for exercise #20

How the log writer and foreground processes work together on commit.

(warning: this is a rather detailed technical post on the internal working of the Oracle database’s commit interactions between the committing foreground processes and the log writer)

You’re Not Allowed

"Have you ever heard a blindfolded octopus unwrap a cellophane-covered bathtub?"
Norton Juster, The Phantom Tollbooth

Recently a thread in an Oracle forum I frequent asked the following question:
“… is there a way to restrict the login to database only from the application which we have made.”
That, of course, is not an easy question to answer as several possibilities emerge with none of them foolproof. Let’s look at those options.

Master Notes

MoS has a number of “Master Note” documents which pop up from time to time while I’m checking for known problems or solutions; they get extended from time to time (and, conversely, link to some articles which are clearly no longer relevant to current versions). This is just a tidied up list of a few of the master notes that I’ve jotted down over time. The Data Dictionary overview appeared in my daily “Hot Topics” report today, and that prompted me to publish the list I’d got so far.

Delphix Express installation

A couple of blog post ago I announced that there is now a free version of Delphix.  Here is a little more information about the installation of Delphix Express.
Delphix Express
Delphix Express is a free version of Delphix limited to 25 GB of managed storage and 1 vCPU. Delphix Express is set up for small projects and not optimized for high throughput nor performance testing.

Back Down Under

I recently got back from a trip ‘down under’ again. It was my first time visiting Australia and I have to say I liked it. Weather was great, people were friendly and there was good beer and cider to be had. We hit the ground running after my long, long flight from the US. Arriving […]

delete all data

How do you delete all data? The simplistic approach would be to truncate all tables

SQL> select table_name from user_tables;
SQL> truncate table t1;
Table truncated.

You cannot truncate if you have referential integrity constraints.

SQL> truncate table t2;
ORA-02266: unique/primary keys in table 
  referenced by enabled foreign keys

Ok, let’s disable the RIC

Saving XML documents from an Oracle database

A colleague of mine asked about the several ways of saving XML content, I knew,…

PDB Saved state –

Prior to version, whenever container database was restarted,the pluggable databases within the container database remained in MOUNT state. Startup trigger were written to open the database in READ-WRITE/READ-ONLY mode.Starting from, this can be done with PDB save state feature

SQL> show pdbs

---------- ----------------- ---------- ----------

Lets create a new PDB

Come and Enjoy – OakTable World 2015

Yep, its free, its cool and a lot of fun. During Oracle OpenWorld 2015, the…

view counter