This article will not help
you to gain advanced knowledge in PS Query but I’m sure it helps you to know
something new. Dirty
Reads mode also called Read only mode. Enables you to configure your
servers to avoid table locking
while running your PeopleSoft queries. When Dirty Read mode is enabled for
PeopleSoft Query, the Performance is increased as queries do not lock on other
INSERT and UPDATE operations. Which will simply read the data’s in data blocks
(i.e.) reading the uncommitted data’s also which can be rolled back. Dirty Read
mode is set in configuration files for PeopleSoft Application server and
PeopleSoft Process scheduler server.
To enable
this set Use dirty-read=1 in application server configuration file and process
scheduler file.