Re: Monitor a Query then retrieve data using process ID
Tread cautiously on the Query Cache.
* Do not have query_cache_size more than 50M -- pruning is costly.
* If you are frequently writing to the tables, the QC is of little use.
Have you "over-normalized"? If so, it may be beneficial to avoid some of the JOINs. I can explain if I can see the query.
Subject
Written By
Posted
Re: Monitor a Query then retrieve data using process ID
June 25, 2016 10:49PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.