In this article, I will explain what the PSP (Parameter Sensitive Plan Optimization) feature is. I would like to point out that this feature will …
Read More »
In this article, I will explain what the PSP (Parameter Sensitive Plan Optimization) feature is. I would like to point out that this feature will …
Read More »In today’s article, I will be explaining where we can download Pgadmin and How to Install it. Multiple tools are used to connect to PostgreSQL. …
Read More »In this article, I will talk about how to recover accidentally drop, truncate or deleted table in Production database by using flashback in standby database. …
Read More »In today’s article, we will be learning about Oracle Data Pump Architecture. It has 4 important components. -expdp (export data pump) -impdp (import data pump) …
Read More »In today’s article, we will talk about ORA 12638 credential retrieval failed tips. For the solution, we need to make the following change in sqlnet.ora …
Read More »Contained Databases is a database isolated from other databases and the instance of SQL Server hosting the database. SQL Server helps the user isolate the …
Read More »In this article, we will be learning the necessary configurations to connect to Postgresql from external. First, I will talk about two files. postgresql.conf and …
Read More »In today’s article, I will share the solution of the error given below when the delete obsolete command is run. Error: [crayon-63d84044533dd685576045/] Before deleting crosscheck …
Read More »In today’s article we will be learning how to Performing SwitchOver. 1. First, we move the logs in our live database. (PRIMARY_1) [crayon-63d84044539c9533185913/] (PRIMARY_2) [crayon-63d84044539d1205204008/] …
Read More »If you get this error while operating on a table on Oracle Database, it means that the table is being used by someone else. Error: …
Read More »