Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.what are Online redo log[…]
Read moreLatest Posts
what are data files,”Contain the user or application data of the database
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review. what are data files,”Contain[…]
Read morewhat are control files,”Each database has one unique control file that contains data about the database itself (that is, physical database structure information). Multiple copies may be maintained to protect against total loss. It can also contain metadata related to backups. The control file is critical to the database. Without the control file
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.what are control files,”Each database[…]
Read moreWhat are the additional files used during the operation of the database,”parameter file, password file, backup files, archived redo log files, trace files
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.What are the additional files[…]
Read moreWhat are the three files that comprise an Oracle database?,”control files, data files
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.What are the three files[…]
Read moreDescribe ARCn,”Archiver Processes• Copy redo log files to a designated storage device after alog switch has occurred• Can collect transaction redo data and transmit that data tostandby destinationsIf you anticipate a heavy workload for archiving (such as during bulk loading of data)
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Describe ARCn,”Archiver Processes• Copy redo[…]
Read moreDescribe the LREG,”Listener Registration ProcessRegisters information about the database instance and dispatcher processes with the Oracle Net ListenerLREG provides the listener with the following information:• Names of the database services• Name of the database instance associated with the services and its current andmaximum load• Service handlers (dispatchers and dedicated servers) available for the instance, including their type, protocol addresses
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Describe the LREG,”Listener Registration ProcessRegisters[…]
Read moreDescribe the RECO,”Recoverer Process• Used with the distributed database configuration• Automatically connects to other databases involved in in-doubt distributed transactions• Automatically resolves all in-doubt transactions• Removes any rows that correspond to in-doubt transactionsIf the RECO process fails to connect with a remote server, RECO automatically tries to connect again after a timed interval. However
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Describe the RECO,”Recoverer Process• Used[…]
Read moreDescribe the PMON,”Process Monitor ProcessPerforms process recovery when a user process fails- Cleans up the database buffer cache- Frees resources that are used by the user process• Monitors sessions for idle session timeoutcleaning up the database buffer cache and freeing resources that the user process was using. For example, it resets the status of the active transaction table, releases locks, and removes the process ID from the list of active processes.PMON periodically checks the status of dispatcher and server processes, and restarts any that have stopped running (but not any that Oracle Database has terminated intentionally).Like SMON
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Describe the PMON,”Process Monitor ProcessPerforms[…]
Read moreDescribe the SMON
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Describe the SMON System Monitor[…]
Read more