Tag: Oracle

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 >

Oracle Database: Query to List All Statistics Tables

If you were a big fan of manual database upgrade steps, perhaps you would have come across this step many times in your life while reading MOS notes, upgrade guides, etc. Upgrade Statistics Tables Created by the DBMS_STATS Package If you…

Read More >

Room for Improvement – Using DBMS_REDEFINITION with Spatial Data

Using DBMS_REDEFINITION to reconfigure a table can be a simple way to modify table structure. But that is not always the case. Consider this example of what is necessary to modify a table when Spatial data is included in the table.

Read More >

Should AUD$ Table Exist on System Tablespace During DB Upgrade?

I see this following message on all My Oracle Support notes, which talks about database Oracle manual upgrade steps. 4.16 Verify the existence of the AUD$ tables Ensure that if the aud$ table exists that it is in the SYS…

Read More >

Oracle Passwords: How to Use Punctuation Symbols

You can’t make a password strong enough. But at least you can try. Having at least one upper case character, one lower case character, one number, one punctuation mark or symbol, and greater than 8 characters, you can have a…

Read More >

Concurrent Processing Issues with Distributed Transactions Glitch

This is my first post in Pythian blog, and I wanted to share interesting use-cases that we’ve dealt with recently. I believe someone may see similar cases in the future, so these are the troubleshooting steps to get to the…

Read More >

12c Multi-tenant Environment and DBRM for Container Database

In multi-tenant environment, Database Resource Manager (DBRM), at the Container Database (CDB) level enables us to manage the resources like CPU usage and number of parallel execution servers among the plugabble databases (PDBs). Then within each PDB, DBRM enables us…

Read More >
Page 6 of 141« First Page...45678...20...Last Page »