Tag: Oracle

12c: Fun with WITH!

Last night I couldn’t sleep and what else you’re going to do? I was thinking about Oracle stuff. In Oracle version 12, Oracle has enhanced the WITH clause – traditionally used for sub-query factoring – to allow the declaration of functions and…

Read More >

Alter Session Kill on Steroids

Learn how you can use the IMMEDIATE option of the Oracle command ALTER SYSTEM KILL SESSION and stop using kill -9.

Read More >

In-Memory Column Store: 10046 May Be Lying to You!

The Oracle In-Memory Column Store (IMC) is a new database option available to Oracle Database Enterprise Edition (EE) customers. It introduces a new memory area housed in your SGA, which makes use of the new compression functionality brought by the…

Read More >

Create Windows Service for Oracle RAC

It’s my first time on RAC system for Windows and I’m happy to learn something new to share. I created a new service for database (restoredb) only to find out the ORACLE_HOME for the service is “c:\\oracle\\product\\10.2.0\\asm_1” Any ideas as…

Read More >

Exploring Options of Using RMAN Configure to Simplify Backup

I am a simple person who likes simple things, especially RMAN backup implementation. I have yet to understand why RMAN backup implementation does not use configure command, and if you have a good explanation, please share. Examples for RMAN configure…

Read More >

How To Correlate Oracle Database Transaction with GoldenGate

So there I was troubleshooting GoldenGate issue and was puzzled as to why GoldenGate transactions were not seen from Oracle database. I had the transaction XID correct; however, I was filtering by ACTIVE transaction from Oracle which was causing the…

Read More >

Changing Failgroup of ASM Disks in Exadata

There was a discrepancy in the failgroups of couple of ASM disks in Exadata. In Exadata, the cell name corresponds to the failgroup name. But there were couple of disks with different failgroup names. Using the following plan to rectify…

Read More >

Pro-active AWR Data Mining to Find Change in SQL Execution Plan

Many times we have been called for the poor performance of a database and it has been narrowed down to a  SQL statement. Subsequent analysis have shown that the execution plan has been changed and a wrong execution plan was being…

Read More >

What’s New with Apps Password Change in R12.2 E-Business Suite ?

Apps password change routine in Release 12.2 E-Business Suite changed a little bit. We have now extra options to change password, as well as some manual steps after changing the password using FNDCPASS. There is a new utility introduced called…

Read More >

Differences Between R12.1 and R12.2 Integration with OAM

With the revamp of technology stack in R12.2 of Oracle E-Business Suite (EBS) , the way we integrate Oracle Access Manager (OAM) has changed. R12.2 now is built on Weblogic techstack, which drastically changed how it integrates with Other Fusion…

Read More >
Page 12 of 143« First Page...1011121314...20...Last Page »