Reverse engineering exercise #21 (for x64, ARM, ARM64, MIPS); solution for exercise #20
(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)
"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.
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.
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 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.
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 […]
How do you delete all data? The simplistic approach would be to truncate all tables
SQL> select table_name from user_tables; TABLE_NAME ---------- T1 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
A colleague of mine asked about the several ways of saving XML content, I knew,…
Prior to 220.127.116.11 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 18.104.22.168, this can be done with PDB save state feature
SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ----------------- ---------- ---------- 2 PDB$SEED READ ONLY NO 3 ALPDB READ WRITE NO
Lets create a new PDB
Yep, its free, its cool and a lot of fun. During Oracle OpenWorld 2015, the…