Oracle 事件之10046 跟踪的trace文件相关解释 tkprof


Oracle事件之10046 跟踪的trace文件相关解释 tkprof 优化




      sql_trace/10046事件是oracle提供的用于进行sql跟踪的手段,其内容包括sql的解析过程、sql的执行计划、绑定变量的使用、会话发生的等待事件。

    Oracle 事件之10046 跟踪的trace文件相关解释 tkprof

    在使用sql_trace/10046事件前,有两个参数需要注意:

  
  1. >              
  2.   
  3.                                            
  4.     
  5.                            
  6. >         
  7.   
  8.                                            
  9.     
  10.                             
  11.    

 

     

   

       

       

   

       

       

   

       

  
  1.           
  2.   
  3.               
  4.     
  5.                    
  6.                     


       

  
  1.     
  2.   
  3.      


       

  
  1.    
  2.   
  3.      


   

   

   

   

   

   

   

   

   

       

       

           

   

         

       

   

       

  
  1.           
  2.   
  3.               
  4.     
  5.                    
  6.                     


       

  
  1.    
  2.   
  3.      


       

  
  1.    
  2.   
  3.      


 




   

   

      

   

  
  1.     
  2.          
  3.                        
  4.            
  5.               
  6.               
  7.     
  8.              
  9.                         
  10.              
  11.                    
  12.                    
  13.              
  14.           
  15.           
  16.              
  17.                
  18.                 
  19.                
  20.             
  21.            
  22.           
  23.              
  24.                
  25.                 
  26.              
  27.               
  28.              
  29.            
  30.           
  31.              
  32.                
  33.                 
  34.            
  35.               







  
    
    
    
    
    
    
    
    
    
    
    
      
    
   
     
     
       
     
     
      
    
   
    


     
      
     
       


     


     


>>

    
    
    

    
    
    
    
    
    
    




   Oracle 事件之10046 跟踪的trace文件相关解释 tkprof



   Oracle 事件之10046 跟踪的trace文件相关解释 tkprof


    


    




    
    
    
    


   Oracle 事件之10046 跟踪的trace文件相关解释 tkprof


    Oracle 事件之10046 跟踪的trace文件相关解释 tkprof


    
    
    




    
    
    
    
    


   Oracle 事件之10046 跟踪的trace文件相关解释 tkprof


   Oracle 事件之10046 跟踪的trace文件相关解释 tkprof


    




   Oracle 事件之10046 跟踪的trace文件相关解释 tkprof



    
    
    
    
    
    




    


   Oracle 事件之10046 跟踪的trace文件相关解释 tkprof


   Oracle 事件之10046 跟踪的trace文件相关解释 tkprof



   Oracle 事件之10046 跟踪的trace文件相关解释 tkprof




>

    




















>



 





















  
















 




 

 

 

 

    

    

    

    

    

    <

     

     

 

 

      ><

      

      

     

     

    

      

    

     

    

 

 

    

    ><

    

              

              

 

 

 

      

    

  

    

  

 

 

     

    

    

    

    

     

     

      

      

    

 

    

 

   

   

 

Oracle 事件之10046 跟踪的trace文件相关解释 tkprof


Oracle 事件之10046 跟踪的trace文件相关解释 tkprof


 

    

 

 

       

       

 

 

 

 

 






 
        

    



  1.     


  


  1.   
        
     
      
      
     
      


      

      

      
      
      
      

      


                       
      
                                  
                                 
                            
      
                            

  



  1.  


     
     
                 
            
                
                     
                   
               
                
            

      
     
         
       
      
        
            
             
           
             
           
             
           
             
        
            
     
  
    


  1.                  
        
                         
                          
                        
                           
                           
                        

  



  1.                    
      
                                  
                                 
                            
      
                            




                     
        
                         
                       
                        
                          
                           
                           




                       
      
                                 
                                
                              
      
                              





                     
        
                          

        
       
       
       

         













 
 

 

 
 








 






 








 
  
  
  
 





  
  


  &













 




                    
 
                    
                    
                    
                    
                       



 








 

                    
 
                        
                        

 



 





                    
 
                        
                      
                        
                        

                    
 
                        
                      
 



 








                    
 
                  
                  

                    
 
                  
                  
                        
                        
                      
 


>>


 







>
 
                         

      
        
        
 


>

 









>
>
>
>
><>
 
                     

   
   
                     


>
    >>
 

>
 

>
  >
  >
  >>
 

>
  >
  >




                    
 
                    

                    
 
                        
                        
                    
                      
 


 






>>
>
>
>>
 



>
 

 

>
 



 

>
 

 

>
 





 
 






 






 











 



 










 



 

 

>

      

 

            

            

            

          

          

>   

    

    

>

      

        

        

 

  

    

 

    

      

    

      

>            

>   

>              

  

    

>>

>            

>              

>

>  

  

                                

  

  

  

                                   

>

>

          

         

>

   

    

  >  >     > 

    

  >  >    

                                      

  >  >     > 

 

                          

    

                                        

                                      

                                      

    

                                      

  

      

    

    

                          

    

                                        

                                      

                                    

    

                                    

     

            

    

    

>

    

    

>  

      

          

        

>                  

>

>

  

    

>

        

            

        

      

            

        

            

              

                

            

            

            

>

        

   

  

>                

>                

   

 

>              

>

>             

>              

>  

 

>  

                                                                                                                              

                                                                                                                                

      

>   

>

        

   

>  

    

  >  >     >

 

 

>  

>  

                                                                                                                            

                                                                                                                                

      

>   

>

        

   

>  

           

      

  

  

      

   

  

>  

  

      

>        

>

        

   

>  

 

>  

>

  

      

>    

>

        

   

>  

           

           

  

  

      

           

 

 

 

      


 

>                  

>    

>    

>       

  

    

>

       

      

>    

>

        

   

                          

    

                                        

                                      

                                      

    

                                      

      

    

    

    

    

  

                          

    

                                        

                                      

                                      

    

                                      

    

    

        

      

    

    

  

 

>                  

>      

>

>

>

>                 

  

  

>             

>               

  

  

>             

>

        

   

         

          

          

           

            

   

      

        

 

             

          

             

>>>

        

>

      

          

    

            

          

            

           

          

          

          

          

          

  

      

     

  

                          

    

                                        

                                      

                                    

    

                                    

    

    

  

  

  

                        

      

                              

                            

         



          







    

Oracle 事件之10046 跟踪的trace文件相关解释 tkprofOracle 事件之10046 跟踪的trace文件相关解释 tkprof

Oracle 事件之10046 跟踪的trace文件相关解释 tkprof
Oracle 事件之10046 跟踪的trace文件相关解释 tkprof
Oracle 事件之10046 跟踪的trace文件相关解释 tkprof

上一篇:我所理解的loT


下一篇:智慧酒店:锐捷网络打造的完美酒店