How to list all privileges of a user
If you’re looking to learn all the privileges granted to a specific user, you can utilize the following data dictionary tables. Additionally, you have the option to utilize […]
More DetailsCategory: DBA
How to create or alter a job
So, basically, you can use the following code to create a job. If you want to modify the REPEAT_INTERVAL attribute of a job, you can use the DBMS_SCHEDULER.SET_ATTRIBUTE […]
More DetailsHow to fix cardinality misestimate?
In this post, I am going to explain how to correct the cardinality estimate in 5 different methods. Cardinality estimate is one of the first place to check […]
More DetailsHow to get OS environment variables in PL/SQL
If you need to find out the value of any OS environment variable, such as ORACLE_HOME, without connecting your remote server. You can use DBMS_SYSTEM.GET_ENV procedure as shown […]
More Details5 Life Saving Features of Oracle
1) Partitioned Outer Join I would like to start with PARTITIONED OUTER JOIN. Because it is one of the least used feature. Suppose that you have two basic […]
More DetailsSQL 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. In this post, I am going to show two different ways of it. First, via dynamic […]
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 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 Details