Oracle Blog

Oracle Blog

Oracle SQL, PL/SQL and APEX

  • About Me

Category: DBA

How to get OS environment variables in PL/SQL

Posted on 01/11/202101/11/2021 by admin

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 Details
Posted in DBA, PL/SQLLeave a Comment on How to get OS environment variables in PL/SQL

5 Life Saving Features of Oracle

Posted on 16/06/202117/01/2023 by admin

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 Details
Posted in DBA, SQL1 Comment on 5 Life Saving Features of Oracle

SQL Plan Baselines

Posted on 23/05/202127/05/2021 by admin

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 Details
Posted in DBALeave a Comment on SQL Plan Baselines

How to find the SQL_ID of your SQL statement

Posted on 13/05/202113/05/2021 by admin

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 Details
Posted in DBALeave a Comment on How to find the SQL_ID of your SQL statement

How to run external scripts from DBMS_SCHEDULER

Posted on 18/04/202117/04/2022 by admin

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 Details
Posted in DBALeave a Comment on How to run external scripts from DBMS_SCHEDULER

How to flush a cursor from the shared pool

Posted on 03/04/202104/04/2021 by admin

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 Details
Posted in DBALeave a Comment on How to flush a cursor from the shared pool

How to view alert log file

Posted on 28/03/202103/02/2022 by admin

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
Posted in DBALeave a Comment on How to view alert log file

How to unregister materialized view from source DB

Posted on 14/03/202114/03/2021 by admin

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 Details
Posted in DBALeave a Comment on How to unregister materialized view from source DB

How to use Flashback

Posted on 10/01/202110/01/2021 by admin

Flashback feature is available only for enterprise edition. In this article, Oracle 19c has been used for all examples. With flashback feature you can recover your table or […]

More Details
Posted in DBALeave a Comment on How to use Flashback

How to create a temporary job

Posted on 26/12/202026/12/2020 by admin

Basically, you can create a single scheduler job by the following syntax. This job executes and drops itself automatically. If your procedure that used in the scheduler job […]

More Details
Posted in DBA, PL/SQLLeave a Comment on How to create a temporary job

Posts navigation

Older posts

Recent Posts

  • FOR UPDATE vs FOR UPDATE SKIP LOCKED
  • NVL vs COALESCE
  • How to use MULTISET UNION DISTINCT on collections
  • How to use PL/SQL functions within SQL
  • The power of MATCH_RECOGNIZE

Recent Comments

  • ENOCK OLOO on Data encryption and decryption using PL/SQL
  • Soeren Dalby on How to generate, parse and use JSON data
  • Nicolas on Print clob data with htp.prn
  • Anonymous on Unlock Apex admin account
  • Anonymous on How to reorder columns of table

Archives

  • January 2023
  • October 2022
  • April 2022
  • March 2022
  • February 2022
  • January 2022
  • December 2021
  • November 2021
  • June 2021
  • May 2021
  • April 2021
  • March 2021
  • February 2021
  • January 2021
  • December 2020
  • November 2020
  • May 2020
  • February 2020
  • January 2020
  • December 2019
  • May 2019
  • March 2019
  • January 2019
  • December 2018
  • November 2018

Categories

  • APEX
  • DBA
  • PL/SQL
  • SQL
  • Uncategorized
  • XQuery
© Copyright 2023, Çağlar Polat