Oracle

Summary: The Master database is a very important database because it holds the primary configuration of the SQL database. But in case if it is corrupted then the user has …

You should set STREAM_POOL_SIZE  2gb Disk quality and network bandwith should be high. You should add heartbeat source and target to analyezed lag. You should add batchsql , groupstransops 180000 …

  Hi ,   General errors and solutions for goldengate operations   1-) After goldengate upgrade from 12c to 19c , mapping error for replicat. You should add keycols parameter …

Hi, Sometimes You can get “RMAN-06941: Database must be closed and mounted EXCLUSIVE and RESTRICTED. ” error.  947 views last month,  3 views today

I will explain How to Add Disks to ASM Disk Group in Oracle with ALTER DISKGROUP DATA ADD DISK Command in this post. Let’s review the Add and drop Disks …

Hi, I will explain _ALLOW_RESETLOGS_CORRUPTION Parameter Usage in Case of Corruption in this post.  1,052 views last month,  3 views today

Hi Folks,   Conversion functions convert a value from one datatype to another. Generally, the form of the function names follows the convention datatype TO datatype. The NULL-related functions facilitate …

Hi, I will explain How to Apply PSU Patch in Oracle and Patch Apply Steps in this post. I will show you How to Apply PSU Patch in Oracle and …

Hi Folks,   Datetime functions operate on date (DATE), timestamp (TIMESTAMP, TIMESTAMP WITH TIME ZONE, and TIMESTAMP WITH LOCAL TIME ZONE), and interval (INTERVAL DAY TO SECOND, INTERVAL YEAR TO …

Hi Folks,   Functions are similar to operators in that they manipulate data items and return a result. Functions differ from operators in the format of their arguments. This format …