Is this a reasonable way of getting adequate performance on this hardware/OS ? Since the ramdisk is relatively small, I have configured these tablespaces as fixed size on the ramdisk, with an additional expanding datafile for each tablespace located on the hard drive for overflow. I have also added the /3GB and /userva=2900 flags to boot.ini ,Īnd I've configured Oracle with a SGA_TARGET of about 2.3GB.īy putting a user data tablespace, a temporary tablespace, and an undo tablespace onto the ramdrive, I have been able to obtain huge performance improvements. I have installed Ramdisk software on the desktops, with Ramdisk sizes of 4GB or 11GB. The desktops are running Windows XP 32 bit, and have been configured with 8GB or 16GB of RAM. I have been tasked with getting maximum performance for our users. In the past, some of our large-data analysis could run for a couple of days, with CPU load hovering at about 1% and the disk seeking like crazy. Our analysts also keep archives of tens of gigabytes of old data in oracle, although that data generally does not require high-performance processing. ![]() csv files, and then loaded into Excel for presentation. The analyzed data is usually dumped into. ![]() The company that I work for uses Oracle10g Personal Edition to analyze data (usually from.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |