In today’s article, we will be learning about the Alert files that we will write about the errors and changes in the Database. This file …
Read More »How To Install SSL Certificate In Oracle Weblogic Server
In this article, I will explain the process of creating and deploying SSL Certificates in Weblogic running on Oracle Linux operating system. First of all, …
Read More »PostgreSQL SUBQUERY
In today’s article, we will be cover about nested queries, namely SUBQUERY. In order to write a SUBQUERY, we need to pay attention to some …
Read More »Clear The Redo Log Group
In today’s article we will be learning to Clear The Redo Log Group. We can clear the redo log group with the following sql statement: …
Read More »SRVCTL (Server Control utility) Commands In Oracle
In today’s article, we will be learning what SRVCTL (Server Control Utility) is in Oracle and what its Commands are. SRVCTL is a service manager …
Read More »PostgreSQL Truncate
In today’s article, we will examine the PostgreSQL Truncate command, which deletes the data in the table regardless of any conditions. Its general usage is …
Read More »Query For Redo log Files
In today’s article, we will be learning to Query Redo log Files and get detailed information about Redo Log files. Querying Redo Log files; [crayon-673f0498a00c0975972119/] …
Read More »ORA-04036: PGA Memory Used By The Instance Exceeds PGA_AGGREGATE_LIMIT
In today’s article, we will cover the ORA-04036: error that comes at the end of the upgrade while performing an upgrade on the database. After …
Read More »PostgreSQL Delete
In today’s article, we will talk about the use of the ‘Delete’ command to delete one or more data in a Table. DELETE helps you …
Read More »Query Control File Information
In today’s article, we will be learning how to query the information held in the Control File. We make our query with the help of …
Read More »