Pavel wrote:
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?).Hello, Elias M��rtensonThanks 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.
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
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
