SQL Plan Baselines
SQL plan baseline is one of the most used tuning technique in Oracle database. Basically, with SQL plan baseline, you can change the execution plan of a sql […]
More DetailsHow to find the SQL_ID of your SQL statement
There are different ways to find the SQL_ID of an SQL statement. First of all, if you have the select privilege, you can use the dynamic performance views […]
More DetailsThe easiest way to use Java in Oracle
There are several methods to use Java in Oracle. I am going to show the easiest way. Basically, the Java interpreter starts running the application by calling main() […]
More DetailsHow to run external scripts from DBMS_SCHEDULER
In this post, I am going to explain how to run operating system level script files with using DBMS_SCHEDULER. All tests have been done in Oracle 19c. Generally, […]
More DetailsHow to generate, parse and use JSON data
In this article, I will explain how easily you can generate, parse and use JSON data in the Oracle database. I used Oracle 19c for all examples in […]
More DetailsHow to flush a cursor from the shared pool
If you want to remove any cursor in the shared pool. You can do it easily via sys.DBMS_SHARED_POOL .PURGE procedure. 1. Get the address and hash_value of the […]
More DetailsHow to view alert log file
First of all, in order to find your log files location in the operating system where the database is located, you can query to V$DIAG_INFO view. It contains […]
More DetailsUseful Oracle Functions
How to find the difference between two dates If you want to find the difference between two dates according to different time types, you can use the EXTRACT […]
More DetailsHow to unregister materialized view from source DB
If a remote MV is no longer available or if you move to a new server because of data migration, version upgrade etc. and somehow don’t need the […]
More DetailsHow to get the contents of unknown SYS REFCURSOR
You can use the following procedure in order to get the unknown number of columns and column types.
More Details