Truncate Table in Oracle is a useful command. It is used to delete all the rows in the table plus release the space allocated to the table. Here are some important points regarding the Truncate table We can use truncate table command to delete all the rows in the table and it releases all the […]
How to Truncate TABLE in Oracle Read More »
What is Sql profile in Oracle A SQL profile is a set of auxiliary information specific to a SQL statement. The Oracle optimizer under normal mode makes estimates about cardinality, selectivity, and cost that can sometimes be off by a significant amount resulting in poor execution plans. SQL Profile addresses this problem by collecting additional
how to check sql profile in oracle Read More »
Steps on How to add the managed server in R12.2 (1) The addition of managed servers needs to be done on the run file system when there is no active ADOP cycle. During the next adop prepare phase, the Configuration Change Detector identifies that the addition has been made and the managed servers are automatically
How to add managed server in R12.2 Read More »
There may be scenario when cutover phase failed . It is possible to go back to previous state of cutover(rollback the patch) ,if flashback database is either enabled in the database or we have taken full backup prior to cutover I would be explaining it with respect to Database Flashback to rollback the patch I am
How to rollback the patch after failed cutover phase in R12.2 Read More »
Here in this post, we will be checking out Upgrading Database to 19c with R12.1 Important points about 19c Upgrade When upgrading your Oracle E-Business Suite to Oracle Database 19c, your database will be converted to a multitenant architecture, which will consist of a Container Database (CDB) with a single Pluggable Database. Only multitenant architecture
How to upgrade EBS database to 19c: Step by Step Read More »
We apply lot of patches to Oracle product to add new feature, to rectify bugs. Sometime the patch do not work as expected and we need to rollback the oracle patch. I am presenting here the rollback cases for different type of Oracle patches Rollback of Database patches Database patches are applied using opatch. Each
How to rollback the Oracle patch Read More »
