How to find database is using Spfile or Pfile in Oracle 10g

Sometimes DBA needs to find out database is running by spfile or pfile. Let us display this with an example. To demonstrate I start a datab...

Restoring oracle 10g Cold backup on different host with different directory structure.

This is very common to restore our database from one system to another system with the same database name but having different directory st...

Cloning a database in Oracle 10g Using RMAN in Windows OS on same system

I found so many links and tutorials to clone a database in Linux but not so much for cloning in windows. So here we will learn how to clone ...

Put IP address Restriction in Oracle 10g

Sometimes we have a fear in mind if a person has user name, password, ip address and sid of database then he/she can easily connect to our d...

Databases hang issue

I very common problem for most DBA’s face is user complain about their application is hang. There can be so many reasons for it. One of the ...

Tracing a User Session

Sometimes we want to know what a user is doing i.e. what query is executed for performance related issues or security check. The easiest wa...