And, suppose the datafiles were only partially full when the activity level dropped-half full, for example, or 4 MB of 8 MB used-and thus were not deleted. The size in megabytes (MB) for the post queue in a qstatus display is the actual disk space that the datafiles occupy.įor example, suppose there were 100 concurrent sessions on the source system, creating 100 subqueues in the post queue on the target system. Consequently, the higher the activity level on the source system, the more datafiles on disk. If the entire 8 MB file size is not consumed, a datafile remains on the system even though the data was posted and read/released. Each subqueue can have one or more datafiles associated with it, each with a default size of 8 MB. SharePlex routinely writes replicated data from the subqueues to associated datafiles on disk as part of its checkpoint recovery system. The number of subqueues that exist at a given time on a target system reflects the peak activity on the source system since replication started. The Post process uses the subqueues to establish Oracle sessions for the target instance. The SharePlex post queue actually consists of a number of subqueues, each approximately corresponding to a user session on the source system. Use the trim command to clean up obsolete subqueue files on the source system. READER +PP+elliot+sp_opst_mt+o.ora11-o.ora11 Syntax The same naming logic applies to the other queues shown in the output (export queue expdsg+X and post queue expdsg+P). The reader is the Read process, as indicated by the sp_ord in its name string. In this example, the writer to the capture queue o.ora11+C is the Capture process, as indicated by the sp_ocap in its name string. An export queue is designated with a +X.A capture queue is designated with a +C.For example, for the capture queue, it lists the Capture process and the Read process. The qview list command lists each queue, the replication process that writes to it, and the replication process that reads it. Use the list command to list all queues for all active configurations on a system. Scans for a specified number of messages in the Capture queue. Lists all queues for all active configurations on a system.
The qview utility provides the following commands: Command Qview -p port list Overview of qview commands On Windows, run qview with the -p option to specify the port number of the SharePlex instance for which you want to view queues. Other Windows users with Administrator privileges can run qview if the SharePlex service is shut down. Other users, whether or not they have Administrator privileges (members of Administrators group), cannot run qview. On Windows, there is only one Administrator user. To run qview on the Windows platform while the SharePlex service is running, log onto the system as the Administrator user. The utility is an interactive command session.
Log on to the system as a SharePlex Administrator, and use the command line of the operating system to run qview from the bin sub-directory of the SharePlex product directory. Supported databasesĪll SharePlex-supported databases on all supported platforms Run qview If this utility is not used properly, it can damage the replication environment and require resynchronization and reactivation. Warning!Do not use qview for the first time without the assistance of Quest Technical Support. The qview tools described here do not deactivate the configuration. Through the qview utility, you can view queue names and remove old queue files.
0 kommentar(er)
