Below section I have tried to present all the important features in Oracle Database management
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 »
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 …
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 »
