Skip to Main Content

Breadcrumb

Question and Answer

Chris Saxon

Thanks for the question, Gyan Bahadur.

Asked: February 06, 2019 - 2:22 pm UTC

Last updated: February 06, 2019 - 4:59 pm UTC

Version: 12C

Viewed 1000+ times

You Asked

Dear Tom,

I'm trying to test the oracle 12C reporting system, in which i will dump the oracle database transaction database backup to report system. For better performance of completed reporting system, what are the parameters i need to set perfectly, so that specially complex queries will get result within the time

and Chris said...

There are no database parameters you can set which will magically make everything "fast".

If there's a specific problem you're stuck with, post details and we'll see what we can do to help.

For more general background on performance, I recommend reading Thinking Clearly About Performance, an excerpt from Cary Millsap's book The Method R Guide to Mastering Oracle Trace Data:

https://method-r.com/2018/07/10/thinking-clearly-about-performance/

This gives a good introduction to how to approach performance problems.

There's also lots of good advice in the Database Performance Tuning Guide:

https://docs.oracle.com/en/database/oracle/oracle-database/18/tgdba/index.html

Is this answer out of date? If it is, please let us know via a Comment
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database