A database instance (Server) is a set of memory structure and background processes that access a set of database files. The process can be shared by all users. The
Latest Answer : Database instance(server) is the combination of memory structure and background process. It's a way to connect to the oracle database. ...
Multiple instances accessing the same database (Only In Multi-CPU environments)
Latest Answer : Very true---Multiple instances uses by single database files is called parallel server. in this condition database files act as a server and connected with differenet instances.But each instances can use database files in same time.So the database file ...
An index is a database structure used by the server to have direct access of a row in a table. An index is automatically created when a unique of primary key constraint clause
Latest Answer : Indexes are used both to improve performence and to ensure uniquness of a column. Oracle automatically creates an index when a UNIQUE or PRIMARY key constarints clause is specified in a create table command.We can manually create our own indexes via the ...
It consists ofone or more data files.one or more control files.two or more redo log files.The Database containsmultiple users/schemasone or more rollback segmentsone or more tablespacesData dictionary
Two processes wating to update the rows of a table which are locked by the other process then deadlock arises. In a database environment this will often happen
Latest Answer : Oracle automatically detect deadlock , but not occar ...
Answer for this questions is NO. Standby database must be on same version of database and same version of Operating system.
Latest Answer : Yes you can configure your stand by server with Advance Replication provided by Oracle 8i onwards on different OS. But the Oracle version should be same. My Current senario Primary DB is on Unix and Secondary DBs are on Windows. ...
Enqueues are another type of locking mechanism used in Oracle. An enqueue is a more sophisticated mechanism which permits several concurrent processes to have varying degree of sharing of "known"
Latest Answer : An enqueue is a sophisticated locking mechanism that permits several concurrent processes to share known resources to varying degrees. Any object that can be used concurrently can be protected with enqueues. For example, Oracle allows varying levels of ...
Thhere are 3 different ways :-1) SELECT name, value FROM v$parameter WHERE name = 'spfile'; //This query will return NULL if you are using PFILE2) SHOW PARAMETER spfile // This query will returns
Latest Answer : Go to OEM => Databases => ... => Instance => Configuration, in "Database and Instance Information" section, the last row shows spfile ...
Latest Answer : 1. set SHARED_SERVERS=(more than 1) in init.ora2. make changes in tnsnames.ora file to get the connection with DISPATHERS rather than dedicated servers ...
I am getting error "No Communication channel" after changing the domain name? what is the solution?
