Skip to content
View hemantkchitale's full-sized avatar
19 followers · 6 following

Achievements

Achievement: Pull Shark

Achievements

Achievement: Pull Shark

Block or report hemantkchitale

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Content in all repositories owned by your account will be closed.
Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse

Pinned Loading

  1. Oracle-ASH-and-AWR-Queries Oracle-ASH-and-AWR-Queries Public

    Useful Queries using Active_Session_History information in Oracle

    1 2

  2. Oracle Pro*C example code, with comp... Oracle Pro*C example code, with compiler commands
    1 
    ############
    2 
    This part is the shell scrip to compile the Pro*C source "instancedbinfo.pc" into "instancedbinfo.c and then into an executable
    3 
    
              
    
              
    
                4
                
    echo "*****Set LD_LIBRARY_PATH"
    
              
    
              
    
                5
                
    LD_LIBRARY_PATH=/usr/lib/gcc/x86_64-redhat-linux/4.8.2/include:/usr/include/linux:/opt/oracle/product/19c/dbhome_1/precom/lib:/opt/oracle/product/19c/dbhome_1/lib
    
              
    
          
    
    
    
  
    

    3. 

      

  3. 
  
    
    
    
      
    
        
        Loading Java code into OJVM for exec...  Loading Java code into OJVM for execution in an Oracle Database Session      
    

          
    
              
    
                1
                
    
              
    
              
    
                2
                
    -- see demo at https://hemantoracledba.blogspot.com/2021/04/ojvm-loading-java-code-and-running-it.html
    
              
    
              
    
                3
                
    
              
    
              
    
                4
                
    -- grant Java Code permission to only READ only /home/oracle/tmp
    
              
    
              
    
                5
                
    -- this should have been provided by the DBA
    
              
    
          
    
    
    
  
    

    4. 

      
  4. 
  
    
    
    
      
    
        
    
            
          Oracle-DataGuard  Oracle-DataGuard          Public
        
    
      
    


      
    
        Scripts and Notes on Oracle DataGuard
      
    

      
    
          
            
    

            3
          
      
    
    
    
  
    

    5. 

      
  5. 
  
    
    
    
      
    
        
    
            
          View-Oracle-Stored-Program  View-Oracle-Stored-Program          Public
        
    
      
    


      
    
        A PL/SQL Function to allow another user to view stored program code
      
    

      
    
          
  
  PLSQL


      
    
    
    
  
    

    6.