New Optimizer Feature with 11g (1) Invisible indexes With an 11g release, the index can be made invisible. They will be maintained all the time and can be made visible at any time alter index K invisible; Optimizer will not use the index if it is invisible alter index K visible; If want one query …
New Optimizer Feature with 11g,12c and 19c Read More »
What is duplicate using the Active database : Active database duplication copies the target database over the network to the destination and then creates the duplicate database. Only difference is you don’t need to have the pre-existing RMAN backups and copies. The duplication work is performed by an auxiliary channel. This channel corresponds to a …
RMAN DUPLICATE DATABASE CLONING WITH ACTIVE DATABASE Read More »
In this post, we will discuss the Flashback technology in Oracle, its architecture, Oracle Flashback query, the syntax to use Oracle Flashback query What is Flashback technology in Oracle? Oracle has introduced Flashback Technology that lets you view past states of database objects or return database objects to a previous state without using point-in-time media …
To Troubleshoot Workflow Notification Mailer issues, we need to understand how outbound and inbound processing works Outbound Notification Processing – -Creation of Workflow notification raises oracle.apps.wf.notification.send event.-This event is deferred immediately and placed on the WF_DEFERRED agent.-Workflow Agent Listener on the WF_DEFERRED queue processes the deferred subscription.-Subscription to this event calls the Generate function (WF_XML.Generate) …
Troubleshooting Workflow Notification Mailer issues Read More »
R12.1/R12.2 is a pretty big and time-consuming upgrade. We need to find all the long-running sql to resolve the R12.2 upgrade performance issues. Since each iteration takes a lot of time, it is important, that we try to find out the performance issues in fewer iterations and fix them accordingly Here are Top AWR useful queries to …
What is Virtual Index in Oracle ? A virtual index is a “fake” index whose definition exists in the data dictionary, but has no associated index segment. Many time sql tuning advisor recommends you creating new index and you want to test the new index. In this case It can take good amount of time …
How to use Virtual Index in Oracle Database Read More »
