Hello, All ! Please your recommendations of volume size (data and log) and it's number for my system.
Description functioning database: Size of the storing data now is 1,2 Gb. And it's grow for about 200 Mb mounthly. By the way, basically the information in the database not update. As well as , I'm intresting for instance's parametrs for my database. I will hapy about your any recomend or about link.... >Pavel wrote: >> 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. >Well, first of all I have no experience with Oracle, so I can't really >say if those parameters you supplied are intersting. In general, my >experience is that SAP DB requires very little tweaking (from what I >have seen Oracle people seem to tweak their systems a lot, maybe some >Oracle expert can explain why those parameters aren't automatic in Oracle?). > >What I would like to know is: How much data do you have in your >database. And: how much data is data is being written to the database >every day? >�� �������� >Elias -- Best regards, Pavel (mailto:[EMAIL PROTECTED]) 20.02.2003, 04:29 _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
