ORACLE

  In Oracle databases, when the Automatic Memory Management (AMM) is active, if the memory values grow and shrink too frequently, wait events can be …

  Oracle_client is required to connect to remote Oracle databases. For Oracle Foreign Data Wrapper, this installation needs to be done as follows. First of …

  The ARBn background process starts the rebalance process automatically when you delete or insert a disk from the ASM disk groups. This process is …

  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” …