Monthly Archives: November 2013

Changing DBID

What is the DBID?
Is a unique identification number when the database is created.
DBID means database identifier in Oracle.The database identifier is a unique identifier. This is found in all datafile headers. The database identifier is used to identify the database a file belongs to. The database identifier is also found in the control files. It can therefore be gotten without access to the datafiles.The database identifier is important when the spfiles or controlfiles must be recovered. 

Continue reading

Fight againts Oracle Idle Sessions I

idle

An idle session can be setup to become sniped after x minutes by setting the initialization parameter: resource_limit = true in the init.ora and idle_time in the user profile. Continue reading