Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.datafiles,”Data files are the largest[…]
Read moreCategory: Database
Mirroring,”Mirroring is maintaining multiple redundant copies of data on multiple disks so that if one disk fails
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Mirroring,”Mirroring is maintaining multiple redundant[…]
Read moreShared pool,”caches various types of program data required by the server. A partial list includes storing parsed sql, pl/sql code, system parameters
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Shared pool,”caches various types of[…]
Read moreCJQ0 or Job Queue Process coordinatorback
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.CJQ0 or Job Queue Process[…]
Read moreSnnn or Shared Server Processback,”Handles client requests in the shared server architecture.In the shared server architecture, clients connect to a dispatcher process, which creates a virtual circuit for each connection. When the client sends data to the server, the dispatcher receives the data into the virtual circuit and places the active circuit on the common queue to be picked up by an idle shared server. The shared server then reads the data from the virtual circuit and performs the database work necessary to complete the request. When the shared server must send data to the client, the server writes the data back into the virtual circuit and the dispatcher sends the data to the client. After the shared server completes the client request, the server releases the virtual circuit back to the dispatcher and is free to handle other clients.Several initialization parameters relate to shared servers. The principal parameters are: DISPATCHERS, SHARED_SERVERS, MAX_SHARED_SERVERS, LOCAL_LISTENER
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Snnn or Shared Server Processback,”Handles[…]
Read moreQMNC or streams AQ Monitor coordinatorback,”QMNC is responsible for facilitating various background activities required by AQ and Oracle Streams: time management of messages, management of nonpersistent queues, cleanup of resources
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.QMNC or streams AQ Monitor[…]
Read moreDnnn or Dispatcher Processback,”Performs network communication in the shared server architecture.In the shared server architecture, clients connect to a dispatcher process, which creates a virtual circuit for each connection. When the client sends data to the server, the dispatcher receives the data into the virtual circuit and places the active circuit on the common queue to be picked up by an idle shared server. The shared server then reads the data from the virtual circuit and performs the database work necessary to complete the request. When the shared server must send data to the client, the server writes the data back into the virtual circuit and the dispatcher sends the data to the client. After the shared server completes the client request, the server releases the virtual circuit back to the dispatcher and is free to handle other clients.Several initialization parameters relate to shared servers. The principal parameters are: DISPATCHERS, SHARED_SERVERS, MAX_SHARED_SERVERS, LOCAL_LISTENER
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Dnnn or Dispatcher Processback,”Performs network[…]
Read moreRECO or Recoverer recovers distributed transactionsback,”RECO uses the information in the pending transaction table to finalize the status of in-doubt transactions. At timed intervals
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.RECO or Recoverer recovers distributed[…]
Read moreFDBA or Flash Data Archiver Processesback,”When a transaction that modifies a tracked table commits, FBDA stores the pre-image of the rows in the archive. FDBA maintains metadata on the current rows and tracks how much data has been archived.FBDA is also responsible for automatically managing the flashback data archive for space, organization (partitioning tablespaces)
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.FDBA or Flash Data Archiver[…]
Read moreDBRM or Database Resource Managerback,”Sets resource plans and performs other tasks related to the Database Resource Manager.If a resource plan is not enabled
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.DBRM or Database Resource Managerback,”Sets[…]
Read more