Reviewing configuration points database, similar to a tunning, without shutting down the server.
I ask for your kind reference to the next topic.
The oracle database, standard edition, version 11g Release 11.2.0.1.0, is operating in production, with an operating system suse linux LES 10. But with high concurrency, they have difficulty indices and improvements in some SQL. However, it has the interest of verifying a tunning, and has not been applied, because no tests can be done on the server to establish the optimal points and do not have similar equipment.
A. - Not wanting to suspend service production database, I can make some checkpoints that meet the basics of tunning?
2. - Could you please suggest me some details to consider that you have either the database?