Originally Posted by yxez
Hi friend paresh....i really appreciate your dedication to learn :cool: I wish i could be like you too. Let me just share my thoughts :D
We have developed a new apps system....after which I set-up the
database for it to run on. I just remember I installed it with defaults
init parameters :) and it is running fine. I check the logs that you
are concern with and I saw the following:
log_group=3 the default ( with 1 member)
logsize =2M
log_buffer=163840
logs generated every 4 mins interval
My point is...as long as my OLTP meets the 3 seconds response time,
I dont need to change any parameters even if I used default values
during install.
Its really the application programs and design that has the greatest
affect of all to the performance. :)