Create a 12c physical standby database on ODA X5-2
ODA X5-2 simplifies and speeds up the creation of a 12c database quite considerably with oakcli. You can take advantage of this command by also using it in the …
Author: Harry Dragstra
ETL using Oracle DBMS_HS_PASSTHROUGH and SQL Server
June 12, 2017
Oracle, Databases, DBA Oracle, ODA, Oracle 12, Performance and tuning, PL/SQL
No Comments
While I prefer a “loosely coupled architecture” for replication between Oracle and SQL Server, sometimes a direct (database) link cannot be avoided. By using DBMS_HS_PASSTHROUGH for data extraction the …
Golden Gate 12c and DIY Sequence Replication with PL/SQL
May 5, 2017
Database, Databases, DBA Oracle, Engineered Systems, ODA, Oracle, Oracle 12, PL/SQL
2 Comments
Recently, while migrating AIX 11gR2 Databases to Oracle Linux 12cR1 on an ODA X5-2, our setup of Sequence Replication by Oracle Golden Gate appeared to be faulty. The target …
Better track the Usage of Database Options and Management Packs, or it will cost you
So here it is Oracle announces a license audit, some urgency kicks in and this familiar but also really serious question comes down from management: “Are we using any …
Dump Oracle data into a delimited ascii file with PL/SQL
This is how I dump data from an Oracle Database (tested on 8i,9i,10g,11g,12c) to a delimited ascii file: Next to the query and the generated filename the Dump_Delimited function …
DIY Parallelization with Oracle DBMS_DATAPUMP
February 23, 2017
Database, Databases, DBA Oracle, Engineered Systems, ODA, Oracle, Oracle 12, PL/SQL
5 Comments
![DIY Parallelization with Oracle DBMS_DATAPUMP]({"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"http:\/\/seattletimes.nwsource.com\/ABPub\/2012\/08\/02\/2018836700.jpg","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"} "DIY Parallelization with Oracle DBMS_DATAPUMP")
Oracle dbms_datapump provides a parallel option for exports and imports, but some objects cannot be processed in this mode. In a migration project from AIX 11gR2 to ODA X5-2 …
How About Oracle Database 12c Threaded_Execution
February 5, 2017
AMIS, Database, Databases, DBA Oracle, Engineered Systems, ODA, Oracle, Oracle 12
No Comments
THREADED_EXECUTION Threaded_Execution is an Oracle Database 12c feature aiming to reduce the number of Oracle processes on LINUX. After setting parameter THREADED_EXECUTION on TRUE and a database bounce, most …
Oracle 12c STIG Password Generator in PL/SQL
January 24, 2017
AMIS, Cyber Security, Database, Databases, DBA Oracle, DevOps, Engineered Systems, ExaData, ODA, Oracle, Oracle 12, PL/SQL, SQL
1 Comment
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 password to …
How-to bulk delete ( or archive ) as fast as possible, using minimal undo, redo and temp
Deleting some rows or tens of millions of rows from an Oracle database should be treated in a completely different fashion. Though the delete itself is technically the same, …
How-to set the current database schema of an application using a global context
March 9, 2015
Database, Databases, DBA Oracle, Frontend technology, Languages, Oracle, Oracle 12, Oracle Application Development Framework, PL/SQL, SQL, Technology
No Comments
Question: We have customers who want to work with different database schemas and we want to determine dynamically – depending on a choice during or after login – which …
SQL> Select * From Alert_XML_Errors;
August 29, 2014
Database, Databases, DBA Oracle, Development Tools, Oracle, Software Development, SQL
No Comments
Once you are able to show the xml version of the alert log as data in database table Alert_XML, it would be nice to checkout the errors with accompanying …
SQL> Select * From Alert_XML;
By mapping an external table to some text file, you can view the file contents as if it were data in a database table. External tables are available since …
Fast delete of many files in LINUX and WINDOWS
One of my customers ( Oracle Database 11gR2 on LINUX ) never noticed the Oracle software LUN filling up until a “df -h” reported 97% used, wondered why, and …
Easy setup of the query_partition_clause of row_number() for dedup(lication)
Finding and getting rid of duplicate records in a table is easy…. The row_number() over ( <query_partition_clause> <order_by_clause> ) analytic function is helpful in determining not only the number …
How-to backup Oracle RAC 11gR2 Database with RMAN
RAC and single instance RMAN backup is similar, but… Backup of a 11gR2 RAC database is similar to that of a single instance 11gR2 database. There is an important …
Re-ordering without procedural code or using a sequence
Question from one of my customers: “Please help me find an update statement that’s able to re-order a primary key after a delete.. and by the way.. you are …
Compare tables with the minus operator, even if they contain clobs and/or blobs.
I wanted to compare the content of two tables with identical layout quickly with the minus set operator, but ran into a couple of errors, caused by clob and …
Rman 11gR2 changes tag labeling of the inc backup in incrementally updated backups
In (rman) incrementally updated backups, only incremental backups are done after the first full backup to the Fast Recovery Area. From 11gR2 on the incremental backup pieces will get …
How to switch datafiles to FRA and back again
If you, like me, like to use (rman) incrementally updated backups, a copy of all datafiles will be present in the Fast Recovery Area. That becomes quite handy if …
DBPITR with a rman archival backup
One of our customers had this request: Can you make a backup of my development database that I can use to restore ( the same database ) to a …
I don't like a reclaimable database disk copy
As of Oracle 10g it’s possible to recover (or wind forward) a RMAN disk copy of the database to a specific time in the past. This type of backup …
Oracle database directory listing with ls function
Say, you are in need of a directory listing from within the Oracle database similar to the one generated with Unix command ls. Your database doesn’t contain a JVM, …