SQL Performance (MOSC)

MOSC Banner

Analyze SQL Health Check

in SQL Performance (MOSC) 1 commentQuestion

Hi,


On oracle 12.1.0.2, by analyzing the behavior of a query from SQL HC, I realize that the number of fextch is at 0 after a certain time and that it does not vary any more thereafter. Do you have any idea about the possible reasons? Application problem ?


                

                
      
            

        

    





    

        Howdy, Stranger!    

    

            


    

            


    
Log In
To view full details, sign in to My Oracle Support Community.
 Register
Don't have a My Oracle Support Community account? Click here to get started.
    


										

										
										

	

				


					

    
		
		

		
					

			

				

					
									

			

			

			

				

    
    
    

        
        

    



			

			

			

								
			

			


							

    
    
    

        
Category Leaderboard

         
Top contributors this month

        

    



			
			


			

				
			

			

				


					
				

	



									

																


    
    

        

            
Instructions for posting

            ×
            

            

            
1. Select a discussion category from the picklist. 


            
2. Enter a title that clearly identifies the subject of your question.


            
3. In the body, insert detailed information, including Oracle product and version.


            
Please abide by the  Oracle Community guidelines  and refrain from posting any customer or personally identifiable information (PI/CI).


            
Cloud / Fusion customers - Our Cloud community has moved! Please go to  Cloud Customer Connect .


        

    



								
							

						

					

				

			

		

	







 



   






















	

		

			
New to My Oracle Support Community? Visit our Welcome Center

			MOSC Help Center