How to generate fibonacci series in Oracle. Way 1: with data as (select level levels from dual connect by level <= &how_may_rows) select f from data model...
Automatic startup and shutdown oracle on linux Oracle database server provides two scripts to configure automatic database startup and shutdown process. The...
How to take RMAN backup on a remote disk It is common to hear that for backup there is not sufficient space on my server or my server disk is about to full....
How to know whether I use analyze or DBMS_STATS Automatic statistics gathering should be sufficient for most of the cases. And automatic statistics gathering...
RMAN-00554,RMAN-04005,ORA-0103 when remote connection by rman Whenever I try to connect remotely to a database through rman it fails with message RMAN-00554,...
List of Patchset number in metalink You want to download patchset from metalink but you don't know the patchset number. In that case it may take some moments...
How to clone database on the same host with different name In this post I will show how we can clone database on windows system without using RMAN duplicate....
How to recover or recreate temporary tablespace in 10g In database you may discover that your temporary tablespace is deleted from OS or it might got...
EM Daemon is not running On windows whenever I try to start my dbconsole in one time during process it shows me message EM Daemon is not running. Details in...
Minimum privilege needed to take data pump export In your organization you may assign a user who is only responsible to take data pump export. Suppose everyday...
Drop Temporary Tablespace Hangs Problem Description The DROP temporary tablespace operations take long time and in fact it hangs. If you take a 10046 trace of...
Create Read only user for a Schema One thing you need to remember before read this post is there is no easy or shortcut way to make a read only user of another...
How to find Top Sql through Queries If someone ask for top sql they from enterprise manager he can find some expensive queries. But the result may vary based...
Why create between pfile and spfile works if shutdown database Sometimes it may arises question that while database is shutdown then you can still connect to...
How to avoid of recreating pfile or spfile if any error in spfile Let us some talk about pfile and spfile. Suppose I have done some wrong-edit inside spfile...
What will happen if oracle unable to write Alertlog, Core Dump Or Tracefiles In this I will show what can happen if Oracle is unable to write to the ...
How to restore an Spfile from autobackup older than 7 days Whenever we issue in RMAN, RMAN> restore spfile from autobackup; then restoring from autobackup...
Recover database after missing online redo logs and all controlfiles. This example is based on, You have lost all your current and backup of controlfiles. You...
ORA-12560: TNS:protocol adapter error on windows machine while starting oracle Error Description On my windows server machine whenever I try to logon to...
Running Runinstaller fails with DISPLAY not set When I running the runinstaller command on my linux server after entering through ssh it fails with DISPLAY not...
Possible Limitations When Adding Datafiles to a Tablespace Before discussing limitations of adding datafiles to a tablespace let's think about DB_FILES...
How to Find out or Check Linux Version Information Before installing oracle clusterware it is necessary in which version of linux you are trying to install to....
How to Create and Use OMF OMF indicates Oracle Managed Files. With the use of Oracle-managed files the administration of an Oracle Database can be simplified. ...
How to load data using external table into oracle database Using SQL*Loader we can load data from flat data file to oracle database which is described in How...
How to change the hostname in Linux There are several ways by which we can change the hostname in linux. The process may vary based on distribution of linux. ...
How to configure(modify,see) Kernel Parameters in Linux Kernel Parameters, Recommended Values to install Oracle and Associated Files 1)semmsl semmns semopm...
Convert CLOB to BLOB I will write a procedure clob_blob_proc which convert description column of test table of type clob to blob. Here is the procedure. ... ...
How to Schedule or Automate Backup through Crontab Schedule or Automate Backup is a needed thing almost in all environment. We can do automate or scheduling...
How to monitor alert log file in Oracle We know in a UNIX system with tail -f we can monitor alert log file to see how alert log file is populated. For example...