ORACLE

  This article describes how to move a database in the file system into ASM. First, Grid Infrastructure installation is required. We are creating two …

  In this article, I will show you how to move a table to another tablespace. Actually it is very simple to move table with …

  You need the utl_mail package to send e-mail from the database. To use this package, the smtp_out_server parameter must be set. Also, “network acl” …

  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 …