Windows Technologies

Limitations in Displaying Large Results by Desktop Search Tools

Limitation in terms of resources OS design and 32 bit platform Slow performance when high paging occurs Limitation in terms of resources: When to display more than 200K results correctly, not only for searching and displaying even when user goes through the search results, small operations like user scrolling down the search results etc would require many pages move in and out of physical memory and this would cause performance related issues depending on the amount of physical memory on the machine and the page file configuration. (you may need to configure high page file on the clients just for […]

Read more
DataBase

Differences between Oracle and Sybase

Oracle 9,10g Sybase ASE 12,15 An Oracle instance consists of: A) Six processes: PMON Process Monitor, SMON System Monitor, DBWn Database Writer, LGWR Log Writer, ARCn Archiver, and CKPT Checkpoint. Additional processes on a 10g RAC system may include RECO Distributed Transaction Recovery, CJQn Job Coordinator Process, LCKn Shared Resource Locking, LMDn Global Lock Manager, LMON Lock Manager, LMS* Global Cache Service, MMAN Memory Manager, MMNL Metrics Monitor, session hitory, metrics computation, MMON Metrics Monitor, statistics, snapshots, and PSPn a PL-SQL plug in. B) Data files which contain the tables and other data objects, control files which contain configuration information, […]

Read more