Most of the times you want/need to squeeze the most out of your Database. One simple way of doing this is by using Native compilation (Available from version 9). To illustrate this I will create a … [Read more...] about Increase Database performance using Native PL/SQL compilation
In the absence of time to write new interesting articles, I update the Script in with a small simple and very useful script. what it does is: getting the totlat DB size, including datafiles, temp … [Read more...] about Total Database Size
This article will show you how you can Use RMAN to create a new database using the DUPLICATE.....FROM ACTIVE DATABASE command. The steps are as follow: Create the initialization Parameter file … [Read more...] about Duplicate Active database using RMAN
This article will show you how you can clone the database files from one host to another with out using RMAN, instead only coping the required files to the new host. This is a very easy way of moving … [Read more...] about Clone the Oracle Database to new host, without RMAN
This short article will show you how you can clone the database binaries from one host to another using the "well hidden" clone.pl script that has been bundled since 9i The steps are very … [Read more...] about Clone Oracle database binaries, the fastest way!
This short article will show you how you can drop an oracle database from SQL*PLUS using the command DROP DATABASE The steps are easy Start the database on mount exclusive restrict mode Drop … [Read more...] about Drop Database from SQL*PLUS
It is easy to think you Enterprise Edition of the Oracle database gives you access to all the nice features available. This however can not be more from the truth! This article will show you some … [Read more...] about Are your Oracle licenses all OK?
This Article will guide you, Step by step guide on how to create a physical standby database using RMAN without using duplicate command. The theory behind the task is (as always) simple, below are … [Read more...] about Create a physical standby database using RMAN.
The Error This error occurs when you're attempting to drop a global temporary table. See full error as: ORA-14452, "attempt to create, alter or drop an index on temporary table already in … [Read more...] about ORA-14452: attempt to create, alter or drop an index on temporary table already in use
In this short article I will explain how to move controlfile. The theory is quite simple and the working order is the same as making an offline redolog move from another of my … [Read more...] about Rename and move Oracle Controlfiles