Pinned

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

   Useful Queries using Active_Session_History information in Oracle

2. 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

   1

   2

   -- see https://hemantoracledba.blogspot.com/2021/04/using-sessionlongops-view-with.html  for a demo

   3

   4

   DECLARE

   5

   rindex    BINARY_INTEGER;

3. 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

4. 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

5. Oracle-DataGuard Oracle-DataGuard Public

   Scripts and Notes on Oracle DataGuard

6. View-Oracle-Stored-Program View-Oracle-Stored-Program Public

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

   PLSQL