ORACLE

  It is useful to check occasionally whether everything is normal in the Oracle ASM instance. To do this, some information should be collected and …

  We can see asm files in Oracle ASM disk group without asmcmd. You can run the following query to view files and sizes in …

  The status of the Exadata cellnode flash disks may occasionally be poor performance. If the error numbers are 0 (zero) or too low when …

  When opening the database, if there is a redolog group that is not enabled for the corresponding thread, it gives an error as ORA-01618. …

  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 …