Oracle DBA with other interests
I am highlighting some gists as pinned on my profile page
Block or Report
Block or report hemantkchitale
Report abuse
Contact GitHub support about this user’s behavior. Learn more about reporting abuse.
Report abusePinned
-
Oracle-ASH-and-AWR-Queries
Oracle-ASH-and-AWR-Queries PublicUseful Queries using Active_Session_History information in Oracle
-
Sample PL/SQL code to use dbms_appli...
Sample PL/SQL code to use dbms_application_info.set_session_longops to populate v$session_longops 12-- see https://hemantoracledba.blogspot.com/2021/04/using-sessionlongops-view-with.html for a demo
34DECLARE
5rindex BINARY_INTEGER;
-
Oracle Pro*C example code, with comp...
Oracle Pro*C example code, with compiler commands 1############
2This part is the shell scrip to compile the Pro*C source "instancedbinfo.pc" into "instancedbinfo.c and then into an executable
34echo "*****Set LD_LIBRARY_PATH"
5LD_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
-
Loading Java code into OJVM for exec...
Loading Java code into OJVM for execution in an Oracle Database Session 12-- see demo at https://hemantoracledba.blogspot.com/2021/04/ojvm-loading-java-code-and-running-it.html
34-- grant Java Code permission to only READ only /home/oracle/tmp
5-- this should have been provided by the DBA
-
-
View-Oracle-Stored-Program
View-Oracle-Stored-Program PublicA PL/SQL Function to allow another user to view stored program code
PLSQL
6 contributions in the last year
Day of Week | March Mar | April Apr | May May | June Jun | July Jul | August Aug | September Sep | October Oct | November Nov | December Dec | January Jan | February Feb | March Mar | ||||||||||||||||||||||||||||||||||||||||
Sunday Sun | |||||||||||||||||||||||||||||||||||||||||||||||||||||
Monday Mon | |||||||||||||||||||||||||||||||||||||||||||||||||||||
Tuesday Tue | |||||||||||||||||||||||||||||||||||||||||||||||||||||
Wednesday Wed | |||||||||||||||||||||||||||||||||||||||||||||||||||||
Thursday Thu | |||||||||||||||||||||||||||||||||||||||||||||||||||||
Friday Fri | |||||||||||||||||||||||||||||||||||||||||||||||||||||
Saturday Sat |
Less
No contributions.
Low contributions.
Medium-low contributions.
Medium-high contributions.
High contributions.
More