ORACLE

  For the database, the use of bind variables in queries is quite important. The hard parsing process in the database will increase when bind …

  When you set the resource_limit parameter to true in the database and set the idle_time parameter in the profiles to a value other than …

  You cannot always work with gui with DBCA. You can also perform all your operations in slient mode when you need to work from …

  If Goldengate doesn’t start with errors like this, the solution is very easy. Possible errors: Not enough database memory to honor requested MAX_SGA_SIZE of …

  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-676c520e4d28a406818462/]   If your …