Hello, Elias M��rtenson Thanks for recommendation!
On your order I produce description of our ORACLE SERVER which we planning extend to SAP DB 7.4. Parametrs: open_cursors = 80 max_enabled_roles = 10 db_block_buffers = 17000 shared_pool_size = 350000000 log_buffer = 2048000 sort_area_size = 1000000 db_block_size = 8192 sort_area_size = 1000000 Hardware configuration: RAM 768 Mb + 200 Mb in swap tow-proc PIII-600 Description of work: 100 active sessions. Almost all queries -- storage procedures. Now this system functioning very Ok! I'd like known about hardware and database parametrs, which i need to normal work our system on SAP DB 7.4. Original message: >To: [EMAIL PROTECTED] >From: Elias Martenson <[EMAIL PROTECTED]> >Subject: Re: (no subject) >Date: Tue, 18 Feb 2003 09:55:51 +0100 >Organization: Solid AB >Pavel wrote: >> Hello, All ! >> >> I'm novice in SAP BD. Please, answer to my question : >> >> What size you recommend for the data volumes, and their number ? >The answer to your question depends heavily on what you are going to use >the system for. The data volume size is easiest to estimate: Just take >the amount of data you are going to be putting in the database, add 50% >for unexpected overhead and database overhead and you should be heappy. >The log size depends on how much writes are being performed to the >database. If the data is very static (i.e. very few writes) you can get >away from a very small log area. If there are lots of writes and you >don't want to be taking log backups all the time you need more. >If you could tell us a bit more about what you intend to run on the >system, we might be able to provide better advice. >Regards >Elias M��rtenson -- Best regards, Pavel (mailto:[EMAIL PROTECTED]) 19.02.2003, 10:26 _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
