Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> query tuning tip in oracle 11g
nsve
post Feb 15 2017, 04:39 AM
Post #1


Newbie
*

Group: Members
Posts: 2
Joined: 15-February 17
Member No.: 51,783



Hi All,

In our environment we have queries with same number of rows retrieval from a particular view ,but difference in the query conditions. We have multiples of these type of queries and they will execute high number of times in a day. As we are using same view for all these queries . Can we reduce the resource consumption and faster retrieval .Is there any way or some suggestion to tune this type of queries.

Thanks in advance.
Go to the top of the page
 
+Quote Post
nsve
post Feb 22 2017, 02:19 AM
Post #2


Newbie
*

Group: Members
Posts: 2
Joined: 15-February 17
Member No.: 51,783



Hi

Anyone has suggestions on this.
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 22nd August 2017 - 12:19 AM