The primary functional difference between logical and physical standby database setups is that logical standby permits you to add additional objects (tables, indexes, etc) to the database, while physical
Latest Answer : A physical or logical standby database is a database replica created from a backup of a primary database. A physical standby database is physically identical to the primary database on a block-for-block basis. It's maintained in managed ...
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 ...
Latest Answer : SQLNET.ora tells you what path to take in resolving the name of an instance (among other things). In the context of this question, the NAMES.DIRECTORY_PATH parameter specifys the order of the naming methods used for client name resolution lookups. (TNSNAMES, ...
What is the difference between .ora and net file or .ora and .net or tnsnames.ora sqlnet.ora listener.ora what ever the differnence makes between ora and net.
Latest Answer : Pfile1. text file2. changes take effect on the next startup3. initSID.oraSPfile1. binary file2. changes perisitent across startup and shutdown3. spfileSID.ora Only way to start db with spfile in non default location SPFILE = must beplaced in pfile ...
Latest Answer : snapshots can't upated. While MV can be updated contantley. ...
Latest Answer : Often the word "lock" is synonymous to enqueue. In this document, "enqueue" will be used for the locking mechanism that you can find in V$LOCK. "locking" will be used when talking about requesting an enqueue, waiting on an ...
Latest Answer : The basic diff between a locally managed tablespace and a dictionary managed tablespace is that in the dictionary managed tablespace every time a extent is allocated or deallocated data dictionary is updated which increases the load on data dictionary, ...
Latest Answer : Consider 8K block size. The total bytes 8 x 1024 = 8196 bytesEach block requires approximately 117 bytes for the header. Please note that the header size varies depending upon the block size. The total available bytes for data = ( 8196 – 117) = ...
Latest Answer : HiBase tables are made when the database is created and these tables are stored in data dictionary. these base tables contains the information related to the database. these tables are own by sys.the information in these tables is crypted and cannot ...
