It is possible to define the email notification for the scheduled job. An e-mail can be sent when a job-related event occurs. The following …
Read More »ORACLE
How To Move a Datafile in the File System to the ASM Disk Group
Files that are created accidentally or deliberately in the file system in a database that uses ASM often cause problems. In particular, a file …
Read More »How To Change the Size of the ACFS File System Online
We can change the size of the ACFS file system online without requiring any umount or disable volume. We use the acfsutil tool for …
Read More »How To Solve “gcs log flush sync” Wait Event
In busy databases you may encounter this wait event. The general reason is the low redo log I/O performance or the slow interconnect connection. …
Read More »Case Insensitive Queries in Oracle
The default is case sensitive, so the following query returns no lowercase. In this case, the returned result will contain missing data. [crayon-660618c0498a7574378136/] If …
Read More »How To Install ACFS (ASM Cluster File System) driver on RAC Database Servers
Oracle ASM Cluster File System (ACFS) is used to create a cluster file system via ASM. The created file system will use the space …
Read More »How To Find Locked Database Objects
There are many tables and views in Oracle database that we can get information about with locked objects. You can access a lot of …
Read More »Rman ORA-27086 unable to lock file – already in use
When you try to get a backup with Rman, if you get errors like ORA-27086, ORA-01580, the first place you should check is nfs …
Read More »Collecting Schema Statistics Collectively
In some cases, automatic maintenance jobs are closed in databases. In this case, the schema statistics are not collected and cause serious performance problems. …
Read More »ORA-20005 : object statistics are locked
If you receive errors in the form of ORA-20005 and ORA-06512 during the collection of the table statistics, you must unlock the relevant table …
Read More »