Tag: Oracle

Pythian at Collaborate 15

Make sure you check out Pythian’s speakers at Collaborate 15. Stop by booth #1118 for a chance meet some of Pythian’s top Oracle experts, talk shop, and ask questions. This many Oracle experts in one place only happens once a…

Read More >

Recovering an Oracle Database with Missing Redo

Background I ran into a situation where we needed to recover from an old online backup which (due to some issues with the RMAN “KEEP” command) was missing the archived redo log backups/files needed to make the backup consistent.  The…

Read More >

Exadata X5 – A Practical Point of View of the New Hardware and Licensing

Oracle recently announced its latest iteration of Exadata – X5-2. It includes a refresh of the hardware to the most recent Xeon® E5-2699 v3 CPUs. These new CPUs boost the total cores count in a full rack to 288. This…

Read More >

Oracle Database 12c Patching: DBMS_QOPATCH, OPATCH_XML_INV, and datapatch

Background Oracle Database 12c brings us many new features including: the long needed ability to run OPatch and query the patch software installed in the Oracle Home programatically through SQL using the new DBMS_QOPATCH package. If you’re a DBA working…

Read More >

Performance Problems with Dynamic Statistics in Oracle 12c

I’ve been making some tests recently with the new Oracle 12.1.0.2 In-Memory option and have been faced with an unexpected  performance problem.  Here is a test case: Waiting for in-memory segment population: Now let’s make a simple two table join:…

Read More >

Watch: Riak vs. Oracle

Every data platform has its value, and deciding which one will work best for your big data objectives can be tricky—Alex Gorbachev, Oracle ACE Director, Cloudera Champion of Big Data, and Chief Technology Officer at Pythian, has recorded a series…

Read More >

How to Migrate a Database Using GoldenGate

There are many ways to migrate a database from A server to B server like Datapump, RMAN,etc. Using the combination of datapump and GoldenGate to migrate your database on cross-platform will minimize your down-time to even three minutes. This method…

Read More >

Merging Apps Patches in Oracle EBS R12.2

It’s public knowledge that the traditional patching tool in Oracle EBS “adpatch” is replaced with “adop” utility. It’s also known that adop utility automatically merges patches when more than one patch is specified in the command line arguments. So whats…

Read More >

OLTP type 64 compression and ‘enq: TX – allocate ITL entry’ on Exadata

Recently we’ve seen a strange problem with the deadlocks at the client database on Exadata, Oracle version 11.2.0.4 . Wait events analysis showed that sessions were waiting for “enq: TX – allocate ITL entry” event. It was strange because there…

Read More >

Performance Issues with the Sequence NEXTVAL Call

Is SELECTing from a sequence your Oracle Performance Problem? The answer to that question is: it might be! You wouldn’t expect a sequence select to be a significant problem but recently we saw that it was—and in two different ways….

Read More >
Page 11 of 144« First Page...910111213...20...Last Page »