ORACLE

  If you are wondering which execution plan the query is using when you run a query, you must run the command “set autotrace on …

  You can find the queries that are run in the database from v$sql, v$sql_text views, and who are running from sys.all_users. You can create …

  I will try to explain the identity feature, which is my favorite innovation in Oracle 12c. MS SQL and MYSQL users know the Identitiy …

  I tried to explain the apex installation step by step. Ensure that the Oracle Text component is also installed before you begin the installation. …

Enabling the archive log mode in the RAC database is slightly different from the normal database. You can enable archive log mode in the rac …

  You can use the following script to access SQL information in Oracle from a PROCESS ID on the operating system. [crayon-6742bb67b9192862347034/]   If your …

The Oracle Database produces reports that are called AWR at specific periods and that share the general status of the database. You can use the …

  A materialized view is a database object that contains the results of a query. The FROM clause of the query can name tables, views, …

  In some cases, we may need to know how many percent of the ASM disks are used. The following query shows the percentage of …

  In this article, I will show you how to recreate oracle central inventory in Real Application Clusters. This is not an usual routine work …