Oracle is most widely used Oracle database in the world. It has the capacity to handle large database and high transaction
Here I am presenting the Oracle tutorials on Various Oracle products
These articles will be really help in understanding the oracle products and getting started on Oracle system
Cutover phase of adop is downtime phase of Online patching cycle. We should ensure no user access is there in that period as application processes are restarted.Before running the cutover command, ensure you are ready to commit to application of the selected patches. Once cutover is complete, it is not possible to revert to …
what happens in cutover phase of adop in R12.2 Read More »
Oracle Developer Day pre-installed virtual machine is very useful for performing lab testing on the Oracle database. It is beneficial for practising the Oracle database on a Linux machine on your laptop. You can also export your application database and import it into this pre-installed Oracle VM, It is very quick and easy to set …
Pre-built Oracle database for learning and testing using Oracle Developer VM Read More »
In R12.1, we have just two applications homes (10.1.2) and (10.1.3) and database homes registered in central inventory. Due to dual filesystem and weblogic inclusion, this has undergone drastic changes, We have now 4 Oracle homes per filesystem registered in central inventory and one database home. This article presents How to re-attach 12.2 E-Business Oracle Homes …
How to re-attach 12.2 E-Business Oracle Homes to the central inventory Read More »
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 …
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 talk about one of the useful things that administrator often has to use. The topic is How To Get environment variables of running process Linux. Let’s first start with what is environment variable and then find out How To Check Environment Variables for a Running Process in different flavours of Unix system …
How to Get environment variables of running process in Linux Read More »
