 Related Questions 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 ... Tags : Parallel Server 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. ... Latest Answer : Server process writes the data block it read from the database to the buffer. DBWR process writes data from buffer to database. ... Latest Answer : During database mount process, Oracle would check for the existence of controlfiles mentioned in init.ora file but it wont check the contents of the controlfile which is done during the opening of database. ... Latest Answer : DBWR only writes to the data files. So the answer is Server Process. ... Latches are low level serialization mechanisms used to protect shared data structures in the SGA. The implementation of latches is operating system dependent, particularly in regard to whether a process Latest Answer : Latches are simple, low-level serialization mechanisms to protect shared data structures in the system global area (SGA). For example, latches protect the list of users currently accessing the database and protect the data structures describing the blocks ...
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
