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 »
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 …
Oracle Flashback query Read More »
