861100 wrote:You can also find via GOOGLE that BUFFER CACHE HIT RATIO above 95% is needed for well tuned DB.
thanks for all , just when i go to google it and type increase the performance of insert query
first thing tell me set your table to nologging so there is no data was generated in redo ....
you search for tuning by writing:
"Oracle Database Tuning"
the first search gets you Lindsay Lohan ... the second gets you something of quality.
"Oracle Tuning + Christian Antognini" "Oracle Tuning + Tanel Poder" "Oracle Indexes + Richard Foote"
damorgan wrote:Excellent comment. There is, of course, always the exception. However, I believe OP is guilty of performing a web search and picking up the top result and using that as an explanation for his query's performance/redo log generation. I think this particular post belongs to part of the 10,000, to be fair.
For every example where disabling logging is a good idea ... there are 10,000 DBA/Developers trying the quick fix because they don't want to invest the time in figuring out why something is too slow.